I'm trying to install the developer edition of SQL Reporting Services in a developer edition of SQL 2000. I keep getting the error message "rsInvalidReportServerDatabase" and the expected version is 'C.0.6.54'. I do a complete uninstall, manually remove the database and log files, and attempt ...more >>

Hey guys, I'm using the report viewer web control in my web application. I got it somewhat working but now I'm stuck: 1) I can't set the parameters for the report. When I call SetParameters and pass a ReportParameter array, it complains that this report doesn't have parameter 'XYZ'. But ...more >>

Hi, I am writting a report & want to calculate %age difference in last year & current year's sales. how do I write the expression or will have to write it in the SP I'm using to run the report. The problem is, I need to check the previous years sales value only if it is greater than 0...more >>

For the CSV export problem, where excel opens data into one column, I had to add a report link using the below code to fix the problem. Is there a way to change the underlying export encoding in reporting services? ="javascript:void(window.open(top.frames[0].frames[1].location.href.replace('F...more >>

I am trying to write an olap report using RS2005. I created a datasource with type "Microsoft Analysis Services" then added a report and defined measures and dimensions in the query builder. Report is working fine but if I make any modification, I will not be able to save the report and as soo...more >>

Is this only a feature of RS 2005? ...more >>

I want to provide a parameter for my users to look up an item using a description field. The database is set up with a description field for each item. I have set up the parameter for this description field, now I want it to act as a like query and search for all similiar matches. How is th...more >>

I am using 2003 version of SQL reporting services. I have a couple of rectangles in a report so that I can force a page break after each one. That part works fine. When I created the rectangles, some of my textboxes were, for lack of a better word, associated with the rectangle. Meaning, i...more >>

Hello friends I have a problem displaying a picture on a table detail based on a value of a column. If this column have a value greather than 10, show a image, else show another image. I don't know how to call the images on the statement below =IIf(Fields!DIAS.Value > 10, show_image_1, sh...more >>

I have a list that recieves a distinct field from SQL query. I want to display this list as a comma delimited string of values, i.e. val1, val2, val3, ... The query looks something like this "SELECT DISTINCT val FROM TABLE" However when I create a list associate it with a Dataset that re...more >>

I have a datetime field being graphed by hour. The data is datepart("h",datetimefield.value) and the x-axis uses format("t") for labels. My problem is that I have labels like 11:01 AM and 2:07 PM instead of 1:00 PM, 2:00 PM, 3:00 PM, etc. How do I accomplish getting an exact hour label? S...more >>

Hi. I'm new in OLEBD and I have some problems when I'm creating query for report. The way to uses parameters in query is with '?' instead of '@'. So, for each '?' symbol in the query the Report Designer creates one parameter. But, what's happening if I need to use the same parameter in the Quer...more >>

Hello Friends, I am having problem with sending Parameters to report. I have created DSN and made datasource in SSRS which connect to database through DSN. Now If i write a Query which passes parameter like Select * from Customer where Customerid = @CID then it will shows error like ODBC does...more >>

How can I increase the performance when attempting to export large reports to an MS Excel or PDF file? The report currently has an average of 29,995 records and is approximately 19,398,584 bytes in size. (650+ pages) However, when rendering the report, the report takes only 30+ seconds. ...more >>

This is the problem I am facing with the SQL server reporting services, I am trying to create a report where in we have to display Page index and the table of contents Along with the Page Number. This report contains the list of products under a subcategory which in turn are u...more >>

Hello All, Thanks in advance for helping me to solve my problem. I want to print the invoices automatically through Reporting Services. I am sending a parameter to the Report which may contains one or more pages in it, when i press any button, these report should print automatically with all pa...more >>

Hi, I am trying to have drill down from a report to another report. I am using "Jump to URL" drill down to another report. Everything works fine except that the parameters get hidden int he second report. Is there anyway i can have the parameters visible while using the jump to report? Than...more >>