Hello, We are moving out servers to another data center and setting up SSRS. We have copied and restored the ReportServer Dbs to the new SQL Server box and installed SSRS components. When we go through the RS Config tool and point the RS service to the newly restored ReportServer Db (running on the same machine) it automatically sets... more »
Hi, I try to use subscription on a report using the AX Data method provider quering a Dyamics AX 2008 installation. The report works fine when actively rendering but neither a snapshot or subscription on a schedule is possible. I recieve an error just saying there is a error rendering the report.... more »
Hello, [SQL2008] - version 10.0.2531 The first hit to our SQL2008 Reporting service is always very slow. Its a VMware and the total server memory is 7GB out of which we have reserved 4GB for SQLServer and 1.5GB for Reporting services. This is the entry snippet in rsreportserver config file: <MemorySafetyMargin>50</Memory SafetyMargin>... more »
Is it possible to implement this and if so, what is the best way? What I mean? I have a drilldown table where detail level has a different layout than the grouprows (which the table header refers to). Header: Text Total Num % Group1 Toplevel aggr. 100 20 20... more »
We are beginning to use SSRS 2005. When the Report Manager opens, there is no Report Builder button available on the toolbar. I am aware of launching RB with thru the url but would prefer the button. How is the button placed in the toolbar of Report Manager? Thanks. John
(Sorry if I seem to keep reposting this. It is not showing up in the SSRS forum). I'm using SSRS from SQL Server 2008. I have created a two column report that has a List control showing free-form detail data. I'm trying to display what I think is a group header at the top of each column. The current problem is... more »
I'm using SSRS from SQL Server 2008. I have created a two column report that has a List control showing free-form detail data. I'm trying to display what I think is a group header at the top of each column. The current problem is the group header only shows on the first page (the first report column in... more »
I'm using SSRS from SQL Server 2008. I have created a two column report that has a List control showing free-form detail data. I'm trying to display what I think is a group header at the top of each column. The current problem is the group header only shows on the first page (the first report column in... more »
I have a query to populate a multivalue parameter: SELECT distinct cast(AGRPYear.value as varchar(4)) + AGRPMonth.value 'ReportDate' FROM TPROJECT AS TPROJECT One of the values that is returned from this query is NULL. However, when I run the report, the NULL value does not show in the dropdown. I've also... more »