Rather than use a schedule to email a report, I want to get the report server to email a report on request from a batch job. Is it possible to do this by issuing a single HTTP url to the report server? -- McGeeky http://mcgeeky.blogspot.com ...more >>

Right now I have a report with groupings and each full set takes up quite a bit of room. So right now it only displays 10 sets per page, but I'd like to increase this to 30. How can I make a table display more information before making a new page?...more >>

Hi, I have the following command text as my dataset : declare @SQL varchar(255) select @SQL = 'DB1' + '.dbo.sp_rptRoofSection ' + @Facility + ', ' + @RoofSection exec (@SQL) Both parameters are nvarchar(50) strings. However if I want my query to work when I enter the parameter i need ...more >>

Hello, When I drag a recordset field into a table control, the header text is modified so that all underscores in the field name are replaced with spaces: "APPLICANT_ID" is changed to "APPLICANT ID". Obviously it's not a big deal to manually change the headers, but I'd rather not have to (e...more >>

Hi, I'm not that familiar with VS RS and I have to convert reports from Crystal Report 9 to VS RS. Is it possible ? If not, is there any equivalent of the "unbound fields" from CR9 in VS RS ? Thanks in Advance. wadja ...more >>

The "Adding Subtotals" section in MSDN has me totally confused, I'm not seeing a Subtotal menu. I need to create a simple cross tab table but I'm not having any luck. _____________________________________________ | "TITLE" | Column Name | "TOTAL" | ________________________________...more >>

I have a Reporting Services setup on a web server on Windows 2003. It is working fine. There is a web application that is having some problems and we have set the web server to IIS 5.0 isolation mode. Will Reporting Services run under 5.0 isolation mode? At first it looks like a rights...more >>

A table has 2 columns (Date and Trans). Date has the date of the transaction, Trans contains whether the transacion was an invoice or a payment. I need to determine how long customers are taking to pay their bills. How can I find the difference in the invoice date and the payment date if bot...more >>

We have a server runs every week a schedule to generate 10 reports at the same time. It usually runs in one hour (all reports). But now the CPU hungs at 100% for two hours (ReportServer.exe) and none of the reports are generated. We stopped IIS and the ReportServer several times, but something...more >>

I am creating a report that shows customer payment trends. The report uses an oracle table that has a DATE column and a TRANS_TYPE column. DATE contains the date of the transaction, TRANS_TYPE contains 'IN' for invoice or 'PY' for payment. The report user will enter a customer number and a ...more >>

I have a report that takes quite some time to render. So I would like to create cached-instances of the report for each possible variable value. I suppose this is a rather common problem. Is there a solution (script, program) available somwhere to do this? (I've tried some things with the s...more >>

Hi guys, Just wanted to report a bug which makes me really look like crap in front of my clients, as I cannot seem to get around it. All my reports are Excel based (it is the only format that really matters to me) and contain plain data dumps rendered usually as a single big ass table. ...more >>

The SQL Reporting Services (including sp1/sp2) has been installed completely successfully on my 2003 Server. The real time report schedule has been made and just being working perfect. I would like to do the backup and first started by running the RsKeyMgmt, but I got the response that: 'rsk...more >>

Is it possible to have a parameter that uses "LIKE" instead of other operators? For example: WHERE company LIKE @company instead of: WHERE company = @company any ideas as to other strategies which would accomplish the same thing? thanks!...more >>

So, for the past two weeks or so every morning Reporting services has come up with the report error "Sorting cannot be performed on table1". For some odd reason though it does the error on all reports with any sorting whatsoever. I've checked and double checked my sorting expressions (=iif...more >>

I get the following error ... Any advice? The value expression for the query parameter ‘@JIDs’ contains an error: [BC30654] 'Return' statement in a Function or a Get must return a value. -- Frederick Volking System Architect SC Dept of Juvenile Justice...more >>

i have a report with tabke in the data section. after the table i added page footer with textbox only. where i am runing the report the page footer always coming after the table (at the end of the data) an not at the bottom of the page. how do i put the footer always on the bottom of the page ...more >>

here is what I got when I run my RS. Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: ...more >>

How to display html string stored in a text db field ? What's the syntax to use the HTMLDecode function ? =Fields!myText.value =Fields!ad_adresse2.value TIA -- Daniel CORREIA --------------------------------------------------------------------------- MCP ...more >>

Hi all, i have some Textboxes to support navigational features through hyperlinks. This Textboxes should only be visible in the HTML-Viewer and not in any rendered Format. I is possible to hide this Textbox ? Bye and Thanks, Matthias ...more >>

I am new to SQL Reporting Services (SRS) . We plan to authorize various options of SRS , like the wizard and other features of SRS, from our ASP.NET application.Is there an API of SRS which allows us to authorize it's usage from the application ? ...more >>