Hi, I am using asp.net to pass parameters from .aspx page to my Microsoft reporting service. My .aspx page has checkbox. If it is checked it the chekbox should pass value =0 to my report <INPUT id="ReviewedBy" style="WIDTH: 16px; HEIGHT: 20px" type="checkbox" name="ReviewedBy" value = 0> if...more >>

Hello! I was wondering if there is way to determine from RS systems tables what users are currently executing which reports? Thanks, Igor ...more >>

I'm receiving an error ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED } when I try to use the Report Model Wizard to create a report model against an Oracle database. The data source view was created with the wizard against the tables in the database....more >>

Looking for way&logic to calculate hours between 2 dates (Ticket.date_opened and Ticket.solved_date) but excluding weekends ? This function calculates hours only DATEDIFF(hour, Ticket.date_opened, Ticket.solved_date). Thanks! ...more >>

Anyone found an updated RDL specification for RS 2005? -- MGM...more >>

Looking for way&logic to calculate hours between 2 dates (Ticket.date_opened and Ticket.solved_date) but excluding weekends ? This function calculates hours only DATEDIFF(hour, Ticket.date_opened, Ticket.solved_date). Thanks! ...more >>

Hey - does anyone know of a way to export a RS file into Excel and automatically turn off the the word wrap? Otherwise, the cells get clipped. Has anyone seen this before? ...more >>

sometimes, the export link is greyed out the first time i select a export type, and i have to click on the report itself, or select another export type to get the link to become active. server is 2003 web edition, with reporting services 2000 sp2. clients are all IE6 with winxp sp1 or sp2....more >>

Where can I get a list of all the properties for a control such as a textbox?...more >>

I have a report with a filter. It's filters for various values, but I also want to filter for Null values. I've tried system.dbnull and is nothing, neither work. What syntax do I insert into the parameter value field to filter for Null? ...more >>

I have a report with 1 grouping level, and I want to display only 10 records per page. How can I force this grouping in RS, can I use functions like Rownumber, and how precisely does it work ?...more >>

How do i create page breaks that depend on report parameters? ...more >>

Hi, Is is possible to have multiple analysis Services datasources for a single report? I want to be able to display measures from both cubes on the same report with a common dimension without having to redesign my cubes. Thanks! Brian ...more >>

How do i change the currency in visual studio for my reports. US is the only one available. any ideas? ...more >>

All of a sudden i am getting a rsReportServerDatabaseUnavailable. Is there a configuration mechanism when using sqlserver 2000 in order to see and configure the connection string of the report manager ?? ...more >>

Does Report Builder support Conditional Formatting?...more >>

I am creating a report that hides rows until the user chooses show them. The row that is displayed is a summary based on grouping. The user then clicks the toggle button and all the accounts that add up to that summary are displayed. The summary row is now at the bottom. What I want to do ...more >>

Is it possible to use Visual Studio 2005 to develop reports for Reporting Services residing on a SQL Server 2000 server? I assumed I would be able to do this, but I'm getting an error when I try to deploy the report... TITLE: Microsoft Report Designer "A connection could not be made to the re...more >>

I've got RS SP2 reporting against an Oracle 10g database. The reports will run fine for a while, and then for some reason they will error out with the error: ORA-12154: TNS:could not resolve the connect identifier specified If I restart the World Wide Web Publishing Service the reports wi...more >>

How do I reference a URL for a Report Server Running on an instance in SQL Server 2005. I thought it was a $ sign but this is not working (i.e. http://REPORTSERVER$DEVDW/Reports) Default Instance : REPORTSERVER URL: http://REPORTSERVER/Reports Instance 1: REPORTSERVER\DEVDW http://?/...more >>

with URL access, IE does not prompt for password to report server on "localhost" but Firefox (1.07 - latest version) prompts repeatedly for id and password. Even when the correct admin credentials are entered it still continues to prompt for password....more >>

Ok I've seen this question asked often, but it appears no one has come up with an answer. I have a report that is viewed most often though a portal with the default parameters of startdate (yesterday) and enddate (today). Now the request has come in for a different group of people to be able ...more >>

Hi All, Is it possible in RS 2000/2005 to specify a default rendering by report, within the report manager web page. For example i have a data extract that users will dump into execl/access so they never want to see a pretty html rendering so i want that to go straight to csv, other reports ...more >>

Hi guys, I made a piechart in SQL reporting services, using my VisualStudio report designer. Within the designer, the chart likes beautiful, showing the labels outside the chart, with lines connected to the slices. However, when I deply the report, and view it in a web browser, the labels ...more >>

hi i am new to sql reporting service, i am using for financial reporting, in one of my requirement i have to calculate how much year customer's fund will last and i have to show each year's balance. in crystal report i get directly assign dataset, but how can i assign dataset in reportin...more >>

Hi All, Below is an extract from my RSReportServer.Config file. Can anyone see what the problem is with my configuration. I get the following error in my subscription "Failure sending mail: The server rejected the sender address. The server response was: 550 Sender address is missing a dom...more >>