Hi, i need to design a report similiar as the one below... Category Time / Expense Type Totals 1/5 1/6 1/7 1/8 1/9 Regular Hours Engineer PLC Programming 96.00 8.00 16.00 16.00 8.00 Engineer General 88.00 8.00 20.00 20.00 20.00...more >>

Hello all, I have been running an MS RS for about 6 months now with no real issues. I actually really enjoy the product. However, I've recently had something crop up that I just can't seem to solve (and so it's likely something really quite obvious). I can no longer access my reports f...more >>

Hi, I am planning to use Report viewer web control in my web application and going to use forms authenthication. What roles need to assign in RS and what are the other settings need to be done. Thanks & Rgds, Aru...more >>

Sorry to repost this, but need to in order to hopefully get a response from Microsoft: I've just set up a SQL Reporting Services server. All seems to be working fine, however I've noticed that when a report is opened from a user system accessing the report server for the first time, the ...more >>

Hello all, I would like to know if there is anyway to send the UserID of the person running reports to the SQL server as a parameter to the stored procedure or sthg like that ? Currently we are using the default interface of the RS. Not implemented Forms Auth and havent integrated RS into a...more >>

Hi Freinds, Doeas anyone use SQL2005 reportin service? I have problem with sedning emails ! Thanks, Pat ...more >>

I must be missing something. I have a table with two groups. One groups on the user who created the record the other on the date the record was created. I sort on the username group by name and the createdate group with a category type. My dataset pulls information for the current year...more >>

Hi all. I was asked to add a link to the SRS home page, the link just takes the user back to our company portal. I found the ReportManager/Pages/Folder.aspx file, it contains info on what language it was written in. I have not found the actual asp pages. Where are they ? Is this something ...more >>

Has anyone heard any news about a release date for RS sp2? ...more >>

"Parameter validation failed. It is not possible to provide valid values for all parameters." Hi All, I'm trying to make my first snapshot and i have this problem. Can anyone give me a help? It is a report with several Cascade Parameters and Dynamic MDX Queries if i don't fill the de...more >>

I want to build a report that would resemble a Word document. This report would have a bold header and in the body of the report have a variety of formatted text (bold, underline, italic, and different size fonts). There may be differents formats on the same line. I only see one way to do t...more >>

i have a 2 column snaking report that i'm trying to add a title to. the title only covers the lefthand column. i want the title to span both columns. i've tried a separate report with just title and the 2 column as a subreport, and 2 column doesn't snake. i want the report to look as fo...more >>

I have a problem with images being displayed in a report when I select the image source coming from the web. The URL I am specifing is http://localhost/Scimitar/media/thumbnail.aspx?lmediaid=1742 In the layout i can see the image, in the preview i cannot nor in the deployed report when...more >>

I am using primarily ODBC to hit an AS/400 running DB2. Using unnamed parameters works fine except when I get into situations where there is a lot of "ors" in the where clause of a sql statement. I try to wirte the SQL where say a date parameter would be outside the "or" scenarios but the ...more >>

I wish to render a report from a Web Form using a URL with the PDF format. I need to bypass the save/open dialog box, which seems to be the default behaviour, and open the report within the same page. Is this possible...if so how?? Thanks in anticipation. David Johnson...more >>

what are the minimum privileges required by the sql server id used by reporting services to access it's data store (ReportingServices and ReportingServicesTempDB)? The install gives the id specified in the install dbo privilliges and our DBA is complaning...more >>

I have about 150 subscriptions to create on our Standard Edition of RS. Is there a way for me to script these or create them programmatically? Your help is greatly appreciated....more >>

I can't seem to get my formatting to work correctly. I have a very simple report, yet, when I try to print it, it doesn't break properly. It seems to print all on one page and I do have a break after my group. It worked at one point, now, something has changed that makes it not work. I...more >>

Reporting Services is a great product, especially considering that is a 1.x release. Unfortunately, not being able to render embedded HTML (in report data) is a serious limitation. This is a critical need for our business. I would like to know from a MSFT source if this will be supported in S...more >>

How do i upload a data source file (rds)?...more >>

Any idea how to get a print button and/or formatting installed? Currently, my users have to export to a file in order to print, or use the browser print feature, which ruins the formatting. Thanks, - CD...more >>

Hi, I have a date parameter that is populated from a query to give me a month drop-down on my report. When a user selects the month and runs the report, it passes the parameter to a query to return a dataset. This is all straight forward. Since the report runs quite slowly, I wanted to cache t...more >>

Dear MSRS Users, When exporting a large report to either Excel or CSV I get the error below. but it has no problem exporting to XML. Please let me know how I can work around this to export to excel or CSV format. Event Type: Error Event Source: ASP.NET 1.1.4322.0 Event Category: None Ev...more >>

Is there a way to reference a column index in a matrix? ...more >>

hi, my stored procedure has two select statements so it returns 2 result sets. Can i refer to these results sets from my table object in sql reporting services?? Thanks...more >>

Hi, I'm trying to use a csv file as my data source, I've used the Microsoft.Jet.OLEDB.4.0 as my OLE DB Provider. My conexion string is Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Mydir;Extended Properties="text;HDR=Yes;FMT=CSVDelimited" and my query is Select * from myfile.csv ...more >>

Does anyone know how I can not display a record or skip to next record in dataset if a condition is not met? I can get it to put a blank when the condition is true, but the report is displaying the row where the data would be. So, it looks like a blank line. For example I am trying to say If...more >>

hi, i need to bring the subtotal column before the Dynamic clumns in the matrix... Please let me know how to do this... Thanks,...more >>