I have switch expressions that take the left side of a column and report it.. Here is an example.
=Switch(Left(Fields!ModfiedFields.Value,8)= "1.Active","Change of Status",
Left(Fields!Mod...
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...
I have been working in Reporting Services SSRS 2005. Now i have defined a report parameter "Applicant type" as lender, colender, and (lender and colender both).. I have a assigned values to th...
Hi expers. I am working on 2 separate reports (1 main and 1 detail report) and I need to know if it is possible to have the detail report accepts parameters (multi value and single value) fro...
Hi... Is it possible do a custom sort to a field in a textbox within a matrix control?
the textbox is holding a string and is sorting alphabetically. I would like to base the sort on a diffe...
HI
I am looking at Framework manager cognos8.
Within the relational view i have a number of query subject definitions. In addition to these i have an number of relationship definitions w...
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...
ok, so i have:
- my new report created in RS.
- "Report Properties -> PageSize" set to A4 (21cm Wide and 29.7cm High).
- "Report Properties -> Margins" are all set to 0cm.
- Double check ...
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...
Here is a VBSCRIPT that i put in SQL SERVER REPORTING SERVICES WHERE IT splits the info coming from the column MODFIEDFIELDS
Example: 1.Active=Active/Inactive<br>2.Group.....
The functio...
Hi,
I have a problem with reportviewer control that can't export to excel/pdf... file.
After choosing mode file and click on "Export" button to export file, I have received an error messag...
I am developing many reports to deploy to an SQL Reporting Server. I have the project defaulting to deploy to http://servername/reportserver and it actually deploys everything fine. The prob...
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...
Our SSRS subscriptions have stopped working on a schedule.
The error shown in Status in Report Manager is:
Failure sending mail: The requested body part was not found in this message.
...
Hi,
The problem is that when deploying ssrs reports from Dev to test or Prod the reports are not getting associated with the common datasource. The datasource and the RDLs are deployed i...
Somebody help! I just purchased a new notebook running Windows Vista Home Premium edition. I've been trying to install MSSQL Server 2005 on my machine, but i get an error message saying "Micro...
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 "...
Scenario: I have WSS 3.0 installed on server named WSS. I have Report Server installed on another server called SSRS2K5 and is sharepoint integrated. I have a webserver which is used to host A...
Hi,
We are using reporting services atm for our reports from our CRM system, however some of the reports are being done al la 'template' style, like letters etc. Now we have stumbled across...
Can anyone tell me how to deploy SSRS reports in a sharepoint portal?
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...
Hello,
I need to edit an existing report that includes sales and tons sold based on a record selector defined by a parameter DateRange. The current report runs like a champ. Now, I am being...
Helloo...
I have a server which I have setup for Reporting Services and I have reports published and in use. Unfortunately, the server seems to be very slow especially when executing huge r...
Hello Experts,
In SQL Server Reporting Services 2005:
I have this expression:
=CDate(Fields!Date.Value)
Sample Returns: 7/1/2008 8:09:00 AM
How do I alter that, to give me the foll...
Im having a tough time refreshing the drop down values of my Reporting Services parameter box;
I think the problem is more on the type of join in the sql rather than the reporting services ID...
