I have a large SSRS 2008 Server Report Project (more than 200 reports). Currently my companystrategy has been changed and we want to convert these server reports to client reports. All of the Server reports uses Storeprocedures (or in some cases from the SQl Functions) All of them work properly andthere is no problem Beause of project...
I am having my table like this (2 tables) UserId Name 2 Welcome 3 Rename Password Data 2dfdf dfd 3 dfdf I need the data while exported to csv like this... UserId, Name 2,Welcome 3, Rename, password, Data 2dfdf ,dfd 3 ,dfdf But it is displaying like this UserId, name, Password, Data 1, Welcome, 2dfdf ,dfd 3, Rename,3,dfdf How can ...
How do you you display the running GROUP count via SSRS 2005? I have a report that has n groups where the source data must remain anonymous and I want that number in the header of the group... So instead of the name in the group header like such... Employee - John Smith Employee - Mary Swain ... Employee - Ahmad Sal I want... Employee...
In the SSRS 2008 versions of my reports, I placed the headers for my tablix groups into the report header. Using expressions in hidden tablix columns, I set custom code variables which I then referenced in the header (my headers are concatenations of several report items, so i can't directly reference the report items). This worked fin...
I have a table1 in a table2 and I need table2 to be anchored to the top-right corner of the containing area in table 1. This would be useful since I need to hide parts of table2 depending of an element in table1. I can't find the anchor property. I originaly intented on using subreports, but since the child cannot return data to the par...
Hi, I have a fairly basic SQL Server Reporting Services report that is using nested row groups. Each sub-group depends on expanding its parent to be visible which is all pretty standard. The layout is something like this: { Company { { Car SUM(Price) { { { Part Price My desired result when expanded is something li...
I am new to ssrs. I have a report that gets data from two databases. I can create two datasets that connect to two different databases. The databases are third party and I cannot create stored procedures on the databases. My issue is that I have to combine the data from the two queries. Please help me with this issue or point me to loca...
Hey Guys Currently my ReportViewer control displays options for PDF and Excel, I need to add CSV as an option. Im using VS2008, and the ReportViewer is local to the WPF solution ...
Hi, I have a problem with group expressions in a list. I want to use two expressions: '=Ceiling(RowNumber(Nothing)/3)' and '=Cint(Fields!kpilevel.Value)' They work both individually, but when I insert them together only 1 works. I inserted them like this: img718.imageshack.us/img718/736/problemxq.png Does anyone know how to solve this...
Hi, I was wondering if there is a was to check if the "Current User" (User!UserID) running the report is in a network group, from the dataset query of a report? Currently we are restricting access to data based on the "CurrentUser" by checking in the where clause of a SQL query, for example, if the CurrentUser is the "Creator" of a dom...
Possible Duplicate: Subreports page headers missing in main report, SSRS Hello...I have an SSRS report with several SubReports. When Displaying a subreport that spans multiple pages, I want the SubReport header to display so the user can see which subreport they are viewing by looking at the header on any given page. Howeve...
I am running into a problem where I have a main report which calls sub report; the sub report contains data in matrix control. I am trying to export each week's data on a separate sheet on Excel, but excel only displays 1 week's data instead of 4 weeks. The same sub report, when exported to PDF, shows data weekly on separate pages, but i...
I've installed SSRS on my development machine and everything works as expected - except anyone else who is logged on to my domain can view all of the reports by browsing to http://mymachine/reports. I find it a bit strange that the default behaviour is for everyone on the domain to have access to the reports. Am I doing anything wrong...
Below is my SQL query used in SSRS report SELECT Claimname,CONVERT(VARCHAR,ClaimResponsedate,101) FROM Claim WHERE DataSourceID = 100011 From the above query 'ClaimResponsedate' may get NULL values but in SSRS report for this field displaying 1/1/1990 when the value comes as NULL. I need to display empty value in report if the date va...
Hi I'm very new to SSRS. Just try to generate a chart using some values. It is working fine but along with chart values one extra column displayed in the chart. How to restrict that? Please find the below image. In that I dont want to show 13. Just I want to generate a chart upto 12 only. Hope you understand Thank you ...
Hi I'm working with SSRS reports. While exporting the results to excel, results are starting from first column it self. But I want to provide some space for that. (i.e. insteated of starting from 1st column can we start it from 3rd or 4th column ? So that we can have some space) Thank you ...
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...
Hi, I have a few SSRS reports running on SQL Server 2008 Web Edition SP1 on my production web server. For some reason, CSV and XML export is not offered to me when viewing my reports in the report viewer. This applies to all reports on that server. As you can see, PDF, Word and Excel still work fine, it's just XML and CSV that are mi...
There are several versions of the Report Viewer Redistributable. If I'm reading things right, the versions do NOT correspond to a version of Reporting Services. Is this correct? They instead correspond to a version of the .net framework? Is anyone holding a link to a comparison of versions (8, 9, and 10)? I've tried searching for ...
In SSRS, I noticed that the rdl.data cache files are being stored on my dev machine. Are these files also stored on the Reports Server when reports are run? If so, is there a way to avoid creating those files on the server? ...