reportingservices-2005 Questions
2
Solved
This is a bit hard to explain in words ... I'm trying to calculate a sum of grouped distinct values in a matrix. Let's say I have the following data returned by a SQL query:
----------------------...
Denni asked 24/10, 2011 at 14:22
6
Solved
I'm just wondering how I can show the correct execution time on a report?
Until recently I had been using the following in the footer of my reports as a label expression:
="Execution Time: " +
II...
Nubble asked 13/12, 2011 at 1:46
5
Solved
Please help me to set the SSRS Report parameters to be optional i.e Non-Mandatory field in SSRS 2005.
Simferopol asked 11/3, 2013 at 16:16
3
Solved
I have to set the start_date of my report depending of a report parameter. The time stamps are calculated in a database query.
My expression looks like this:
=SWITCH (
Parameters!report_type.Val...
Epilimnion asked 27/11, 2012 at 8:35
3
Solved
I am trying to evaluate a Price per Kilo ($/Kg) based on sales of a product. This works fine if the product was acutally sold during the period specified. However if the product is not sold the Kg ...
Torse asked 30/7, 2009 at 2:40
3
Solved
I want to filter out the output without rows containing null values or blank columns. I am using SQL Server 2012 there is no option named 'Blank' as in SS2005 where I can filter the rows. I also tr...
Nomen asked 10/10, 2012 at 7:26
3
Solved
I have a requirement for an SSRS 2005 report to be exported as a CSV, where the column headers contain spaces.
Currently the CSV header column titles are derived from the textBox property names a...
Mefford asked 4/1, 2013 at 12:12
3
I have a SSRS report with full of number fields. I would like to have that to be displayed as in one decimal. i tried to use F1. it gives me only one decimal points in html rendering, but in excel ...
Keeler asked 17/6, 2009 at 14:30
4
I have a SSRS 2005 report that I'm rendering in SSRS 2008 as a .pdf. The report contains (among other things) a table that's very simple: header row, details, no footer, no aggregation, no grouping...
Kithara asked 10/2, 2010 at 15:44
1
Solved
I have a rdl report with 2005 defination, If I try to edit in VS2008 or Report Builder 2.0 I get an error like below ;
Have any idea, how I can edit this report without harm it.
Thanks
Sefer
&g...
Mellette asked 15/8, 2014 at 15:32
2
Solved
I have an SSRS report which is failing to export to excel when the row count is greater than the Excel 2003 limit of 65536
The report already has a grouping level with a group footer.
I have trie...
Lochia asked 25/9, 2013 at 11:2
2
Solved
I made a report on Reporting Services 2005 which consumes an external assembly, I added that assembly to the project:
Report - Report Properties - References
I also copied the assembly to the fol...
Mosque asked 16/4, 2010 at 15:3
6
Solved
Reporting Services 2005
My layout is like this:
I have the mainreport which contains a table
This table has 3 groups it runs by, GrpLevel1, GrpLevel2, GrpLevel3
Sub-Reports are added to one of ...
Orlando asked 11/3, 2009 at 15:28
3
Solved
I have created a parameter on a report that allows the user to open all the group details or hide group details when the report is run.
This works, but when you run the report and select to expand...
Kline asked 15/7, 2009 at 9:18
5
Solved
In SSRS 2005 I have a table with a dataset linked to it.
I want to check if the value of a field is null and if it is not null then format the data to make sure it has one decimal place and add a %...
Allier asked 7/5, 2009 at 17:20
4
Solved
I'm trying to add an image to a report. The image src url is an IHttpHandler that takes a few query string parameters. Here's an example:
<img src="Image.ashx?item=1234567890&lot=asdf&w...
Hasidism asked 2/12, 2009 at 16:58
4
I have a SSRS 2005 report form that is printing to a Zebra ZDesigner TLP 2844-Z label printer. The Interactive and Page sizes are set to 4" wide by 3" high. Since there is no paper orientation in S...
Piliform asked 11/12, 2009 at 17:43
3
Solved
Is there a way to export to excel from an SSRS report so that the header that displays on the first page of the report is omitted only in the excel export? Currently, it adds a frozen frame t...
Orlando asked 6/2, 2009 at 19:7
1
Solved
We are upgrading our report server from SSRS 2005 to SSRS 2008 R2.
I have an issue with CSV export rendering for SSRS 2008 where the SUM of columns are appearing on the right side of the detail val...
Granulose asked 15/10, 2012 at 19:27
1
Solved
How can SSRS 2005 represent two chart types (i.e., bar and line) on the same chart?
I am trying to create a graph that looks like the professionally crafted image below:
The chart would have on...
Lepidopteran asked 17/9, 2012 at 14:54
3
Solved
I have a line and a table in my report that I want to hide if my dataset has no rows in it.
I tried using the expression =CountRows("MyDataSet") > 0 in the initial visibility but this always ev...
Munshi asked 16/12, 2010 at 16:55
3
Solved
I'm trying to ahange data sources of multiple SSRS Report with Powershell to one shared data source on my reporting server. Here my code:
cls;
$reportserver = "myServer";<br/>
$url = "http:...
Gusta asked 7/2, 2012 at 15:11
4
Solved
Is it possible to create a custom Web front-end to run SSRS reports from?
We have an existing cross-browser web front-end for gathering reporting inputs (for a non-SSRS platform) that we would li...
Bugle asked 15/9, 2009 at 3:8
1
Currently my SSRS 2005 server is exporting the names of the textboxes as the header when a report is exported to CSV. I've tried changing the device information settings in the rsreportserver.confi...
Meier asked 24/10, 2011 at 18:43
1
Solved
So I'm attempting to create a report that is able to pre-fill a "government form" with Reporting Services 2008.
Now this all falls down to the 96 DPI issue everyone seems to be having.
Let's say ...
Shawnna asked 25/8, 2011 at 11:36
© 2022 - 2024 — McMap. All rights reserved.