I have a report where I have about 5 fields right next to eachother that dont return data in about 90% of the reports. Is there a way to hide these fields if they are empty otherwise display them if they do contain data? Thanks ...
How i can change design of parameters value in SQL reporting services ? ...
I am getting the following exception when calling the LoadReport() method of the ReportExecutionService2005 web service provided by SSRS 2005; System.Web.Services.Protocols.SoapException: Server did not recognize the value of HTTP Header SOAPAction Any ideas what may cause this? My C# code looks like this; string _reportName = "/Folde...
I have searched a bit upon it but can't get it to work properly. I want the report to display as many decimal characters as the field has, simple as that. Example: Value = 169.99 | Ouput = 169.99 Value = 169.9999 | Output = 169.9999 If I don't set the Format property to anything, it kinda aligns the fields, sometimes it returns 2...
The application I am working on is generating .rdlc files that will end up being interpreted by Microsoft's WinForms ReportViewer control (not the ASP.NET one). I have only been partially successful with adding the interactive 'sort direction' controls on to these reports. The controls appear on each column and row in the report, when y...
SELECT id, EmpNo FROM EmployeesTable EmpNo can be the same for 1 or more records in the results of the above query. I now want to add another column derived from EmpNo(lets call it EmpNo2) but only returning distinct values of EmpNo. For example if the above query returns 100 records but there are 69 distinct EmpNo values and i...
SSRS parameters are a pain. I want to be able to re-use reports for many different needs by allowing the users access to many different parameters and making them optional. So, if I start out with code such as: Select * from mytable myt where myt.date between '1/1/2010' and '12/31/2010' and year(myt.date) = '2010' and myt.partnumber ...
In SSRS 2005 expression I have values for time that are given in days,hours and minutes. The values are fine until i have to do a sum in a column on them and I end up with values like "2 days 52 hours 122 minutes" where else i would like to show proper time with the previous value as "4 days 6 hours 2 minutes" how can i achieve th...
Question: In order to store logos in a database and display them dynamically in ms-reporting service, I need to base64 encode the image. It doesn't work with binary saved images, due to MS limitations... Now my question: Which datatype do I use? Varchar, nvarchar or text? I guess varchar would be good enough, since base64 encoded, but ...
Hi guys, Iam generating charts using SSRS 2005 and i want to programmatically set the maximum and minimum values for yaxis corresponding to the maximum of all the datapoints.Is there any way to do this? Please help me! Thanks in advance! ...
I am working on SSRS 2005. I work with third party databases and I cannot create the table in those databases. My only option is to have a lookup table in the ReportServer database. I dont know if its possible. Is there any way to create a lookup table on the ReportServer database? Thanks in advance. ...
I have the following data (I have a lot more rows this is just an example): VALUE Location FLEET REGION P Pocatello, ID 104 232 B Pocatello, ID 104 232 B Spokane, WA 107 232 B Spokane, WA 107 232 In either reporting services or MSSQL I ne...
I have a report that has 3 expandable columns. I have a condition in one of the rows that says the following for the hidden property: =IIF(Parameters!GroupBy.Value = "Fleet", TRUE, FALSE) Basically this is saying that if the parameter picked is Fleet then the hidden value is set to true otherwise its set to false. It looks perfect in ...
Guys, I am working on SQL Reporting services. I have a report where an invalid value is entered as part of the criteria for a report a new screen is produced with the error message, there are no buttons on this screen so the only way to navigate back to the report is by clicking on the browsers back button, in which case all of the sear...
I have the header in my report on SSRS frozen so it scrolls down as I scroll down the page. Is it possible to keep this header frozen when I export the report to excel so it will do the same in excel? ...
How practical is it to consider SSRS 2005 or SSRS 2008 as a reporting solution for a report that has to show reports with millions of records (records vary from 3 to 10 million)? Is there any threshold on the size of report in SSRS? How do I know that for a huge report, wheather SSRS will consume the whole memory and start paging the op...
How to access out of scope groups.I want to display second group rows count in first group. ...
Reporting Services was working fine until recently, now when I try to deploy and run a report from Business Intelligence Studio I get this error. Similarly when I try to connect to the ReportServer URL directoy from IE Explorer, (set to http:///ReportServer I get the same error, so it's not specific to the report but probably rather to...
We are trying to create reports in SQL Server Reporting Services 2005 from Oracle. The problem is many values do not display correctly, they show up as an empty square (depedning on the font, sometimes it will show as a black diamond with a question mark) The field is stored in a varchar2 in Oracle. For example what "appears" to be ...
How do you repeat a page header on every page in Visual Studio 2005 SSRS? ...