I try to build a report model that have data source point to AS Database, but i can't. This is what i try: change the provider to OLE Db AS 9.0 and select the AS database, but the data source view can't detect a data source. another way i try is using an existing AS project, but the project co...more >>

I have a table which show the sales year to date by week. The sales amount is a running value and it will keep incrementing as the weeks progress. If i use the same value for the chart it does not allow RunningValue for scope Nothing. How do i do the equalant in a chart to xhow the cumulative ...more >>

Have asked previous but not helped...so thought I would give it another go. I have a query with a number of inner joins and left outer joins. The where clause has numerous "and" clauses and one of these I need to be where a endate is greater than the current date less 6 months (ie anything i...more >>

If I run a report, then change some data in the database. Then, navigate away from my sql report, go back back in and re-run the report, it doesn't show the data that I just changed in the database. I have to actually click the 'refresh' button to get the report actually "re-run". It appear...more >>

Hello I have just made some reports and they are on a machine exposed to internet but when someone tries to browser a report it ask for user and password of domain and I want to expose all my reports to the internet anonymously because I will control security from my application. Thanks ...more >>

We are running SSRS with SQL Server 2000 and are working on developing an ASP.NET application that would use SOAP web access to render the reports. However, I was wondering how this works with linked or drill down reports, which we are thinking will be an important part of our design. ...more >>

I have a report with several subreports. Each subreport is in landscape format and so is the main report. I need to be able to attach a cover sheet to the report that is portrait in orientation. Is this possible? The report is rendered on-the-fly to pdf and emailed to the requestor....more >>

Hi, I am writing a custom code which takes a number 12345 and divides it by 1024 and returns the result. i wrote the custom code in vb.net. i want the result to be in decimal - 12.05 i declared the result as result as decimal - but still i get it as 12 how can i get the decimal digits ??? T...more >>

Hi all... How should I pass datetime parameters to a report in order for it to work? This is the current scenario: Dataset has, for example, this query: SELECT * FROM POLIZA WHERE FECHA BETWEEN ? AND ? where FECHA is of DATETIME type in an Oracle Database. Both unnamed parameters a...more >>

I have 3 SPs those when run on query analyzer, runs within 1-3 secs. But when the same is run in data window of RS, doesnt return atleast before 2 mins each. When the report is run , it shows "report is running" for a long time before it returns sometimes. This is very critical for us, Some...more >>

Is there a way to have a report parameter for the selection of what field the user wants a table to be grouped on? For instance, the parameter would have 3 options, clientid, clientname, and clientcity. I want to be able to select one of these and have the table group on this selection. O...more >>

Hello and thanks for the help. I am trying to pass a simple report parameter to a report and cannot figure out why it is not working. I run this in Start - Run The report runs but it will not use the parameter. http://twsql/Reports/Pages/Report.aspx?ItemPath=%2fPlant%2fPlant+-+Saw+Plan...more >>

I am new to Reporting Services, so I hope this isn't a completely stupid question. I am using a dropdown param to filter my data, is there a way or how do I include a select all to retrieve all of the data back if needed?...more >>

Hi, I would like to share how I implemented in my application by passing multi select parameters into the report. 1. In my .net file, I have created a list box which I load all the multi values that the user wants to report on(for Ex: Equipment Id = 100,200,300,400 and so on). 2. When t...more >>

Well, I've finally done it! The first fully functional prototype of the report viewer control for Reporting Services 2000 is complete. I am working on a project that cannot wait until RS 2005, so we bit the bullet and wrote our own component (URL access will not work for a number of reasons). ...more >>

Hi, I am new to RS and the very first project that I had to implement was to enhance a report which was taking a single param into multi value(not multiple parameters). I bought 3 books and all were useless. Thought about for a week to come with the design. I designed the application and it...more >>

Is it possible to schedule into excel directly, without choosing excel and exporting once the report has been delployed onto the web in reporting services. -- shel...more >>

Guys, I need to customize the email send task in my app and I'd like to know how can I send a rendered report programaticly through MailMessage object. I've tried the code below, but it doesn't work. (...) Dim result As Byte() = Nothing result = rs.Render("/adm/CadastroUsu...more >>

We are cuurently experiencing problems with the reporting services web site. You can deploy new rep-orts to the site but when you attempt to examine the properties of the report (or data source) the following error is displayed Unable to generate a temporary class (result=1). error CS1514: { ...more >>

I created Report in SQLREporting services. I need open in in Worl, Is it possible , using "Format=" ; I can open it in Excel by giving "Format=Excel". plz help me .its an urgent.....more >>

Can someone please confirm if the following is an RS bug? If so, is there a work around? The following MDX query returns one record when executed in the Report Designer(MS Visual Studio .net 2003) data tab: WITH MEMBER member [Facility].[region_variable] as 'ondemand_udf!calc_weighted_ave(...more >>

Hi, I have a main page which has subreports, images and tables. in Preview i can see the reports with proper page breaks, but when i render it to pdf, the image and table in the main page is moving to another page, actually only 3 pages has to be printed in pdf but it is printing to 10 page...more >>

Hi, what is the details grouping for? Like, we have the ability to set up groups, why do we also need details grouping? thanks Matt ...more >>