Hi There, I have a matrix that has a column group by pay period then another column group by definition (actual & budget), a data field called hours which look like this paydate1 paydate2 totals ...more >>

I'm having some weird problems attempting to render reports in Mozilla. Basically, any report that I write, no matter how simple it is, gets squished to the smallest possible width. For Example: If I have the word "Hello" in a cell, and set the cell with to be double that size, IE will dis...more >>

Hi, I have problems openning rendered excel reports. I'm trying to view my report in my machine (P4 2.4 mhz, 1 gb ddr) and it takes 15 minutes to open. The report has 4000 rows. I've been trying to find this problem's cause, and I finally concluded that the issue is bothering me is the f...more >>

I am using Reporting Services 2005. My parameter is a multi-select one. I want to display what parameters the user chose when they run the report so others know what data the report was filtered by. When I put the below text string in a text box, I get an error. When I put the index value ...more >>

I have a report that I am grouping the data and setting the page to break after each group (check box "Page break at end"). When I View Report in Preview, the report looks perfect. Four pages, four groups. In this case, each group fits on one page. When I click on the magnifying glass to s...more >>

Yes, it is running against SQL Server, one way to recreate this problem is to query a somewhat large result in the data window then hide the data to work with scripts or the diagram window, if you wait long enough or go to the design window and work for a while, the result set that was queried...more >>

I have a text field = 3303.123456. I want to display decimals based on a dynanic parameter. For example if 4 decimals = 3303.1234. If 2 = 3303.12. The dynamic parameter will be a field in the data set....more >>

Hi, My rendered Excel reports have lot of merged cells (because of the layout I made in the designer). Therefore when I open it, the excel takes lot of minutes to open. So the question is: what can I do in order to avoid having merged cells in the rendered excel file. TIA, Gastón.- PS:...more >>

I know this seems a little redundant, but while we are converting our mdb databases to SQL Server databases, is it possible to use an mdb on the server's harddrive as the datasource for reporting? Thanks, Ben...more >>

I am using Reporting Web services's render method to render report.There is one report with huge number of data.I able to render report in TXT format.Total file size of TXT file after rendering is 30 MB.When i am trying to render same report with PDF format.It takes 2 hours to render and even ...more >>

This has happened on more than one occasion. I have defined a stored procedure type datasource with 12 parameters. When I execute the SP in the Data tab, the resulting rows are correctly displayed. When I use the same parameters when previewing the report, no data is displayed. I have fo...more >>

Hi, Our SharePoint server and Reporting Services server are installed on two different computers. How can I configure WebParts that come with SP2 to represent report server installed on a different server? Thank you, Alan ...more >>

I am trying to import access reports from an Access 2003 database. I am getting two different errors, and none of the reports are being imported. The first error is: An error occurred while the report DailySales was being imported: Reserved Error The second error is: An error occu...more >>

Hello, First, I am new to SRS. I am trying to use a parameterized where clause with wildcards (LIKE '%@StreetName%'). So far this has not worked as planned. Every time I go to another part of the grid the where clause changes to LIKE N'%@StreetName%'. Can somebody please help me wit...more >>

I recently took control over out Reporting Services environment, and I'm having trouble locating the ReportServer and ReportServerTempdb databases. Is there anyway to determine their location within the RS software? ...more >>

I'm having problems using the "Hide Duplicates" function within the Details Grouping of a table in a report (using RS SP2, SQL Server 2000, Visual Studio 2003). The details grouping has two rows, set out as follows: | CallFlow Name | | | Outcome Type | Grammar Ty...more >>

I am rendering my reports just fine from within my VB.NETapplication, however, I need a copy of the report to be saved to a temporary directory with the name of the report being a value from my database table....say name. Does anyone have any idea how to do this? -- Kristin...more >>

When I upgarde to the new version, will my old reports be able to use the multiple parameter feature?...more >>

Hi, I need some help with making the Printer Delivery Extension play nicely with RS equipped with Forms Authentication/Custom Security. We have been using the forms authentication for some time but just recently decided to implement the Printer Delivery Extension. The Problem: With Form...more >>

Hi, I get the following error when i try to Deploy a Web Service onto the development server. The report definition is not valid. Details: Could not find schema information for the element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Report'. we have the...more >>

Hi, How do i sort on calculate fields? i have a group which will show the sum of all the details. how do i sort on the group level ? EX: a 55 b 22 c 100 a 55 3 4 3 45 b 22 ...more >>

I noticed that SQL Reporting services use IFrames to generate the report. Does that mean the URL the IFRAME points to must be external? that in turn means Reporting Services server must have an external IP address? Is there anyway I can avoid that?...more >>

Hi, I have a report that uses footnotes. Throughout the reports, the footnotes are referenced by appending a superscript to some text, and then all the used footnotes are displayed at the end of the report. The footnotes are displayed at the bottom of the report in a table, whose datasou...more >>

Is there any way to restrict certain users from printing a report (or even exporting it)? If so, what is the difficulty level on a scale of 1-10? I received a request from a user to prohibit some users from printing, but I would argue that if you don't want them to print it, they probably shou...more >>

I have a report that renders ok. When I chenge the executuion settings to "Cache a temporary copy of the report. Expire copy of report on the following schedule:" I can render the report once, when I than ask for the report (and should get the cached verision) I get an error: An error has o...more >>

Hi all I have a bunch of reports that I would like to save (the exce exported version) on the server without user intervention. Is there anyway to do that automatically? When I use the render method, I always get the save/open/cancel dialo bo Cheers Kri ...more >>