I am using Visual Studio 2008, SQL Server 2008 Reporting Servces, WSS 3.0. Reporting Services is configured in SharePoint Integration mode. I am displaying reports on SharePoint pages using th...
I working in Reporting Services SSRS 2005. I have a currency column which is shown in
USD. Now my question is using the tooltip can i show the currency value in GBP on mouse over.
For eg.on ...
I have a report created in Reporting Services that will be primarily exported to Excel. I have 10 matrices on the report, and the data cells all have a calculation like this:
=IIf(SUM(Fiel...
Im trying to graph the results of the running value function.
I have a table in the report, with one grouping level. I've created a column with the runningvalue function, which is working ...
Hey all,
I was wondering if there was a different application to create catalogs for impromptu then Impromptu Administrator. OR an easy to create a catalog file from hand.
The reason I ...
I am trying to render a remote report as a pdf file and stream it from my web service. (MS Reporting Services, SQL Server 2005, VB.NET) I'm getting the error "The permissions granted to user ...
I'm trying to add today's date to the filename of a subscription, so reports have name and date run as their name.
IE Report name is abc and Today is 22/12/2008
Name should be abc_22122008...
Need a select statement which returns the most current invoice record only for all customers in a master table (INV_MASTER) that have purchased a specific item. The fields I want in the resul...
Hi Can anyone tell me the difference between star schema and snow flake schema design and if appropriate which is applicable with Data warehousing?
Cheers
Hello all, I've spent hours troubleshooting this and I need some fresh perspective . . .
We have a relatively simple report setup in SSRS, simple matrix with columns across the top and data...
When trying to deploy reports for the first time on this box (Windows 2008 Server 64bit) i get the error: "Deploying to http://localhost:81/reportserver
Error rsAccessDenied : The permissions...
Hi Experts!
Still working on the Parameters of a report, I would like to know what options we have when working with Parameters / Parameters DropDowns loaded on the reports.
Right now, I...
In reporting services 2005, how would I call a function in the code behind, and successfully pass a multivalue parameter?
If i have a parameter defined for state that is multi-value, and i w...
I'm looking for a way to alternate the background color of a group header in reporting services. I'm currently using this code to alternate the detail rows to create a "green bar" effect, but...
Hi,
I am trying to repeat the name of a child for a report card on the footer of every page with reporting services.
I got the fields cannot be in the header or footer error so then I fo...
Hi
I have a report which I export to Excel from Reporting Services. The report has quite a few subreports, page breaks etc and all this works fine in that it exports to seperate sheets with...
I need to hide a table in reporting services when I don´t have data to show on it.
I have a report that depending the date, returns some data, and together to this data, sometimes there are...
I get the following error when this is deployed on to our reporting server
But works fine on my local machine
An error has occurred during report processing.
Query execution failed for da...
I want to be able to create a dynamic report, but do not want to necessarily pass arguments to my report using oracle forms.
Here is a sample sql of what I am trying to do:
SELECT ALL PE...
The point value on this one is because it's urgent.
The error occurs when calling a long running report from a Web app. to RS via a WS. Here's the stack:
[SocketException (0x2746): An e...
Hello Experts,
I have a report deployed on SQL Reporting Server which uses a date parameter.
The date format on the server is "9/1/2008".
My question is how to change date format to "...
In SQL Reporting Service, I would like to know how I can allow a user to select a NULL value as an option in my multi-value parameter.
In my "department" table, there are quite a few NULL r...
When I attempt to subscribe to a report in Reporting Services it gets the error "Failure sending mail: The transport failed to connect to the server."
In the email settings in Reporting Servi...
I am using SQL Server 2005 Reporting Services to generate reports with the ReportViewer control in my .NET Windows Forms application. Almost all of my reports add an extra empty page when they...
Hi,
Is there a way to get the text-align of a textbox in reporting services to be justified? The options are center, left, right and general, but in access and crystal reports and even html...
