I am pretty new in C# and my English is not so good - sorry in advance if I miss a point. I tried to build an ASP.NET web site with a ReportService control. As you might already know, SSRS 2008 does not allow anonymous login. So, I tried to pass Credentials to SSRS which will be stored inside my web page so that users will be able to se...
Hi, Is it possible to install the IIS part of SSRS 2008 on a separate server. We have one database server and one web server. Is it possible to install the database part of SSRS2008 on the database server and the web part (Report Manager,..) on the web server? Are there any guidelines for this scenario? Thanks! ...
Hi, I have a SQL Reporting Services Report (SQL 2008 built using Report Builder v2.0) which has a multi select integer parameter (in this case a list of stores). The default value is 0 ('All Stores'). The Parameter is passed to a Stored Procedure as varchar(1024). This all works fine in Report Builder or from the Reporting Services Web...
I have a Business Intelligence project in Visual Studio 2008. I have added a report and placed a RangeBar chart in it. The dataset is as follows: dbName dbStartTime dbEndTime -------------- ----------------------- ----------------------- Unit2-Room2 2009-02-01 09:00:00.000 2009-02-01 13:30:00.000 ...
I have a requirement to show the statistic data such as sales, visitors of previous two months on a chart, of course the legend should show the name of the two months. And I decide to design the store table as: 1) Product Jan Feb and Jan Feb can be changed for March, Apr with time goes. So, for this design, every month, the column name ...
The following is the case: I have a TFS2008 installation. on a machine named TFS1 the databases are located on: DB1. Since friday I'm not able to connect to the reports anymore. This happened to be the day that I changed my password. When I open the "reporting services configuration" I noticed that the TFS1 was not initialized. I'd man...
Hi I'm trying to generate a report that has a solid legend table on top. I've tried to put it in the header section, so it wouldn't scroll down with the page but I can't put any table inside the header ...
I have a SSRS 2008 report with a Error Bar chart. It plots dates (x-axis) versus score (y-axis), with +10/-10 for the upper/lower error range. But in the dataset, I also have two sets averages (the US and the company's). I would like to display these averages as a constant. It should be a horizontal line that runs through the chart. ...
I´m having trouble getting logical page breaks to work properly. I have lists with groups and I want have pagebreaks between each instance of some the groups. But it does not seem to matter much whatever option I use for the page break property on groups. I don´t always get a page break seems a bit magical. Am I missing something her...
I am creating reports in visual studio and am looking for a way to specify a default font and size apply to a textbox each time I drop one onto the designer. Update: This is not winforms or webforms development, but using the report designer in visual studio. My biggest issue is that a text box by default is .25 inches in height and aft...
Whenever a single page report is exported to excel, sheet in excel is named by the report name. If a report has multiple pages, the sheets are named as sheet1, sheet2,.... Is there any way to specify sheet names in SSRS 2005 ? solution: Found this after some googleing: Changing the Sheet names in SQL Server RS Excel: QnD XSLT Will try...
We are experiencing a slow start up time on the first report request of the day, or when there have been no report requests for an unknown period of time. In SQL Reporting Server 2005 installations we would set up the App Pool to avoid recycling the Reporting Services applications. However, my client installed SQL Reporting Server 20...
Can you set up a Reporting Services 2008 reports server to use SQL Server 2005 for the report catalog database? ...
I am deploying a lot of report lately. And so to I kept code and version clear and understanding, Ill like to have one stored procedure per report. Mostly time I need more data sets for one reports. Is there possibility to I have more then one data set in report SSRS for calling only one stored procedure for that report. (I am using re...
Hi, I have few subreports in a sql main report(.rdl file) using VS/SSRS 2008. The subreports start approximately on the middle of the page in the main report detail section. I have one group in main report, shows header information and pass one parameter - ReportID to each subreport. I also have checked both: (1) Row Headers – “Repeat he...
Hello, I am developing an SSRS 2008 report which contains a number of simple charts. On the x axis I have the 12 months of this year - Jan 2009 thru December 2009. On the Y is an integer value ranging from 0 to 100 in increments of 10. I am plotting the number of times an issue occurred per month. So January could have a value of 10, Feb...
Hi all - a SQL Reporting Services Question - for SQL Server 2008. Given that SQL Server Reporting Services features a Scheduler which can be used to schedule the running of SQL Reports, does anyone know a way to programatically (via C#) read a report's history from the Report Server (and then perhaps retrieve the results of the report)?...
I need to create a report(rdl) in SQL reporting services 2008. In that I need to create in runtime. The report has chart. I will specify the type of chart, font, alignment and all those stuff in runtime. Is there any option for using this in SSRS 2008. ...
I'm trying to access list data using SSRS 2008. I have created an XML data source with the following connection string: "http://[Your_Site_Name]/_vti_bin/lists.asmx". I then created a dataset with the following query: <Query> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction&gt; <Method Name...
I get the following error: In remote mode, the Report Viewer control requires session state be enabled or Report Server connection information specified in the config file. Windows 2008 server, IIS 7, Dot Net 3.5 sessionState=InProc After rebooting, I still get the error. ...