hello,
can i please know, how can i export a reporting services report to a pdf file programmatically. I am using reporting services 2005 and doing my coding in C#.
any help in this rega...
I'm fairly new to SSRS and need some assistance with a report using a Matrix. Example table
Name, Region, Category, TimetoDeliver
Bob, NW, CAT01, 24 Hours
Sue, SE, CAT01, 48 Hours
Jay, S...
Dear Experts,
I would like to schedule the following query to be run on a daily (morning) bases rather then me running it manually, but what I would like it to do is calculate the date back t...
I need assistance with the following line of code:
CASE WHEN Cast(PI.EligibilityNotes as varchar(8000)) like '%IHC%' THEN 'Yes' ELSE 'No' END AS [IHC Patient],
Previously, this was ok an...
Dear all, I am not sure what is causing the following issue: (I have tried everything I could think of and found online however nothing is making it work.
I am using Crystal Reports 2008 to...
This seems like a simple question.....how can I reference the number of rows returned from a query? What I would like to do is have some conditional language on my report. If the query retur...
Hi Guys, I am trying to implement a clickable outlook appointment link on my intranet and I an getting an error when I try to execute the VB Script... it is complaining about line 51 where try...
This works correctly in the BIDS tool and on one of our servers, but fails on the other two servers. The working server is actually behind by several patches, but otherwise (as far as I can t...
I'm sick of wriritng reports by hand in PHP (I'm an OLD code cutter) and finally convinced my customer to invest in a decent report writing solution. We've been looking at Business Objects, b...
I have set up SRS 2005 on an IIS server with a remote SQL server database. When I browse to http://localhost/reports from the IIS server I just get a page that says Service Unavailable. Obviou...
Hi All,
I have an issue for a Cognos 8 reporting environment which throws out the following error in the cogserver.log when you click on directory namespace:
Error in application:
DPR...
Hi,
I'm retreiving monthly totals for a year from a table using sql with the results being displayed as shown below:
Totals Month
2 1
4 2
8 3
3 4
3 ...
Hi, I have created a report in which it has a Table, In the table i am using 2 datasets, I am doing all my groupings using 1 dataset, and in the second dataset I have some dates To do some cal...
I have SQL Server 2005 and VS 2005 on a Windows 2003 server.
I would like to be able to have users select reports from a web interface that I would provide and NOT have to login to the RS. ...
Is there any possible way to export reports from SSRS 2005 into excel using a sub report? Right now I get a messsage saying could not import sub report data into excel.
Some of the reports might take a long time to generate. Just to be on the safe side, I want to set a time out option for the reports so that they dont hog up the resource for a long time.
H...
Visual Studio .NET 2005.
ASP.NET, VB.NET. .NET 2.0
How can I increase the timeout of my application. I don't want my Session Variables to expire after only 20 minutes.
I added thi...
I am using Visual Studio 2008 Reports (not Crystal Reports) to report the data from an SQL database. This works but I would like to show column totals. The Report Wizard does not allow for t...
In reporting services on sql server 2005, i'm trying to use jump to url when a field is clicked on, this is my example code that is in the jump to url field.
="javascript:void(window.open(...
Experts,
I have two SQL SERVER (SSRS) reports with 3 parameters: START_DATE, END_DATE and SALESPERSON.
The user selects, start and end dates, then can select multiple salesperson to view s...
In Reporting Services, how do you change the background color of a table's cell when the field has a certain value (in my case, if the value is the word 'No' I want the cell background to be y...
Hi all,
I need Custom Report Builders,How to download it and
Any body give me some reference Urls.We want to purchase that software
So that user will select his required fields from tables ...
I have a very simple matrix report and am having an issue with a "record count" field. My matrix is made up as follows:
Columns Section (X axis)
I have 2 fields in the "Columns" section of...
How do I call a Reporting Services 2008 report from my C# Windows app Visual Studion 2008.
Should I use a ReportViewer Control or a url to the reporting services like ReportingServices 2005
In SQL Reporting Services, I have a simple Table on a report with one group defined. I set the sorting options for the group and the sorting options for the details grouping. When I preview th...
