How to retrieve a report in SQL Reporting Server

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
    - distributing reports to multiple report servers Hi, I am trying to figure out how to package and deploy reports to multiple report servers. We have 200+ clients, and are trying to switch over to report server, but I can't find any documentation about deploying reports outside of an organization. To clarify a little, new releases come out quarterly, and are installed with an msi installer, and we would like to be able to distribute reports with our current process. any help would be greatly appreciated... Thanks Craig Tag: How to retrieve a report in SQL Reporting Server Tag: 46531
  - 2
    - Logon failed when attempting to run report When attempting to run a report, the following error appeared. What does the following error message mean? Logon failed. Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) Tag: How to retrieve a report in SQL Reporting Server Tag: 46528
  - 3
    - Logon failed when attempting to run report When attempting to run a report, the following error appeared. What does the following error message mean? Logon failed. Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) Tag: How to retrieve a report in SQL Reporting Server Tag: 46524
  - 4
    - Possible to Loop thru dataset using Custom Code? Is there a way to pass a record set into a function of custom code? If so? What datatype should I use? I have been told its impossible to loop thru the dataset... Can you get the INDEX of the First row and the INDEX of the last row as a parameter into a custom function? regards, Stas K. Tag: How to retrieve a report in SQL Reporting Server Tag: 46521
  - 5
    - print header on the first page only I have a table grouped by id. The detail for a particular group can span serveral pages. I have 3 header lines for each group . I want to print all 3 header rows on the first page of the group and only one of the header rows on the next pages of the group. Does any one know how to do this? -- Marie Tag: How to retrieve a report in SQL Reporting Server Tag: 46518
  - 6
    - Decoded values in report Hi, I have a report generated from a dataset which has the state and county codes. I have some other general purpose datasets which have the correspoding county/state codes and descriptions. How do I link these to the report so that I can see the descriptions instead of the code? I tried to drag the description field onto the report, but it only pulls up the first value. For example, Folder (fldr) State (n_cd) 1234 2 4444 3 (Decode Dataset) State Cd (n_cd) Description (n_desc) 2 FL 3 WA When I drop n_desc onto the n_cd field of dataset 1, I get FL for all rows, since it is picking up only the first row. Please help. Thanks, Arshad Tag: How to retrieve a report in SQL Reporting Server Tag: 46517
  - 7
    - SQL Where Statements vs RS Filtering Lets say Im running many small/big reports. I want my report to be generated fast. What's faster? SQL Store Procedures with Where statements or RS filtering? Reason for my questions: SQL cache only caches specific requests - meaning where startdate is x and end date is y. So if I run the same request again with a date range that is smaller but is between x and y, SQL will have to query it again. For example, if I run the report with date range 1/1/1900 - 1/1/2008 and then run the same report with date ranges of 1/1/2004 - 1/1/2005 I will have to wait AGAIN for SQL to retrieve the data As for filtering with RS, if you run the report with a date range from 1/1/1900 -1/1/2008 (you will wait a long time for the first generation BUT later it will be fast) and then run the report with date range 1/1/2004 - 1/1/2005, it will return results instantly because its already in snapshot on the server. Am I correct in saying all this? Which is faster and brings faster results? regards, Stas K. Tag: How to retrieve a report in SQL Reporting Server Tag: 46496
  - 8
    - How to remove 'Select a Value' from the drop down list. I am using SQL Server 2005 RTM. In which i am getting 'Select a value' in all the drop down list. I don't want 'Select a value' in the drop down list Please advise how to remove it from the drop down list Tag: How to retrieve a report in SQL Reporting Server Tag: 46491
  - 9
    - Rendering different reports into a single PDF I have 2 reports, my requirement is to render these 2 reports into a single PDF file (kindof like appending the reports). Is this possible with reporting services?? How? TIA Tag: How to retrieve a report in SQL Reporting Server Tag: 46490
  - 10
    - About rsClient Hi All, I have just installed SP2 and i want to print a report without showing print dialogbox or i want to set the right and left margins programmatically. i am using ASP.net (VB.net) to do this. I added rsclientprintlib.dll in reference list and trying to print the required report i used following code Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Put user code to initialize the page here '***** Dim rs As New RSClientPrintLib.RSClientPrint rs.Authenticate = Convert.ToSByte(False) rs.Print ("http://IE03DT2K01878/reportserver", "/CTSKNPCreports/rptAbortedTruck", "rptabortedTruck") End Sub but after execution of print statement, my IE get hangs, can anyone help me how to solve this and also steps to use rsclientlib.dll. Please i stucked on this printing issue from long time. Thank you Regards Raj Tag: How to retrieve a report in SQL Reporting Server Tag: 46488
  - 11
    - How to avoid windows login prompt (Help Pls!!!!!) I am trying the following code in my ASP.net page to pass network credentials to the ReportServer. This code renders the report without any problem but for some reason after rendering the report it also prompt windows login prompt Is this a known bug with RS ??? --// Code //-- Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load ' Create Web proxy object and set credentials Dim rs As New RSWebService.ReportingService rs.Credentials = System.Net.CredentialCache.DefaultCredentials '//rs.Credentials = New System.Net.NetworkCredential("username", "mypassword", "mydomain") ' Render the report as an HTML4.0 fragment using the Web service Dim results As [Byte]() results = rs.Render("/SampleReports/Company Sales", "HTML4.0", Nothing, "<DeviceInfo><HTMLFragment>True</HTMLFragment></DeviceInfo>", Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing) ' Write the results to the current Web page Response.BinaryWrite(results) End Sub Thanks ...... -- Nayan Patel (MCSE, MCDBA, MCSD.net) www.binaryworld.net A Powerful Knowledge Sharing Platform Tag: How to retrieve a report in SQL Reporting Server Tag: 46482
  - 12
    - Ad-Hoc and Proxy Problem Hi, I am trying to use the Ad-Hoc tool through a network proxy server. When going directly to the URL (http://[WEB_SITE]/ReportServer/ReportBuilder/ReportBuilder.application), I get the following error: ERROR SUMMARY Below is a summary of the errors, details of these errors are listed later in the log. * Activation of http://[WEB_SERVER]/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected: + Downloading http://adhoc.my-etrust.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed. + The remote server returned an error: (407) Proxy Authentication Required. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Any help is greatly appreciated. Regards, David Tag: How to retrieve a report in SQL Reporting Server Tag: 46480
  - 13
    - Aligning Matrices in a report I have a report that requires 3 matrices side by side, each with different datasets. The rows are the same in each. I have set all the properties of the cells to be the same, but the 3 don't line up, I lose some space each row so that the bottom cells don't line up across the page. Any idea what the problem may be? They all have the same row grouping and subtotals. This is in RS 2000. Joe Tag: How to retrieve a report in SQL Reporting Server Tag: 46476
  - 14
    - RS2000 - getting Page Numbers of SubReport to print in Main Report We have a report that calls several other subreports. These subreports in and of themselves are reports and in the footer of these reports are page number. When we run the reports independently they have page numbers. Unfortunately, from the main report the page numbers of each sub report do not print. Is this a Reporting Service bug? OR Does anybody have any suggestions if there are say 10 "daily reports" that need printed at once? Is there a way to queue them all up and have them print with Page numbers of each? Thanks! Tag: How to retrieve a report in SQL Reporting Server Tag: 46473
  - 15
    - RS2005 front-end disaster-how to assoc ReportServer db to new fron Search phrases: encyrption key symmetric keys Scale-out deployment... not supported Sql Server 2005 Standard Edition Reporting Services 2005 The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError) Reporting Services Configuration Manager ==================== Question: What exactly is a working procedure for dis-associating a ReportServer database from one Report Server installed on Server "A", and re-associating it successfully with a ReportServer installed on Server "B"? In particular, how is this done in Standard Edition, and without having to delete encrypted information in the Report Server database? (Of course deleting the encyrption key *only* is OK, if in the end there's a step to restore it.) ==================== The particular difficulty I've run into has to do with encryption keys. On the one hand, messages during install emphasize backing up the encryption keys, plus there is an entire screen in "Reporting Services Configuration Manager" devoted to doing-things with these keys. On the other hand, when simply trying to configure a new-install of Reporting Services by giving it an *existing* ReportServer database to use, an error appears saying "Scale-out Deployment, that feature is not supported by this edition ... remove existing keys first" (full error listed below). If recovery of a front-end to a different server isn't supported -- what the heck is the backup of the encryption keys for?! Now 'remove existing keys first' sounds like a good suggestion. And I did find that the RsKeyMgmt.exe program has a "-r" option which will remove existing keys without removing the encrypted data (at least that's my impression). The trouble is it doesn't work! Here's the symptom: -------------- Begin --------- These are commands run on Server "A" >rskeymgmt -l SERVER-A\MSSQLSERVER - a13fc790-41dd-43e2-aca7-6bb503cd1bf7 >rskeymgmt -r a13fc790-41dd-43e2-aca7-6bb503cd1bf7 Are you sure you want to delete this key? Yes (y)/ No (n): y The command completed successfully >rskeymgmt -l SERVER-A\MSSQLSERVER - a13fc790-41dd-43e2-aca7-6bb503cd1bf7 -------------- End --------- Notice that the "-l" option shows no change after the command presumably completed successfully. Trying to run this on Server "B", I first install and get the error mentioned above (scale-out... not supported). Now my RsKeyMgmt.exe will operate on the ReportServer database I'm trying to dis-associate/re-associate -- at least it now knows what database I'm trying to affect. When I run RsKeyMgmt, I can now see two Reporting Servers listed, according to the ReportServer database. -------------- Begin --------- These are commands run on Server "B" >RSKeyMgmt.exe -l SERVER-B\MSSQLSERVER - 99b64336-d87f-4085-8288-467631befecd SERVER-A\MSSQLSERVER - a13fc790-41dd-43e2-aca7-6bb503cd1bf7 The command completed successfully -------------- End --------- However, I have run through this scenario several times, sometimes trying to remove the key by running the command on Server "A", sometimes running it on Server "B". I try to remove Server "B", and that does work, confirmed by the listing from "RSKeyMgmt.exe -l" -- but that only puts me back to a working installation with Server "A" as the front end. Attempts to remove Server "B" do not succeed. I've tried "iisreset" and stopping and starting the Reporting Services service. The most affect I've had is to render both Server "A" and Server "B" inoperable, unless I completely delete the encrypted information. Dear Microsoft, a confirmed and complete step-by-step procedure is really what is needed here. If I've overlooked it in the manual or help, please tell me exactly where it is. If not, please fill this gap in a core administrative aspect and disaster-recovery aspect of Reporting Services 2005. Thanks! Complete Error Text: (Warning icon) Setting Connection Info for Reporting Server You specified a connection to a report server database that contains encryption keys for another report server. If you are configuring a scale-out deployment, that feature is not supported by this edition of Reporting Services. If you want to use this report server database with the current report server instance, remove the existing encryption keys first. Tag: How to retrieve a report in SQL Reporting Server Tag: 46469
  - 16
    - reporting services connection issue after install I just installed Report services 2000 on a desktop now configured as the report manager and the database server is a remote SQL server that run on a domain user account ex: domainx\dbadmin . In the install note, I read that I should use this same domain user account(domainx\dbadmin) for the connection to the remote DB server. That's what I did but the report server is unable to connect to the sql server or I receive permissions error but the user has full access to reportserver database & many other. I played many times with the rsconfig utility without success. Also tried with a simple SQL authenticated without success. I'm probably missing something stupid. Is there a bullet proff or preferable way to setup connection when the SQL server is not on the same machine as the report server and this SQL server run under a domani username? Thanks for any help to sort this out. Jean Tag: How to retrieve a report in SQL Reporting Server Tag: 46465
  - 17
    - where's tabledirect?? i am creating a new dataset using sql rpt services in vs 2005. i have a datasource connecting to a sql 2005 db on same box. datasource connection tests just fine. in the new dataset dialog - i have cmd type options for "text" and "storedprocedure", but not "tabledirect". i am going through a tutorial that suggests it should be there. any ideas what might be wrong for me? Tag: How to retrieve a report in SQL Reporting Server Tag: 46464
  - 18
    - Unexpected page breaks in PDF Hi Group, This is a repost - original message posted on Dec.20th. We are using Win 2000, SQL RS 2000sp2 and SQLServer 2000(sp3) and we are rendering to PDF. In most of our reports, in the body we have a title and a description, followed by a table with a grouping structure like this: Title GroupHeader1 (visible) GroupHeader2 (visible) GroupHeader3 (visible) Details (invisible) GroupFooter3 (visible) - subreport sr3.a - subreport sr3.b GroupFooter2 (visible) - subreport sr2.a - subreport sr2.b GroupFooter1 (visible) - subreport sr1.a - subreport sr1.b Depending on the amount of data displayed in the subreports (3, 2, 1), the generated PDF document has unexpected page breaks. Sometimes, all the parts of the table fit on one page and they are indeed displayed all on the first page - this is OK. Some other times, when the number of records to be displayed in subreports is bigger, the PDF rendering engine decides to insert a page break before the first subreport that would not fit entirely on the first page. When this happens, the first page contains only the group headers, the rest of it is left blank (which most of the times makes up to 75% of the page) and the rest of the report goes on from the 2nd page. We had complaints from our customers, but we were not able to find a solution to this behaviour... I posted this question a few months ago (maybe in april/may of 2005) and the opinions at that time were that the service packs will take care of this thing. We tried with SQLRS without any sp, then with sp1 and with sp2, but the behaviour is the same... Could anyone please help with this issue ? Many thanks ! PS - this is what our PDF reports look like: == page 1 == Title GroupHeader1 GroupHeader2 GroupHeader3 //...empty page...// ... ... ... ... ... ... == page 2 == GroupFooter3 - subreport sr3.a - subreport sr3.b GroupFooter2 ... ... and so on. Tag: How to retrieve a report in SQL Reporting Server Tag: 46463
  - 19
    - unexpected page breaks Hi Group, This is a repost - original message posted on Dec.20th. We are using Win 2000, SQL RS 2000sp2 and SQLServer 2000(sp3) and we are rendering to PDF. In most of our reports, in the body we have a title and a description, followed by a table with a grouping structure like this: Title GroupHeader1 (visible) GroupHeader2 (visible) GroupHeader3 (visible) Details (invisible) GroupFooter3 (visible) - subreport sr3.a - subreport sr3.b GroupFooter2 (visible) - subreport sr2.a - subreport sr2.b GroupFooter1 (visible) - subreport sr1.a - subreport sr1.b Depending on the amount of data displayed in the subreports (3, 2, 1), the generated PDF document has unexpected page breaks. Sometimes, all the parts of the table fit on one page and they are indeed displayed all on the first page - this is OK. Some other times, when the number of records to be displayed in subreports is bigger, the PDF rendering engine decides to insert a page break before the first subreport that would not fit entirely on the first page. When this happens, the first page contains only the group headers, the rest of it is left blank (which most of the times makes up to 75% of the page) and the rest of the report goes on from the 2nd page. We had complaints from our customers, but we were not able to find a solution to this behaviour... I posted this question a few months ago (maybe in april/may of 2005) and the opinions at that time were that the service packs will take care of this thing. We tried with SQLRS without any sp, then with sp1 and with sp2, but the behaviour is the same... Could anyone please help with this issue ? Many thanks ! PS - this is what our PDF reports look like: == page 1 == Title GroupHeader1 GroupHeader2 GroupHeader3 //...empty page...// ... ... ... ... ... ... == page 2 == GroupFooter3 - subreport sr3.a - subreport sr3.b GroupFooter2 ... ... and so on. Tag: How to retrieve a report in SQL Reporting Server Tag: 46462
  - 20
    - Matrix Totaling Hi, I am making a report which is run by a Stored Proc, & the design is something like this : Store # Name Sales Jan Sales Feb Sales Mar ............................. 10 Alder 1000 2000 2000 20 Bold 2000 1000 1000 30 Sad 1000 1000 2000 There is a Country Code ie. Store # 10 & 20 belong to Canada & 30 & 40 belong to US. What I want to do is get the totals based on Country & then a Grand Total, when I insert subtotal on the Country the country code is repeated on every line, how can I get this going. Thanks Tag: How to retrieve a report in SQL Reporting Server Tag: 46459
  - 21
    - How to Pass dataset from ado.net to reporting services How to Pass dataset from ado.net to reporting services any articles or any links? Tag: How to retrieve a report in SQL Reporting Server Tag: 46454
  - 22
    - Page breaks in .pdf I have a report that is using 3 rectangles to separate the blocks of information and I want each rectangle grouping to show up on a separate page in the .pdf. I currently have the properties of the 2nd and 3rd rectangles set so that a page break occurs before the start of the rectangle. This works when I preview the report, but not when I look at it as a .pdf. The 3rd rectangle is printing on a separate page, but my first 2 rows of text boxes in the 2nd rectangle are printing beneath the 1st rectangle. Any suggestions? Thank you! Tag: How to retrieve a report in SQL Reporting Server Tag: 46450
  - 23
    - SQL2k5 RTM, SSRS - Reinstall It's a long story not worth going into but I mistakenly blew away my SSRS setup on my development SQL 2k5 box and I need to reinstall just the SSRS setup. I don't need to save any of the reports I have all of those off-line, I just need to get SSRS working again. I have tried to remove and reinstall just SSRS but I keep running into issues. The current one is that the SSRS service will not start and I get these errors in the App event log; Source: Report Server Windows Service (MSSQLSERVER) Category: Startup/Shutdown Event ID: 121 Description: The Remote Procedure Call (RPC) service failed to start. Source: SQL Server Report Service Category: None Event ID: 0 Description: The description for Event ID ( 0 ) in Source ( SQL Server Report Service ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'LocalSystem' is not recognized. at Microsoft.ReportingServices.Library.Native.NameToSid(String name) at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime) at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start(Boolean firstTime) at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args) at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state) Source: MSSQLSERVER Category: (4) Event ID: 18456 Description: Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>] I have tried using a domain account for the login of the app pool and the service, nothing seems to work. Does anybody know of a good way to reload just SSRS including the webservice and the db effectively. Yes I could blow the whole server away, but given all the SSAS and DB's I would prefer not to. Thanks so much, Mike Tag: How to retrieve a report in SQL Reporting Server Tag: 46449
  - 24
    - parameters I am trying to make a report that will select the sales people who have made 10 sales or more during the current month and show what those sales are with the price..., and then show what those same sales persons totals were for the previous month. my problem is to get the totals from the previous month. example of the report is below. I am trying to use two datasets one to get the first name, last name, sales_id, product sold, price, and quantity. the other dataset will get the last month total. I want to pass the sales person id to the other dataset for each sales person. is there a way to do this? Thanks, Landon sales people who sold 10 or more: first name, last name, sale_id, product sold, price, quantity last month total: total < ------ this is where my problem is first name, last name, sale_id, product sold, price, quantity last month total: total first name, last name, sale_id, product sold, price, quantity last month total: total first name, last name, sale_id, product sold, price, quantity last month total: total Tag: How to retrieve a report in SQL Reporting Server Tag: 46447
  - 25
    - unexpected page breaks Hi Group, This is a repost - original message posted on Dec.20th. We are using Win 2000, SQL RS 2000sp2 and SQLServer 2000(sp3) and we are rendering to PDF. In most of our reports, in the body we have a title and a description, followed by a table with a grouping structure like this: Title GroupHeader1 (visible) GroupHeader2 (visible) GroupHeader3 (visible) Details (invisible) GroupFooter3 (visible) - subreport sr3.a - subreport sr3.b GroupFooter2 (visible) - subreport sr2.a - subreport sr2.b GroupFooter1 (visible) - subreport sr1.a - subreport sr1.b Depending on the amount of data displayed in the subreports (3, 2, 1), the generated PDF document has unexpected page breaks. Sometimes, all the parts of the table fit on one page and they are indeed displayed all on the first page - this is OK. Some other times, when the number of records to be displayed in subreports is bigger, the PDF rendering engine decides to insert a page break before the first subreport that would not fit entirely on the first page. When this happens, the first page contains only the group headers, the rest of it is left blank (which most of the times makes up to 75% of the page) and the rest of the report goes on from the 2nd page. We had complaints from our customers, but we were not able to find a solution to this behaviour... I posted this question a few months ago (maybe in april/may of 2005) and the opinions at that time were that the service packs will take care of this thing. We tried with SQLRS without any sp, then with sp1 and with sp2, but the behaviour is the same... Could anyone please help with this issue ? Many thanks ! PS - this is what our PDF reports look like: == page 1 == Title GroupHeader1 GroupHeader2 GroupHeader3 //...empty page...// ... ... ... ... ... ... == page 2 == GroupFooter3 - subreport sr3.a - subreport sr3.b GroupFooter2 ... ... and so on. Tag: How to retrieve a report in SQL Reporting Server Tag: 46446
- Next
  - 1
    - unexpected page breaks Hi Group, This is a repost - original message posted on Dec.20th. We are using Win 2000, SQL RS 2000sp2 and SQLServer 2000(sp3) and we are rendering to PDF. In most of our reports, in the body we have a title and a description, followed by a table with a grouping structure like this: Title GroupHeader1 (visible) GroupHeader2 (visible) GroupHeader3 (visible) Details (invisible) GroupFooter3 (visible) - subreport sr3.a - subreport sr3.b GroupFooter2 (visible) - subreport sr2.a - subreport sr2.b GroupFooter1 (visible) - subreport sr1.a - subreport sr1.b Depending on the amount of data displayed in the subreports (3, 2, 1), the generated PDF document has unexpected page breaks. Sometimes, all the parts of the table fit on one page and they are indeed displayed all on the first page - this is OK. Some other times, when the number of records to be displayed in subreports is bigger, the PDF rendering engine decides to insert a page break before the first subreport that would not fit entirely on the first page. When this happens, the first page contains only the group headers, the rest of it is left blank (which most of the times makes up to 75% of the page) and the rest of the report goes on from the 2nd page. We had complaints from our customers, but we were not able to find a solution to this behaviour... I posted this question a few months ago (maybe in april/may of 2005) and the opinions at that time were that the service packs will take care of this thing. We tried with SQLRS without any sp, then with sp1 and with sp2, but the behaviour is the same... Could anyone please help with this issue ? Many thanks ! PS - this is what our PDF reports look like: == page 1 == Title GroupHeader1 GroupHeader2 GroupHeader3 //...empty page...// ... ... ... ... ... ... == page 2 == GroupFooter3 - subreport sr3.a - subreport sr3.b GroupFooter2 ... ... and so on. Tag: How to retrieve a report in SQL Reporting Server Tag: 46445
  - 2
    - license of reporting service 2005 Dear all, Does reporting service 2005 to be installed on sql server 2000, if so, what is the license requirement? Tag: How to retrieve a report in SQL Reporting Server Tag: 46437
  - 3
    - Counting Rows I have a simple report, listing patient names, and then columns depending on certain condition. If they have the condition the column is True, and if they don't the column is false. The problem I have is trying to count how many have each condition. I inserted the following expression in the footer: =Count(cint(field!.condtion1.value)=-1) If the column is true it does resolve to a -1, a 0 if it is false. The expression just counts every row. It doesn't seem to evaluate the expression. Any help would be appreciated. John Hart Tag: How to retrieve a report in SQL Reporting Server Tag: 46436
  - 4
    - asp.net report (rdlc) file cannot create dataSource With asp.net 2005 - after I create a report (rdlc) file, I try to create a Data Source (Report menu, then click "Data Sources", I get error: The root element of a WC3 XML Schema should be <schema> and its namespace should be 'http://www.w3.org/2001/XMLSchema'. Can I fix this? Thanks -- Jay Tag: How to retrieve a report in SQL Reporting Server Tag: 46435
  - 5
    - migrate visual studio.net 2003 to visual studio.net 2005 I've a server with Visual Studio.net 2003 and reportig services. I want to migrate to Visual Studio.net 2005 Are there some contraindications? Tag: How to retrieve a report in SQL Reporting Server Tag: 46434
  - 6
    - Export PDF issue How can I get correct pdf format file for certain reports which contain chinese characters ? Always show "?" now. Tag: How to retrieve a report in SQL Reporting Server Tag: 46428
  - 7
    - query in sql server 2005 is case sensitive? Dear all, query in sql server 2005 is case sensitive? Select firstname from Person.Contact - does not run however Select FirstName from Person.Contact - run why? Tag: How to retrieve a report in SQL Reporting Server Tag: 46427
  - 8
    - Seetinf default value of parameter through session Hi all I am opening reports through a link on .aspx page. What i want is, let default value of one parameter set through the value passed by parameter and rest stay as they are. Is it possible by any means?? Thanks and regards Utsav Verma Tag: How to retrieve a report in SQL Reporting Server Tag: 46426
  - 9
    - SQL Reporting Service - Error Sending Subscription Mail .. Hi Friends !! I have been using SQL Reporting Service for last 3 months ... Now i want to make use of Subscription feature where in i want to send mail on a scheduled interval ... When i tried the same, im getting the following error on the ResportingService Log file... "ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files, AuthzInitializeContextFromSid: Win32 error: 1722; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files" When checked in Microsoft, i got the following link ... http://support.microsoft.com/?kbid=842423 I have done whatever is mentioned in this link ... Still i continue to get the same error .. Im posting my problem here expecting some help from you guys there ... Thanks in Advance Rgds Kishore Tag: How to retrieve a report in SQL Reporting Server Tag: 46423
  - 10
    - Jump to URL with new window How can I jump to URL with new window? Is anyway can do this? I'm try to use &rc:targetlink=new but it dosen't work. how can I do this? Thanks for any advice! Angi Tag: How to retrieve a report in SQL Reporting Server Tag: 46421
  - 11
    - Drillthrough event for Remote Reports I have a Report Server 2005 installation in which I am using the ReportViewer control to view the report. It is a drill through report and I am trying to capture the drillthrough event to set session variables. But the event doesn't fire ?? My code looks like :- protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ReportParameter pParam = new ReportParameter("ClientID", "0"); ReportIs.ServerReport.SetParameters(new ReportParameter[] { pParam }); pParam = new ReportParameter("Security", "3"); ReportIs.ServerReport.SetParameters(new ReportParameter[] { pParam }); pParam = new ReportParameter("Start", StartIs.Text); ReportIs.ServerReport.SetParameters(new ReportParameter[] { pParam }); pParam = new ReportParameter("End", EndIs.Text); ReportIs.ServerReport.SetParameters(new ReportParameter[] { pParam }); ReportIs.Visible = true; ReportIs.Drillthrough += new DrillthroughEventHandler(DrillThrough); } } protected void DrillThrough(object sender, DrillthroughEventArgs e) { string temp = e.ToString(); } what am I doing wrong? Tag: How to retrieve a report in SQL Reporting Server Tag: 46418
  - 12
    - 401.2 on reportingservice render Have not seen anything quite like this in the posts... iis 6.0, 2003 sp1 server, on server 1, and server 2. ssrs 2000 report server on server 2. run asp.net web page on server 1 using http://localhost/appname/page.aspx?path=path&format=format works fine. however, with http://server1/appname/page.aspx?path=path&format=format gives 401.2, as does http://server2/appname/page.aspx?path=path&format=format (same app on both iis servers, both set for Integrated Windows Authentication). IE 6.0 configured identical on both servers. web.config: <authentication mode="Windows" /> <identity impersonate = "true" /> web page: Dim rs As New ReportingService rs.Credentials = System.Net.CredentialCache.DefaultCredentials I am able to use rs.ListChildren, but not rs.render on Server2. Tag: How to retrieve a report in SQL Reporting Server Tag: 46415
  - 13
    - Cant move row in Matrix I can't move static rows up or down in Matrix to arrange them in different oder. When I add row, it always gets appended to the bottom of matrix. So then I have to cut and paste my rows one by one to shift them down. Is thia by design? Tag: How to retrieve a report in SQL Reporting Server Tag: 46414
  - 14
    - Avoiding the user login prompt for a reporting services report Most of the stuff I have read on this is from 2004. I am wondering if there is a easier fix to this problem. Tag: How to retrieve a report in SQL Reporting Server Tag: 46410
  - 15
    - Format a number to be a date format I have a number field that looks like this: 8 characters long yyyymmdd ie: 20051201 I can not change its type to a date field. In Access and Crystal I was able to manipulate the number to make it look like a date ie: 12/01/2005 Can anyone help me figure out how to format the field like this? thanks so much -- Jeanne Conde, MCP Tag: How to retrieve a report in SQL Reporting Server Tag: 46407
  - 16
    - RDL Hi, Can we write functions in RDL ? If yes how, where etc... Thanks Tag: How to retrieve a report in SQL Reporting Server Tag: 46398
  - 17
    - Hiding parameter passed through query string I'm using Reporting Servicves for SQL Server 2000 and I've embedded a ReportViewer control in an ASP.NET page. The reports I link to all require a sensitive parameter value and I have been passing that through using the query string. Unfortunately, the entire URL of the report--including the parameter in the query string--is visible in the source for the page, and I don't want the user to see this for security purposes. Is there a way to hide this? I'm open to any and all suggestions. Thanks, Mark Tag: How to retrieve a report in SQL Reporting Server Tag: 46395
  - 18
    - How to remove domain admins from SRS Hi In our IT dept all IT users are members of the domain admin group (not my idea). Is there a way to prevent them from seeing reports/folders? We only want admins to see reports if they are given explicit permissions. thanks Tag: How to retrieve a report in SQL Reporting Server Tag: 46394
  - 19
    - Need help modifying XML report template to fix broken HTML table Is there any way to modify HTML that Reporting Services is accessing via the XML report template? It appears to be pointing to the Microsoft site and has a table that is sized incorrectly for Firefox to render. I've seen postings acknowledging that the table is sized incorrectly, but no actual solutions. Thanks! Tag: How to retrieve a report in SQL Reporting Server Tag: 46393
  - 20
    - Leading spaces are truncated by the service packs ( SP1 & SP2) Hi, I have couple of reports which retrieves records with leading spaces. the leading spaces vary and forms the proper indentation for the fields to produce a visually pleasing presentation. unfortuanetly, after installing the SP1(even tried the SP2) the leading spaces are implicitly truncated by the reporting services. Anyone have come across this issue? any workarounds? or settings needed to correct this? Thanks, Jerone Tag: How to retrieve a report in SQL Reporting Server Tag: 46388
  - 21
    - Long Oracle report Hi, I'm having problems with a report that has a Oracle datasource. The query source is a stored procedure that takes 3 hours to complete but reporting services don't wait this time and shows an error page. Reporting Services is configured to "Do not timeout report execution" and the report uses "Use default setting" This works ok with a SLQ Server Stored procedure. Any ideas? Andrés Tag: How to retrieve a report in SQL Reporting Server Tag: 46386
  - 22
    - Convert Crystal Field Logic To SSRS 2005? Hello all! I am in the process of converting a client's Crystal Reports to SSRS 2005 reports. Some of the crystal report fields have a good amount of logic behind them to determine what is displayed. What is the best way to apply this logic in a SSRS 2005 RDL file? This looks like a lot of logic to have in an expression...Would I want to create a function and pass in the parameters (it would need about 10+ parameters)? What implications would this type of logic have on processing time? Here is a sample of some of the logic: if {File001.type} = 1 or {File001.type} = 6 then ( if {File001.category} = "Sold" then {File001.numeric1} else (if ({File001.action11} <> 0 or {File001.action13} <> 0) then {File001.numeric2} else {File001.numeric3}) ) else if {File001.type} = 5 then ( if {File001.category} = "Sold" then {File001.numeric4} else (if ({File001.xfield} <> 0 or {File001.yfield} <> 0) then {File001.numeric5} else {File001.numeric6}) ) else {File001.numeric7} Thanks! -Brian Tag: How to retrieve a report in SQL Reporting Server Tag: 46385
  - 23
    - RS Web Service Reference File Where do I go to add a constractor of "this.Timeout=..." to a the Web Service reference file? Challenge: Long running reports are timing out Thank you for your assistance. Tag: How to retrieve a report in SQL Reporting Server Tag: 46384
  - 24
    - HELP ! How to Print Through Network Printer Hello All, I have Sample printer deliver extension provided with Reporting Services. This code works well when i use Local printer, but i want to use network printer, for that i changed config file as - <Printer>\\199.63.103.253\NB1OACHP5100</Printer> but Reporting Services shows error - The printer \\199.63.103.253\NB1OACHP5100 is not currently installed on the server. Can anybody help me how to solve this? Also can i print the report on an trigger like in my application i use a button to print, and on click this report get printed. Please help me if you solved such problem or you know how to solve this. Thank You Regards Raj Tag: How to retrieve a report in SQL Reporting Server Tag: 46383
  - 25
    - Help me About Printer Deliver Extension Hi Friends, I am using Sample Printing Delivery Extension i followed all steps by Readme file but, i am not able to find it in my Subscription, can anyone help me what exactly happened? I am attaching part of two files with this RsReportServer.config - <Delivery> <Extension Name="Printer Delivery Sample" Type="Microsoft.Samples.ReportingServices.PrinterDeliverySample.PrinterDeliveryProvider,Microsoft.Samples.ReportingServices.PrinterDeliverySample"> <Configuration> <Printers> <Printer>\\IE03DT2K01878\NB1OACHP5100></Printer> </Printers> </Configuration> </Extension> <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider"> <MaxRetries>3</MaxRetries> <SecondsBeforeRetry>900</SecondsBeforeRetry> <Configuration> <FileShareConfiguration> <ExcludedRenderFormats> <RenderingExtension>HTMLOWC</RenderingExtension> <RenderingExtension>NULL</RenderingExtension> </ExcludedRenderFormats> </FileShareConfiguration> </Configuration> </Extension> <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider"> <MaxRetries>3</MaxRetries> <SecondsBeforeRetry>900</SecondsBeforeRetry> <Configuration> <RSEmailDPConfiguration> <SMTPServer></SMTPServer> <SMTPServerPort></SMTPServerPort> <SMTPAccountName></SMTPAccountName> <SMTPConnectionTimeout></SMTPConnectionTimeout> <SMTPServerPickupDirectory></SMTPServerPickupDirectory> <SMTPUseSSL></SMTPUseSSL> <SendUsing></SendUsing> <SMTPAuthenticate></SMTPAuthenticate> <From></From> <EmbeddedRenderFormats> <RenderingExtension>MHTML</RenderingExtension> </EmbeddedRenderFormats> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats> <ExcludedRenderFormats> <RenderingExtension>HTMLOWC</RenderingExtension> <RenderingExtension>NULL</RenderingExtension> </ExcludedRenderFormats> <SendEmailToUserAlias>True</SendEmailToUserAlias> <DefaultHostName></DefaultHostName> <PermittedHosts></PermittedHosts> </RSEmailDPConfiguration> </Configuration> </Extension> <Extension Name="NULL" Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/> </Delivery> RSWebApplication.config <Extensions> <DeliveryUI> <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider"> <DefaultDeliveryExtension>True</DefaultDeliveryExtension> <Configuration> <RSEmailDPConfiguration> <DefaultRenderingExtension>MHTML</DefaultRenderingExtension> </RSEmailDPConfiguration> </Configuration> </Extension> <Extension Name="Printer Delivery Sample" Type="Microsoft.Samples.ReportingServices.PrinterDeliverySample.PrinterDeliveryUIProvider,Microsoft.Samples.ReportingServices.PrinterDeliverySample"> <Configuration> <Printers> <Printer>\\IE03DT2K01878\NB1OACHP5100></Printer> </Printers> </Configuration> </Extension> <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider"> <Configuration> <FileShare> <DefaultRenderingExtension>MHTML</DefaultRenderingExtension> </FileShare> </Configuration> </Extension> </DeliveryUI> </Extensions> "Microsoft.Samples.ReportingServices.PrinterDeliverySample.dll" is present in Report Manager Bin and Report Server Bin Folder. Please help me. Thanx and Regards Raj Tag: How to retrieve a report in SQL Reporting Server Tag: 46381

Is there a way to read the rdl file that is already deployed on the Report
Server to modify it? I have some reports on RS but don't have the original
rdl file.

Thanks

Ayad

Top

Re: How to retrieve a report in SQL Reporting Server by Potter

Potter
Thu Dec 29 15:32:57 CST 2005

Ayad,

Open Report Manager (http://localhost/reports), select your report and
click the 'Properties' tab. You'll see a section on the page called
"Report Definition". Click the Edit link and you'll have the RDL.

Andy Potter

Top

Re: How to retrieve a report in SQL Reporting Server by Jasper

Jasper
Thu Dec 29 16:58:02 CST 2005

To extract multiple disparate reports at the same time you could also use

Reporting Services Scripter
http://www.sqldbatips.com/showarticle.asp?ID=62

--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com

"Ayad" <ashammout1@hotmail.com> wrote in message
news:O5WPL1LDGHA.740@TK2MSFTNGP12.phx.gbl...
> Is there a way to read the rdl file that is already deployed on the Report
> Server to modify it? I have some reports on RS but don't have the original
> rdl file.
>
> Thanks
>
> Ayad
>

Top