I have a chart with a number of categories, and a Jump To Report action defined. The Jump to report is a table with details of the data. I would like to set it up sothat the user can click on a category, and only the details of that category are returned in the Jump To Report. Is there ...more >>

Hi All, I am very new at reporting services. I was wondering what exactly is the purpose of a subreport, and do you only use them with charts and graphs? Can subreports be use for parameters meaning- I have a report that has 2 parameter: one is departments, the orther is jobs in that departm...more >>

Can some one help me with the syntax to change the datetime data type to the following format: mmm yy Example: Feb 05 Thanks...more >>

Is it possible to code a page break into a report either through inline or code or expression? I have a report with two tables on it. Depending upon a value within a parameter the second table may or may not be visible. I then use a rectangle with the page break option set to true to br...more >>

I am able to view reports by navigating directly to /ReportServer however the report manager (/Reports/Home.aspx) gives the following: ERROR. Object reference not set to an instance of an object. No other info is provided. I'm using SSL and RS SP2 is installed, SQL has SP4. I've l...more >>

I need to take a value returned from the database ie. Record Location: Little Road, Auckland and only show Little Road, Auckland in the text box. How do i do this. hmmmmm been thinking awhile on this one. probably really really simple, just need a push is all (and thats not over th...more >>

I am creating a report and all I want to do it display the current date at the time of running the report in the page header. I created a text box and tried entering in getDate() in several different ways but I keep getting a compilation error. What is it that I am supposed to type in here?...more >>

I have a report that should only generate 2 pages but generates 3. Group 1 of the report has 41 rows Group 2 of the report has 52 rows When the report is generated, Group 1 creates Page 1, Group 2 creates Page 2 "and" Page 3. Page 2 has 46 rows and the remainder of the rows (6) overflow ...more >>

I fired off about 13 report render requests at the report server using HTTP simultaneously. 9 of them succeeded but 4 didn't. I got this error message: The remote server returned an error: (403) Forbidden. I retried the remaining 4 simultaneously and then it worked. does SSRS limit its wo...more >>

How would I go about collapsing a table cell if its contents are NULL. I have two cols. Left side holds number and the right side holds legal stuff (LongText). When the left side is NULL then the right side is going to be a title for a new section, and I would like it to be positioned more t...more >>

What account do I provide to grant everyone access to a report server rdl? I am able to grant access to a domain account and access it. But if I want it open to everyone, what do I put in for the account? I tried "Everyone" which the Report Manager interface accepted, but it still refuses a...more >>

Hey I would like to set up a report so my page footer only shows one the first page...more >>

Hi, 1-I have am creating a report with two tables. 2-Each table uses a different dataset. 3-I wish to place the two tables side by side on my report. 4-The report displays correctly when previewed. Both tables are side by side. The problem is when the report is displayed in an asp re...more >>

I am using ReportItems in the header of a report to reference the data field for the id of the report (based on a request in our application that represents the value of the call_id field). This value only displays on the first page of the report - no subsequent pages. Often the data in othe...more >>

Hi Present we are using Crystal reports 9.0 in application. we like to convert crystal reports to SQL server reports. Do we need to rewrite all crystal reports into SQl reports again Would you appreciate if any one give suggestion for hot toconverting crystal reports to SQL Server Reports...more >>

How to change shared data source in dinamic mode by parameters? If you have a sample, please send me a link. Thanks. Helder Flores Sinatecno TI ...more >>

Can anyone suggest a good SQL Reporting Services (SRS) book that covers management, performance monitoring, securing SRS? TIA. ...more >>

Hi all, did a search on parameters and could not find the answer to my ask, so here goes.. I have a report that runs on a SP. Originally, the SP had only one parameter (ID). The main report, however has and should prompt for 3 additional parameters -- (ShowThis..Yes/No, ShowThat..Yes/...more >>

Hi All, I want to perform a simple operation of Dividing two Numbers and display the result as percentage. For the result textbox, the format is N and the expression used is "=Fields!Col1.Value / Fields!Col2.Value" but i get #Error. Am i missing something ? what should be the correct ex...more >>

We are creating a report that we view detail records and find a row in the list of records and want to grab one of the fields associated with that record. Example: I have a loan number and principle balance. I count the number of loans for a borrower. Here is the data: LN NUM ...more >>

I have a web application running on the same IIS server as the RS Report Manager and everytime I have used the client-side printing control, a range of problems/errors occur when I access my web application. These problems/errors are things such as the session being timed-out before its ses...more >>

Hi all.. Is is possible, when exporting to PDF, to make the report to fit in 1 page? Thanks Jaime...more >>

Hi all.. By using report manager, I can configure a datasource that can be global for all reports (stored in "/" path). When I develop the report in VS.NET, I can set the report to use a shared datasource or a private datasource. When I use a shared datasource, a new datasource is create...more >>

Hi all.. I programed a report using VS.NET 2003 and then, in order to deployed it, I used the Deploy option of VS (in development server). The question is, where are the RDL files stored in the server? I looked for the RDL file in the whole disk but it wasn't found. Or are they stored in th...more >>

IS it possible to design the Parameters Layout in Reporting Service reports mini ...more >>

Hi, Is there any way that in a report we can dynamically pass the parameters to the sub report. Suppose in a drill down we insert a sub report there a multiple values on selection of one it should show the sub report on other it show other report and so on. it would be a great help for m...more >>

I've searched this forum (and the rest of the web) but can't seem t find an answer... I'm sure I'm not the only one trying this.. OK.. I've got a report with a bunch of parameters, most of these have th NULL tick box so you can select or unselect them However, there's no way to say USE or DO...more >>

I'm using the Oracle data connector within Reporting Services because it uses the Oracle client, which should be the most efficient. There is very little description/documentation I can find in Reporting Services help about this connector and it is difficult to figure out what it is doing a...more >>

Hi, Is it possible to export to CSV without header line? I create report for my user where they can retrieve data in csv(txt) file for their further use. I would like to skip generation of header line in CVS rendering if it is possible. Thanks Don ...more >>

I have gotten this installed on my sharepoint box, but when I do the data gather part I'm getting the following error: Data extraction failed at 7/21/2005 1:38:13 PM... Details: System.Data.SqlClient.SqlException String or binary data would be truncated. The statement has been terminated. ...more >>

Hello, I'm using a table to display some data. Is there a possibility to span a cell (or text) over to column? I want to show a total value with a bigger font size and I don't like to make the whole column only for that widther. Thanks Eric ...more >>