hi, i am trying to run the following query in the dataset which works fine when i have a number in the branch_code SELECT tbl_calendar.date, tbl_day_type.day_type FROM tbl_calendar INNER JOIN tbl_day_type ON tbl_calendar.day_type = tbl_day_type.type_id WH...more >>

Books online (http://msdn2.microsoft.com/en-us/library/ms155917.aspx) states that multivalue params don't work with SQL stored procs: "The data source cannot be a stored procedure. Reporting Services does not support passing a multivalued parameter array to a stored procedure." I'm wonderi...more >>

Hi, i have a 2000 report with dates on the x axis. is it possible to just have the start date to the furthest most left point on the x axis and the end date on the furthest most left point on the x axis i was also wondering how i could manipulate the range say only showing the date on the ...more >>

What do I do if I need to uninstall depolyed reports and data sources? Thank y ou....more >>

I tried printing a Reporting Services report from the report viewer tool in my application. I click the printer icon at the top of report viewer, see the Print dialog box with my default printer selected, and click print. Nothing happens. I tried printing a Reporting Services report from a ...more >>

Hello, we are facing a datetime-parameter-problem, that does not occur during preview but when the report is deployed to the server: We have the following situation: Report A: Parameter: Date (Datetime with picker), some other string parameters Report B: Parameter: Date (Datetime wit...more >>

II6.0 SQL server 2005 I have a report with toggle option, it work fine except the toggle, when click on + I receive error rsReportParameterValueNotSet. The URL of toggle is construct without parameter needs to produce the report. The toggle work fine in my old server with IIS 5 and SQL ...more >>

Hello, We have created an ASP.NET 2.0 (C#) intranet application that uses SQL = Server 2005 Reporting Services and that needs to generate multiple = reports at the same time. Let me try to explain. In our application we allow users to select a number of reports and save = them as a report gr...more >>

Hi, Started the Configure Report Server application for SRS 2005. The Web Service Identity has a red X beside it. When I open it, the ASP .NET Service account is blank. I can change the drop-downs for Report Server and Report Manager app pools but those settings won't take with the oth...more >>

Hi, I have a report which has 1 Chart and a table in it. The table data spans to 7 pages. page 1 the user sees the chart and half of table data when the user clicks the next page, the chart goes off. how can i make sure, that chart appears in every page ? Thanks...more >>

Since the RS2000 install is no longer available w/o being the trial version I have to ask...can RS 2005 run on a SQL 2000 db? Thanks, Ben Sullins http://bensullins.com ...more >>

Hi! I am trying to create a calculated field within SRS. If value of TYPE.field = '9' OR '0', I want the value of another field 'CURTRXAMT' to be multiplied by '-1' If TYPE.field <>'9' or '0', I want to use the CURTRXAMT as is. How would I do this as a calculated field in SRS. I thinki...more >>

Hi, I've a report with more than 20 columns in it. I want to print this report in "1 page wide/Multi page tall" scaling & also in "Legal paper - Landscape orientation". I was able to set the Landscape in the Page setup, but not the scaling/Paper selection! Is there any way to do this setting fo...more >>

Hi, I can access SRS via my browser at http://servername/reports/pages no problem and have set up a new data source. I can access SRS via the Reporting Services Configuration Manager and can make changes to settings there. However, when I try to access SRA via the SQL Management Studio ...more >>

I understand I can have multiple DataSets in a single report. (Which I've tried in a test report). Maybe I'm missing something...but can't I use nested list controls to build a hierarchical report? We have Organization -> Region -> Branch -> Office Note that I am able to cobble up a...more >>

I have the Custom Security model in place, and it all seems to be working. I authenticate the user upon login. when i try the code below, i get the follwing error: object Move to here. The hyperlink being http://somedomina/ReportServer/logon.aspx?ReturnUrl=Reportservice2005.asmx Doe...more >>

I'm creating Reporting Services reports in Visual Studio. I'm in the interface that shows the Data, Layout, and Preview tabs. I've recently learned that I can drag a list control onto the design surface from the toolbox, then drag a field from the dataset onto the list control. I can clic...more >>

I am trying to make a report that show invoice line items using a table with groups. We what the table to fill the page no matter how many line items are on the invoice. For example the invoice my only have three items on the last page so the group footer ends up in the middle of the page. ...more >>

I have a report that groups on departments. I want the first row for each group to be light gray, while the row below it are white. Any suggestions? Thanks...more >>

Anyone know if there is a way to keep at least one detail row with the group footer at page break? It doesn't make for a very nice report when some pages begin with a group footer and no details to go with it. Thanks to anyone that can help with this. ...more >>

How can I configure IIS to allow anonymous and integrated requests to a single Reporting Services 2005 installation? If I try to mix the two securities (anonymous access and Windows integrated authentication), all requests run as anonymous (under the IUSR account) and therefore I get an acces...more >>

Can someone tell me why this expression generates a #ERROR when I view the report? Here is my expression: =FormatCurrency(iif(Fields!FinancialCodes.Value = 1, SUM(Fields!FinancialAmount.Value),"Div_Group1"),0) -- Thanks!...more >>

I've built several data view sources and report models and think its great. But this week I'v ran into problems. I'm trying to implementent a report model that uses data from three databases. I've managed to build the data source view containing tables from all three different data sources, bu...more >>

My SQL script behind a report produces, say, 10,000 records or more. I need to show, at first, only 1st page and - this is important - to pull data from server only for this 1st page. In order to avoid performance bottleneck I need to avoid pulling all data from server! When user clicks next pa...more >>

Hi Experts, I am new to SQL Reporting. In my report, i have lots of links from the data, which when the user clicks, redirects to another report. But now the report comes in the same page. I want the second report to be popped in a different page. Is there any provision for setting the t...more >>

Hi I am using the new report viewer control that comes with VS2005. My application does not use session state as it is clustered and so I have been following the Microsoft article for implementing the IReportViewerConnection and then adding a key for the ReportServerConnection in the web.co...more >>

Hello, we want a new browser window to open if we click on a report element with a hyperlink-action. A second report should be displayed in the new browser window at the same time. Is this possible? Regards, Ralph ...more >>