I had number in the following format in SSRS -> 898945.45
I need to change to the following Format -> 898,945
How can i Do it. I dont want to have any decimals or currency symbols.
Hello,
I have created a SSRS 2008 report based on a stored procedure in a SQL Server 2008 database.
The report works fine if I select 'Use Windows Authentication (integrated security)' und...
Can I give a parameter in Auto Refresh property? I tried using
=Parameter!x.value
It gives an error "is not a valid value for Int32".
Is there any way I can allow user to refresh it dynami...
I have a tablix with a row group on products and sub products and a column group on years. My row group is filtered on excluding some product/sub product types and the detail rows are showing...
I have report with a table and two nested tables in the footer of the main table. The report is providing sales information for different retail outlets. The idea being that the main table su...
Hello,
I have MSRS report that generates connection string dynamically on my local host using username, password, server name and database name parameters but when I deploy it to productio...
Hello Experts:
I've been trying to load an SSRS report in a reportviewer on my asp.net website using vb.net code-behind. I've been trying to user serverreport since I have an active 2008 r...
I have just run my report which views a cube and the browser is reading the following error:
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data i...
I have a report that needs to be able to be changed once its sent out to the field in excel. I have found a work around that allow me to set up the formula the way I need it to be but when I p...
I'm working on SSRS 2005
Im having an issue with Sum of a report group in the report footer to get my grand totals. This report is grouped by Vendor. Some vendors we have credits with but ...
Hi
I have a report with data similar to this
Group1 = is a header
Gp2 Gp3 Gp4 Detail
A i 1 Some data
i ...
I have a list on an rdlc that I want to break for every page. I set page break properties for end and start together and then seperately and none works.
It will break for the first page bu...
I have an existing (working) report in my ASP.NET application that is rendered through the use of the LocalReport Class. This report currently has several parameterized subreports (all of whi...
Hello Experts
My setup:
VS08
RS08/RS05 (have both)
asp.net/vb.net (webforms)
SQL08
I've got a reportviewer control on my aspx page. I'm trying to control the datasource used in a re...
I have a stored procedure that returns a a string as 1234567890. I use this stored procedue in my SQL Server Report. I want to display it is the format as (123) 456-7890. I've tried =Format...
Hi I have a field returned in my dataset of type text or string. I wish to sort on these fields and need to split them.
eg. I might have a data set such as
1.2
1.3
1.11
2.3
I need...
Hi everyone,
So I need to find out if a date entered is a Sunday. If it is, I gotta do something special with this data. I'm not sure if Datepart will help or how to use it effectively to e...
Hi experts,
I'm new in SSRS, i get this error when try to execute the report server page(http://<computername>/reportserver).
"The report server cannot open a connection to the report s...
Hi there,
I am trying to find the logic to force my code to pick up certain criteria.
For Example:
I have a table with Age and Value, i have created a table called Example`1 to explan...
It is saying that: Select statements included within a function cannot return data to a client. , but I want to use the Case to determine if specific types of records qualify. Not all record...
If have a SQL Server Reporting Services report that has several textboxes within a ReportFooter rectangle with variations of the following expression:
=(Sum(IIF((Fields!CurrentIEPtypeID.Value...
I'm trying to create an expression that determines the shading of the field based on three factors. I thought using Switch to test various conditions would be the cleanest way to do this. Th...
Hello
I am having problems creating a report within reporting services which enables a user to select parameters not only a start and end date but also the ability to select start and end t...
I have the following expression which does not work:
=Format("Customer Name", "Underline")
Customer Name is not a field name, it is just text. I want to underline it, however this expre...
Hi--
I have a report to print a range of invoices. Every invoice has four parts to it: the header information, the detail information, the total, and then a resummarization of the detail b...
