rendering problems after first page

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Reporting Svcs
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Page Break for table items Hi, I have created a report which includes a table. Into this table I put a sub report (detailed section of the table). Depending on the exisiting table data sub reports appear as often as datasets exists in the table of the "main" report. so far so good. When I am rendering the report to PDF everything is alright - Page numbers, Page breaks and so on -everything is fine too. But if I am rendering the report with the rendering format "HTML with Web Office Components" or in the default format I only see the table including the sub reports in one huge page. There are no page breaks and the page count is different (navigation bar in the top displays e.g. only 5 instead of 11 pages). Useless to say that the sub report includes page break settings/commands at the end! Is there a way to create page breaks within a table for each table item? thx for your feedback Tag: rendering problems after first page Tag: 30504
  - 2
    - how to disable log? Reporting services log grows very rapidly... how to disable them? Tag: rendering problems after first page Tag: 30503
  - 3
    - does it allow multiple user login from one reportserver account Dear all, i use networkcredentail("username", "password", "domain") to show the reports list into the dropdown list box. However, all the people access this page will also use this username and password. If one people using this account to load and show report, can any other people also connect with the same account from this page? Or it will be an error to say the access denied? Tag: rendering problems after first page Tag: 30500
  - 4
    - Print button generates hugh print files I have posted this before with no luck so I try again and hope for an answer. Hi! We are currently using a different third party tool to print out pdf-files generated from SQL Server 2000 Reporting Services. We are a fairly large international cooperation and have a centralized citrix it environment with different band width to different places in the world. This makes the print file size critical. Because there havenâ??t been any really good ways to print out reports before sp2 we have hoped a lot of the sp2 print functionality. Now itâ??s installed in our test enviromnet and we are pretty disappointed. It seems like the reports are converted to tiff-format and then printed and the print file size is huge. We tested to print out a report with six pages (A4-format) with different techniques and this is the result when it comes to spooled print file sizes: 1. Using RS print button (14.1 MB) 2. Exporting to TIFF-format from RS and than print (14 MB) 3. Exporting to PDF-format and print with gsprint (ghostscript) using a windows generic print driver (1.43 MB) 4. Exporting to PDF-format and print with gsprint (ghostscript) using a print driver specialized for the current printer, hp laserjet (852 KB) 5. Exporting to PDF-format and print with acrobat reader (531 KB) I have a couple of questions regarding this: 1. Is this right? Is the report converted to TIFF-format when pressing the print button and is it right that the spooled print file should be this large and in that case why is it done in this way? 2. Is there any work around for this? Is there any way to get a smaller file? 3. Is this the way it will be implemented in SQL Server 2005 as well? Regards, /Mattias Tag: rendering problems after first page Tag: 30499
  - 5
    - hardcoding password instead of showing password box everytime Dear all Everytime, when my aspx application connect with the reports, it will also show the password box for the input of username and password, however, can we avoid it to show the password box? I want to implicity hardcoding the username and password into the aspx and i don't want to show the password box in the IE Tag: rendering problems after first page Tag: 30498
  - 6
    - question about transfering Access stuff into RS Hi, I'm new to Reporting Services: 1) First a question: what's the difference between Views and Stored Procedures? I am rewriting an Access Database to take it into RS....in there, I have 4 tables, 1 query and a report that depends on that query. 2) I need to make a new project in RS. The report wizard has asked me to Design the Query. Since I am rewriting my Access Database, I already have the following query from Microsoft Access. But it doesn't work in RS. I get errors. The errors are the following: 1) There's an error in the query. Line 2. Incorrect Syntax near '=3D' 2) Line 39. Incorrect syntax near 'DateConvert' The query is below. Please kindly help!!! SELECT Departments.Department, DESKS.Desk_ID, DESKS.Description, TRACE.TicketNumber, TRACE.Ticker, TRACE.Cusip, TRACE.Trace, TRACE.BuySell, IIf([Amount_Ind]=3D0,[Amount], IIf([Amount_Ind]=3D1,([Amount]/1=AD0), IIf([Amount_Ind]=3D2,([Amount]/1=AD00), IIf([Amount_Ind]=3D3,([Amount]/1=AD000), IIf([Amount_Ind]=3D4,([Amount]/1=AD0000), IIf([Amount_Ind]=3D5,([Amount]/1=AD00000), IIf([Amount_Ind]=3D6,([Amount]/1=AD000000),"PLEASE CHECK"))))))) AS Quantity, IIf([Price_Ind]=3D0,[Price], IIf([Price_Ind]=3D1,([Price]/10)=AD, IIf([Price_Ind]=3D2,([Price]/100=AD), IIf([Price_Ind]=3D3,([Price]/100=AD0), IIf([Price_Ind]=3D4,([Price]/100=AD00), IIf([Price_Ind]=3D5,([Price]/100=AD000), IIf([Price_Ind]=3D6,([Price]/100=AD0000), IIf([Price_Ind]=3D7,([Price]/100=AD00000), IIf([Price_Ind]=3D8,([Price]/100=AD00000),99999))))))))) AS Price2, DateConvert([Date]) AS Date2, TRACE.Time, TRACE.AsOfTime, DateConvert([AsOfDate]) AS AsOfDate2, TRACE.CustomerAccount, TRACE.DFA_BrokerCode, TRACE.Status, TRACE.ConfirmNumber, TRACE.RejectMessage, TRACE.RecType, TRADE_TYPE.Description, IIf(TRACE.RecType=3D"XTT",1.5,0) AS [Canceled Trade Fee], IIf(TRACE.RecType=3D"CTT",1.5,0) AS Corrections, IIf(TRACE.RecType=3D"PXT",3, IIf(TRACE.RecType=3D"PCT",3, IIf(TRACE.Date>TRACE.AsOfDate,=AD3,0))) AS [Late As Of Rpt Fee], IIf([Quantity]<201000,0.475, IIf([Quantity]<1000000,[Quanti=ADty]*0.000002375,2.375)) AS [Trade Report Fee], [Canceled Trade Fee]+[Corrections]+[Late As Of Rpt Fee]+[Trade Report Fee] AS [Total Trace Fee] FROM TRADE_TYPE INNER JOIN ((Departments RIGHT JOIN DESKS ON Departments.Department =3D DESKS.Department) RIGHT JOIN TRACE ON DESKS.Bloomber_Desk_ID =3D TRACE.Trader) ON TRADE_TYPE.RecType =3D TRACE.RecType WHERE (((DateConvert([Date]))>#2/28/=AD2005# And (DateConvert([Date]))<#4/1/200=AD5#) AND ((TRACE.ConfirmNumber) Is Not Null))=20 WITH OWNERACCESS OPTION; Tag: rendering problems after first page Tag: 30493
  - 7
    - Cannot add web parts to new page I have a WSS site that we have been using for many months (multiple pages, multiple sub-sites). Today I added a new page to the site (Modify This Workspace->Add Pages). The page appeared OK, but when I attempt to add a web part to the page I get this error in the web part pane... "The Web Part you attempted to add no longer exists in the Web Part Page Gellery. It may have already been added to the Web Part Page. Refresh your browser to update the Web Part Page and the Gallery." It doesn't matter which web parts I try to add. I can't add any of the standard web parts/lists (Events, Attendees, Page Viewer, etc.) or any third party web parts. I CAN add any of the web parts to any of my existing pages on any sub sites. This problem is ocurring only on new pages I add today. I have attempted to add the web parts while in FrontPage with no luck (same error message). I have done an IISRESET. I am hesitant to reinstall anything as this is a production server used by the entire company. Thanks for any help you can give. IAN Tag: rendering problems after first page Tag: 30491
  - 8
    - Problems with Scheduled Emailing on Datasources I'm trying to set up my report server to send reports by email to my management team in the company but I'm unable to do so. It seems like the report server is able to send hyperlinks but not any other format. The error I receive is strangely these, "Cannot create a connection to data source 'Datawarehouse'" "Database 'Datawarehouse' does not exist" This "Datawarehouse" is a Analysis Service datasource. Below is my connection string Connection Type = OLE DB Connection String Provider=MSOLAP;Client Cache Size=25;Auto Synch Period=10000;Data Source=AP5184;Initial Catalog=Datawarehouse I have no problems accessing the reports from the web browser but why is RS reporting that the datasource cannot be found? Anyone got any idea? Any advice is appreciated. Tag: rendering problems after first page Tag: 30485
  - 9
    - Simulate "create snapshot" functionality in a custom .aspx page Hi all, I have posted a similar question in this forum a while ago and I wanted to rephrase that question and hence this mail. for reference, I have included a thread that someone already posted and something very close to what I wanted(although, she wanted it to be done thru a .rss file whereas I am trying to do it from a .aspx page). I am trying to simulate the "creation of snapshot" of a report from a custom .aspx page. I would like to know if there any such thing-- possible. Thanks Jammer --------------------------------------------------------------------------- Hi Wayne, I found a solution to do this but I am not sure if it is preferred In the RSS file I use the following lines to create a snapshot for a given report: 'check if the report is rendered already from a snapshot. If not, create one... If Not rs.GetExecutionOptions(item.Path, scheduletype) = ExecutionSettingEnum.Snapshot Then rs.SetExecutionOptions(item.Path, ExecutionSettingEnum.Snapshot, scheduletype) End If 'update the snapshot rs.UpdateReportExecutionSnapshot(item.Path) Note that scheduletype is an object of type ScheduleDefinitionOrReference Q "Wayne Snyder" wrote: > I do not think that information is strored in the report xml file, but is in > the reporting services database.. YOu could store the info in the rrs file, > but you would have to write a program that parses the file, and does the > rendering yourself... > > -- > Wayne Snyder, MCDBA, SQL Server MVP > Mariner, Charlotte, NC > www.mariner-usa.com > (Please respond only to the newsgroups.) > > I support the Professional Association of SQL Server (PASS) and it's > community of SQL Server professionals. > www.sqlpass.org > > "Qbee" <Qbee@discussions.microsoft.com> wrote in message > news:897C0886-44FE-45FA-A658-C67D931BF51E@microsoft.com... > > Hi all, > > > > I want to simulate the "Render this report from an execution snapshot" and > > "Create a snapshot of the report when the apply button is selected" > > functionality from as .rss file. > > > > Any ideas? > > > > Thanks. > > > > Q > > Tag: rendering problems after first page Tag: 30484
  - 10
    - get SQL RS snapshot functionality working in a custom webpage Hey experts, I would like to know if there is a way to implement the "snap shot" functionality available in the SQL Reporting services in my own custom webpage.Like after my initial investigation, I found out that once the report is set to 'snapshot' mode, it is gonna be stored in the data server as a binary-encoded-format. Someone please confirm my investigation and also let me know if I could accomplish the same task from my own webpage(.aspx). I need an idea before I could discuss this with my team. thanks much for your continuous support Jammer Tag: rendering problems after first page Tag: 30482
  - 11
    - There is no Business Intelligence Projects folder in VB .net 2003 I've installed SQL reporting services on one of our SQL servers along with the .net framework. I then installed VB .net 2003 and I'm trying to open a new project to create a report. When I click on new project, the new project window opens, but there is no Business Intelligence Projects folder to choose a new report project from. Tag: rendering problems after first page Tag: 30481
  - 12
    - Generate Ad-hoc Reports with Microsoft Reporting Services 2005 article available Just a quick note to let you know about the availability of my article (http://www.devx.com/dbzone/Article/28047) about ad-hoc reporting with RS 2005. It explains the major components of Microsoft Reporting Services' ad-hoc architecture and semantic model, and walks you through an end-to-end example that demonstrates how to author, manage, and deliver ad-hoc reports. Happy ad-hoc reporting! --------------------------------------------- Teo Lachev, MVP [SQL Server], MCSD, MCT Author: "Microsoft Reporting Services in Action" --------------------------------------------- Tag: rendering problems after first page Tag: 30480
  - 13
    - Auto Generate Columns Is there a way, just like a datagrid, to auto generate the columns? I have a dynamic sql query, and some columns might not need to be displayed, so it would be best if the report would do it itself. Tag: rendering problems after first page Tag: 30479
  - 14
    - where is Report footer? I'd like to add a report footer to my report,but I don;t find it.Where is it? I have a Group footer and Page footer there,but can't find the report footer. Thanks Tag: rendering problems after first page Tag: 30478
  - 15
    - open report in new browser window Anyone know how to force the report to open in a new browser window? I am using the render method for example to create my report in pdf format. My problem is that it is embedded in my application and the report replaces all data on my webform and I have to hit the browsers back button to clear the report and proceed. I would rather just open in a new window and close it accordingly and return to my webform unchanged. -- Kristin Tag: rendering problems after first page Tag: 30477
  - 16
    - Custom Forms Authentication - fails every two or three hours after working fine. I'm enclosing the pertinent log entries form the ReportServer_DD_DD_DDDD_HH_MM_SS.log file. Problem: I've written a custom forms auth extension that (naturally) works fine in the test environment. In production, under about 25 - 20 users (80 - 150 report requests) per hour, everything works fine until after about two or three hours, for some reason, the following errors (below) appear in the log, and in the event log an error is thrown that simply states: "Report Server cannot load the forms extension." Then, no can access the report manager becuase you get an error that says a configuration file for report server was changed and it can't acces report server (sorry, i don't have the exact message text). NO CHANGE HAS BEEN MADE TO ANY CONFIG FILE! All I then do is restart the reporting service and restart IIS, and everything is just fine again for a few hours. My client has to have this Single Sign on solution, and it works really nice. But to have it go down every few hours on the production server doesn't instill confidence. The following two line from the report server logfile reference something about trying to add a 'delete schedules' key. We don't allow any subscriptions, nor do we have any custom schedules defined. We do have Sql Agent running for data feeds and execution log stats on our db server. I don't know where its getting 'delete schedules' from. Any help would help... btw we're running WIN2003 SP1, ENT RS SP1 on web server, WIN2003 SP1 on database server. here's the log file entries: w3wp!extensionfactory!c70!05/10/2005-15:12:03:: e ERROR: Exception caught instantiating report server extension: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ArgumentException: Item has already been added. Key in dictionary: "DeleteSchedules" Key being added: "DeleteSchedules" at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at Thrivent.FPM.ReportingServices.CustomSecurityExtension.Authorization.InitializeMaps() at Thrivent.FPM.ReportingServices.CustomSecurityExtension.Authorization..ctor() --- End of inner exception stack trace --- at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly) at System.Activator.CreateInstance(Type type, Boolean nonPublic) at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) at System.Reflection.Assembly.CreateInstance(String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) at System.Reflection.Assembly.CreateInstance(String typeName) at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.AssertAndCreate(Assembly assembly, String typeName) at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.AssertAndCreate(Assembly assembly, String typeName) at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.GetNewExtensionInstance(String extensionName, String extensionType). w3wp!extensionfactory!34c!05/10/2005-15:12:03:: e ERROR: Exception caught instantiating report server extension: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Exception: Number of catalog names don't match. at Thrivent.FPM.ReportingServices.CustomSecurityExtension.Authorization.InitializeMaps() at Thrivent.FPM.ReportingServices.CustomSecurityExtension.Authorization..ctor() --- End of inner exception stack trace --- at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly) at System.Activator.CreateInstance(Type type, Boolean nonPublic) at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) at System.Reflection.Assembly.CreateInstance(String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) at System.Reflection.Assembly.CreateInstance(String typeName) at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.AssertAndCreate(Assembly assembly, String typeName) at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.AssertAndCreate(Assembly assembly, String typeName) at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.GetNewExtensionInstance(String extensionName, String extensionType). w3wp!library!34c!05/10/2005-15:12:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files, Could not load Authorization extension; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files w3wp!library!c70!05/10/2005-15:12:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files, Could not load Authorization extension; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files w3wp!processing!34c!05/10/2005-15:12:03:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: The Report Server has encountered a configuration error; more details in the log files w3wp!processing!c70!05/10/2005-15:12:03:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: The Report Server has encountered a configuration error; more details in the log files w3wp!processing!34c!05/10/2005-15:12:03:: e ERROR: Stack trace: at Microsoft.ReportingServices.Library.Security.get_AuthorizationExtension() at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper) at Microsoft.ReportingServices.Library.RSService.ProcessingGetDataSources(CatalogItemContext reportContext, String subreportPath, CatalogItemContext& subreportContext, GetReportChunk& getCompiledDefinition, DataSourceInfoCollection& dataSources) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, ServerDataSourceSettings A_7) w3wp!processing!c70!05/10/2005-15:12:03:: e ERROR: Stack trace: at Microsoft.ReportingServices.Library.Security.get_AuthorizationExtension() at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper) at Microsoft.ReportingServices.Library.RSService.ProcessingGetDataSources(CatalogItemContext reportContext, String subreportPath, CatalogItemContext& subreportContext, GetReportChunk& getCompiledDefinition, DataSourceInfoCollection& dataSources) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, ServerDataSourceSettings A_7) w3wp!library!c70!05/10/2005-15:12:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files, Could not load Authorization extension; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files w3wp!processing!c70!05/10/2005-15:12:03:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: The Report Server has encountered a configuration error; more details in the log files w3wp!processing!c70!05/10/2005-15:12:03:: e ERROR: Stack trace: at Microsoft.ReportingServices.Library.Security.get_AuthorizationExtension() from here on everything comes up with the same error. Tag: rendering problems after first page Tag: 30475
  - 17
    - Security groups not working in RS I have RS installed and different security groups set on the server and those groups set up as browsers in RS. On the Home folder I have all groups present. On different sub folders I exclude different groups. I thought this should make that folder not viewable to users in that group. What I am finding is all the folders are viewable to all users in all groups. However, when a user in an unauthorized group tries to actually view a report they get rsAccessDenied. Is this how the security is supposed to work? If not, anyone have any ideas what I have configured incorrectly? Thanks for your help Tag: rendering problems after first page Tag: 30468
  - 18
    - disable client-side printing If we disable client-side printing, is it done at the server level or folder level? Tag: rendering problems after first page Tag: 30466
  - 19
    - Updating Report Server and Report Designer We would be updating the Report Server and Report Designer pieces together. If we update the Designer to SP 2 for testing, will that developer still be able to deploy to a production server at level SP 1 without problems? Tag: rendering problems after first page Tag: 30465
  - 20
    - definite sequence for install?? Is there a definite sequence for applying Windows 2003 SP 1, Reporting Services SP 2, and SQL Server SP 4? We are looking to avoid a reinstall of Reporting Services SP 2. At this time, there are no definite plans for any of the service packs mentioned. What would be the best sequence of events â?? or doesnâ??t it matter? Tag: rendering problems after first page Tag: 30463
  - 21
    - Chart - X Axis Can the labels on the x axis be rotated so that they display vertically. The user wants a report that shows the month-year like May-2005, but with the text rotated 90 degrees. Tag: rendering problems after first page Tag: 30462
  - 22
    - Insert a value in a SQL query result for a parameter list. I can create a parameter list box with values from a query from a database table. Note: The database table does not contain any spaces or Nulls. I am trying to find out if it's possible to have a value inserted into the results of the SQL query. This value could be a space or specific value. For example of the SQL resuts: Medium Low High Urgent I would like to insert a space into the above query results. Is this possible. Thanks. Tag: rendering problems after first page Tag: 30456
  - 23
    - problem after deploy After deploy already tested report to customer's ReportServer I have a very strange problem: 1.Embedded image is missed at all in Header,but after export report to pdf it exist. 2.Pressing on + icon for get subreport does not do nothing.No call to subreport.Testing subreport standalone works fine. What can be problem?Where I can check errors? Thanks, Vladimir Tag: rendering problems after first page Tag: 30455
  - 24
    - Use of System SPs in RS I need to pull up table dependencies in a report that I'm doing. Of course, SQL has a great tool for doing this in QA or EM, sp_depends @objectName. The problem being that because it returns multiple result sets due to its error trapping, so I can't see any fields available to choose from when I use this SP. Has anyone else used a system SP in RS? If so, how did you modify it to work correctly? Um, quick note: when I say "modify it", I don't mean did you modify the system SP, but did you create a user SP using part of the code or did you strip some code and put it in a DataSet text box? Thanks! Catadmin Random Thoughts: Just when you think life is getting easy, your boss will invent the impossible problem and turn to you for the solution. Tag: rendering problems after first page Tag: 30451
  - 25
    - Sub-report page headers Is there a way to have the page header and footer show up in a subreport? Basically I have 3 seperate "customer service" reports. I want to combine all 3 into one report to ease the printing of the report. I'm able to add all 3 reports to one main report, but then I lose the page header that is specific to each report. Or maybe there is a better way to accomplish this task? On a side note, is there a way to use snapshots inside sub-reports? Thanks, bill Tag: rendering problems after first page Tag: 30449
- Next
  - 1
    - SP2 Print Error I just installed SP2. I republished my report. When I view the report within my web application, I now see a print icon. When I click on the print icon, I get the following error: An error occurred during printing. (0x80004005) Does anyone know what this means? Tag: rendering problems after first page Tag: 30447
  - 2
    - The Globals Collection Regards, I'm looking for a way to return the current report URL (including QueryString) inside of a report. So for instance: https://reports.company.com/reportserver/?%2fCustom+Reports%2fPharmaReport&rs:Command=Render Would return the above URL including the ending querystring. I know that I can use the following formula: =Globals.ReportServerURL & Globals.ReportFolder & Globals.ReportName, but how do I return the "?%2fCustomer_Reports%2fPharmaReport&rs:Command=Render"? Any help would be greatly appreciated! Thanks, Ben Tag: rendering problems after first page Tag: 30446
  - 3
    - Notifcation Services and scheduling MSRS reports A guy here told me to check out using Notification Services to schedule a MSRS report. Anyone here used it or think it's even a good idea? Tag: rendering problems after first page Tag: 30441
  - 4
    - What is the procedure for upgrading from evaluation version to the regular one? My evaluation version has expired and I am wondering what the simplest procedure for upgrading to the regular version is. SP1 for reporting services is installed and it makes reporting services db format incompatible with RTM. Should I choose a different db name, install SP1 and then change db name to my original db? Should I also export the encryption key? Thanks, -Stan Tag: rendering problems after first page Tag: 30438
  - 5
    - Report Designer I installed RS on a SQL 2K server. Installation went fine. I didn't install the Report Designer since I have VS.NET on my XP box. However when I open VS.NET I don't see Business Intelligence project. Does it need to install as add-on in VS.NET? Thx. Tag: rendering problems after first page Tag: 30426
  - 6
    - Forms authentication sample and Win XP pro /win 2k3 server I developed an app which uses the forms authentication sample from microsoft as a security extension, but since i upgraded my system to sp2 it stopped working, besides it doent work on a win2k3 server but it works on a win2k, the problems seems to be with ssl im using the selfssl utility to get my cerificates as im still working on a test environment, but even if i get a test certificate from a trusted provider it tells me it doenst trust it. the message is the following " The underlying connection was closed: Could not establish trust relationship with remote server. " this happens when calling the logonuser method using soap, ive tried changing all the adresses in the config files for https but it doesnt work. Tag: rendering problems after first page Tag: 30421
  - 7
    - Multicolumn Mailing Label I've got a report that is supposed to output on an Avery 5160 sized (1" x 2.5") label. The report is set up with a 1" tall x 2.5" wide data area, 3 columns, appropriate gutters and margins. It seems that I'm having to do a lot of really small tweaks to get everything to line up correctly on a label sheet. Also, I;m having a problem with the reporting items not staying together at the end of columns (meaning that it will split a label in half, which is not good). I used a table to do my layout for the report. Should I have used textboxes instead? Just looking for some hints that will make this less painful, 'cause it's really ugly now. Thanks, Brandon Tag: rendering problems after first page Tag: 30418
  - 8
    - Watermarks I cannot seem to figure a way to implement a watermak. Does anyone have any suggestions? Thanks Josh Tag: rendering problems after first page Tag: 30417
  - 9
    - Problems with OLE headers for images (bmp) I'm using Reporting Services to create some reports that need to read database images. Those images are stored using a front-end MS Access project (adp), hence, every image has a OLE header store with it inside the database. I have read about striping those 78 bytes of the OLE head when you read it back. However, since we use Spanish version of Office 2003, that size is not 78 bytes but 88 bytes. LEN('Bitmap image') = 12 LEN('Imagen de mapa de bits') = 22 22-12 = 10 bytes longer in spanish. Other aproach that I have been told about is Reporting Services to remove the ole header setting the Value of the Image component to: =System.Convert.FromBase64String(Mid(System.Convert.ToBase64String(Fields!MyImageField.Value), 105)) But that fixed 105 is also language specific. After a day of tests I have guessed that for spanish ole headers the value that I need to use is around 121 but I haven't been able to make the image component show the picture at all. I always get red crosses. 1st Question: Is there any general way to remove the OLE header no matter the language, version, etc of the program that has written the image into the database? Any API function or whatever? 2nd Question: In Reporting Services, after a lot of tests, the best thing that I have been able to do is removing the OLE header directly in the query, by using select clauses like this: SELECT SUBSTRING(MyImagField, 89, DATALENGTH(MyImagField) - 89) AS MyImageField FROM MyTable in order to strip the header from the images that I have in the database (89 is spanish specific, for english you should use 79). However it seems I'm missing something since the Image fields in the report show red crosses on them as if the data being shown by that component was not properly formatted (corrupted). Any hints about this subjects? If the OLE header problem cannot be solved, is there any workaround for it? like not writing OLE headers at all inside the database and just the raw image data? How? Thanks in advance. Regards. Tag: rendering problems after first page Tag: 30413
  - 10
    - Report Server doesn't install Hi!! I'm trying to install SQL Report Services on my mahicne. I get the designer installed, as well as other tools, but the Report Server doesn't get installed, and I can't open or deploy any report. I have WXP Pro, S2K SP4, RS Dev Edition SP1, and using my admin account. The "ReportServer" or "Reports" virtual forlders on IIS doesn't exist after installation, nor does the "ReportServer" folder under the SQL Server harddisk folders. Anyone has experimented the same problem? Any help is really appreciated! Many thanks in advance!!! MNB Tag: rendering problems after first page Tag: 30410
  - 11
    - Matrix width How do you find out the width of a matrix control, I need this to enable me to size the width of a Textbox, as the width needs to be the same size as the Matrix control which keeps growing depending on the data Tag: rendering problems after first page Tag: 30408
  - 12
    - Martix sort and English dates I have a Matrix which is has its columns as dates, when I select the sort order they get sorted, but the problem I have is that when it is in US date format, it sorts all okay, but in English date format (dd/mm/yyyy) it does not sort correctly, it appears to sort in a string format not the actual date. Anyone seen this or know about how to fix it? Tag: rendering problems after first page Tag: 30406
  - 13
    - Field names must be CLS-compliant identifiers. While creating a report using 'CreateReport' API method for Report Services 2000, I am getting the following error. // A field in the data set â??MainDataSetâ?? has the name â??Count Borrower Nameâ??. Field names must be CLS-compliant identifiers. --> A field in the data set â??MainDataSetâ?? has the name â??Count Borrower Nameâ??. Field names must be CLS-compliant identifiers. // The error occurs due to the space on the computed field name. If I concatinate the words with '_' (for example) then I do not get an error. I would like know how can I create report that has field with the name like â??Count Borrower Nameâ??, etc? Thanks. -Sue Tag: rendering problems after first page Tag: 30402
  - 14
    - Report Parameter Display Formatting I have a report where I want to create a boolean parameter that has two radio buttons, where one radio botton has label "With Approval" and the other radio buttons label says "No Approval (Under Review or No Request), plus there is not leading text prior to the first radio. Basically I want my report parameter display to look like this: X - With Approval X - No Approval (Under Review or No Request) Note: X in the above text is the radio button. How is this done? I can easily set up the two radio buttons, with a single boolean report parameter, but I can only get the labels to say "true", or "false", plus a leading label that says "With Approval". Some thing like this: With Approval X true X false Tag: rendering problems after first page Tag: 30401
  - 15
    - Security Concept Hello togheter I'm a "new" Developer and I try to develop a salary-management-web-application with asp.net and sql. Now i will set up a right security-concept (so I can use it also in future) I'm searching for Articles or any informations where i can find diffrent kind of security-concepts for webapplication. Thx Michele Tag: rendering problems after first page Tag: 30397
  - 16
    - Using RS in ASP Give me some samples how to use reporting services in ASP. I have done with ASP.NET. Is there any possible way to use the rdl other than .NET application. Thanks In advance. Tag: rendering problems after first page Tag: 30396
  - 17
    - Legend Text Wrapping The text in my pie chart legend does not wrap. It is cut off ending with "...". Is this by design? Tag: rendering problems after first page Tag: 30395
  - 18
    - Format of input parameters Hi I've got a report which takes a start & end date as parameters. It works fine, except that RS seems to insist on my users typing US format dates (mm/dd/yy) rather than UK format (dd/mm/yy). Does anyone know how to change this? Sorry if this gets posted twice - cookie problems Chloe Tag: rendering problems after first page Tag: 30391
  - 19
    - Permitted Host Problem I have Reporting Service up and running and able to send email of the reports. I have a request from a client to set their system up so that reports are email to approved recipients. I have the DefaultHost (called DomainA) to the local SMTP domain, and have put in a domain in the PermittedHost (called DomainB), in the config file. When I send a report the the permitted DomainB, works fine. When I send same report to DomainC, (which is not a permitted host) and that report gets delivered also. I would think that since it was not a permitted host the report should have not been sent. Am I missing a configuration? If there were multiple hosts to permit, would they be separated with a comma(,) or semicolon (;)? The SMTP server has been setup to relay to a Smart Host for delivery. Below is my email configuration. I show the current setup and I also have show a 2nd setup that I have tried, but get the same results. <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider"> <MaxRetries>3</MaxRetries> <SecondsBeforeRetry>900</SecondsBeforeRetry> <Configuration> <RSEmailDPConfiguration> <SMTPServer>Relay Server</SMTPServer> Current Setup #** <SMTPServer>localhost</SMTPServer> Have also tried Setup #2 <SMTPServerPort></SMTPServerPort> <SMTPAccountName></SMTPAccountName> <SMTPConnectionTimeout></SMTPConnectionTimeout> <SMTPServerPickupDirectory></SMTPServerPickupDirectory> Current Setup #** <SMTPServerPickupDirectory>c:\inetpub\mailroot\Pickup</SMTPServerPickupDirectory> Have also tried Setup #2 <SMTPUseSSL></SMTPUseSSL> <SendUsing></SendUsing> Current Setup #** <SendUsing>1</SendUsing> Have also tried Setup #2 <SMTPAuthenticate></SMTPAuthenticate> <From>Server@DomainA.com</From> <EmbeddedRenderFormats> <RenderingExtension>MHTML</RenderingExtension> </EmbeddedRenderFormats> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats> <ExcludedRenderFormats> <RenderingExtension>HTMLOWC</RenderingExtension> <RenderingExtension>NULL</RenderingExtension> </ExcludedRenderFormats> <SendEmailToUserAlias>True</SendEmailToUserAlias> <DefaultHostName>DomainA</DefaultHostName> <PermittedHosts>DomainB.com</PermittedHosts> </RSEmailDPConfiguration> </Configuration> Server Information (This is a development server, so everything is installed): W2K3 w/IIS and SMTP SQL 2000 SP3a SQL Reporting SP2 If you need more information, please let me know. Thanks in Advance for any help, Zing1atu Tag: rendering problems after first page Tag: 30390
  - 20
    - ReportingServices...add on? Does anyone know if the reporting services is an add-on to the SQL server license or does it have its own license that must be purchased? Tag: rendering problems after first page Tag: 30389
  - 21
    - Parameter in ReportingService I believe a simple question..but I'm new to SRS. I have three parameters. Two are pulling from queries which makes them drop downs, The first is a simple select query which upon selection passes a parameter of its value to the second. the third is a free form field which a person enters a date. For some reason upon selection of the first parameter, the second combo does not fire off... it waits until the date field is filled in and the view report button is clicked before it will fill. I have the parameters in the right order on the report parameters page so I am a bit at a loss as to what the problem is... Any help would be appreciated Dan Tag: rendering problems after first page Tag: 30387
  - 22
    - Start Report after a Succesful DTS-Package Hi, I dont want to Schedule our Reports, because I dont know when the data delivery of our DTS-Packages is finished. So is there a possiblity to Start a Report within a DTS-Package (after Success). Thx in Advance, Regards, Dieter Felix Tag: rendering problems after first page Tag: 30386
  - 23
    - Missing header in PDF I've built a fairly straight forward report in RS that looks normal in preview mode and HTML rendering but when I export it to PDF the column header row is missing when i just have group-footer on the page without any detail columns. The column headers are in the group header and RepeatOnNewPage is set to True. Any ideas as to why this is occurring? Any solutions? thnx Tag: rendering problems after first page Tag: 30385
  - 24
    - subreports This is a multipart message in MIME format. --=_alternative 0047992C86256FFD_= Content-Type: text/plain; charset="us-ascii" I am using a subreport to pull data from a different datasource (custdetail) which is linked to list on my main report through something called householdID. The main report does a good bit of authentication and only presents the data a particular user is authorized to see. For example, user X is only authorized to see households 1,2 and 3 while user Y can see households 4,5,6. The subreport takes a parameter of householdID. How can I prevent users from running the subreport directly and providing household keys that they aren't authorized to see? --=_alternative 0047992C86256FFD_= Content-Type: text/html; charset="us-ascii" <br><font size=1 face="sans-serif">I am using a subreport to pull data from a different datasource (custdetail) which is linked to list on my main report through something called householdID.  The main report does a good bit of authentication and only presents the data a particular user is authorized to see.  For example, user X is only authorized to see households 1,2 and 3 while user Y can see households 4,5,6.  The subreport takes a parameter of householdID.  How can I prevent users from running the subreport directly and providing household keys that they aren't authorized to see?</font> --=_alternative 0047992C86256FFD_=-- Tag: rendering problems after first page Tag: 30384
  - 25
    - Language settings Hi, I encounter the follwing problem: My standard language is german (in VS .NET as well as in Reporting Services), but sometimes (no idea by when) it changes to english. This is not very nice for some of our users. Can I assign the german language somewhere and supress all other languages ? Thx a lot. dajm Tag: rendering problems after first page Tag: 30381

Hi

I have added to my report a header, a footer and an image for the first
page. After the image the report contains tables. For the tables I have set
the property: "insert a page break before this table".

The problem is - when I am using the default rendering format or Office
components as rendering format I got on the 2nd page a gap between the header
and the displayed table (about 12cm). Because of this the content/table is
starting in the "middle" of the page (not nice).
At the following pages the tables are starting correctly at the top of the
page and if I am using PDF as rendering format everything is fine too?!?! So
why is PDF showing the report in the correct way and the other rendering
formats not?

Any suggestions?

thx a lot

Top