What is the most common way to integrate reports into a .Net web application?
The following are the 3 ways that I know and would like to know the experiences from SO users. URL-based Report Viewer Control from Visual Studio Web Services ...
reporting-services
SSRS - Sort report with drill-down rows.
I'm setting the interactive-sort property in a cell, and in normal reports this lets me click to sort the rows. I now have a report with multiple groups/drill-down rows, and the interactive sort doesn't seem to do anything. The rows stay in the same order. Anybody had issues with this? Any solutions? ...
SSRS: adjusting report and page size at runtime
Basically I'm trying to get a png back from SSRS 2008, which will go into a cell of variable size, which is determined when making the request. So my inquiry boils down to these 3 questions: Is there any way to specify the page size of the report with web request parameters or through a web service call? Can I tell a chart to fill the ...
Reporting Services Interactive Sort problem
I have a set of reports defined for Reporting Services in SQL 2005. I'm rendering the reports using the ReportViewer control inside an ASP.NET 3.5 application. In all the reports I have a chart and a table where interactive sorting is implemented. The sorting works perfectly when I test it on the report server catalog page. But in the re...
Reporting Services 2005 - Parameter reliant on cascading parameters
Good day I have the following: In a SSRS 2005 report I have three report parameters: FinancialPeriodType ("Month" or "Week" in a DropDownList), FinancialPeriod (cascading DropDownList populated depending on first selection) and another parameter, OpeningBalance, of type float. The first two parameters are cascading i.e. the first par...
How to ensure that a header line and its associated content line to be displayed on the same page ?
Hello all, I'm stuck since yesterday with a page break problem on reporting services (2008). I've also have to add that I've started to work with reporting a week ago, so I may misunderstand some of its aspects. Let's say I've got a dataset, holding two fields, namely A and B . To display these data, I've created a table which looks li...
SSRS Report Wizard
Hi, Was wondering if there is any way to get back into the Report Wizard in SSRS, after completing it. I find myself often wanting to tweak something, but can't see any way to get back into it without restarting everything from scratch - very annoying! Does anyone know a way? Thanks ...
Hide matrix Gridlines SQL Server Reporting Services 2005
Hi, I am creating a report using SQL Server Reporting Services in Visual Studio 2005 (SSRS). I have placed a matrix in a list. The data and the matrix are working fine. However I can't seem to find a way to hide the matrix grid lines at runtime. Also, I have set the visibility of the static 1st column and 1st row to false, but when the ...
SSRS subfolders in Visual Studio Report Server Project
I am using SSRS 2008. Currently everything works find so long as I put all reports in the Reports folder of the Report Server Project in Visual Studio. I attempted a work-around, which is to have multiple Report Server projects, each pointing to a different folder on the report server. This has the side effect of not letting me refe...
Why am I getting "Unrecognized identifier" in my SSRS custom code?
I'm trying to make use of the custom code feature within SSRS (SQL Server Reporting Services), but keep getting an "Unrecognized identifier" message in the Expression Editor. Here's my custom code. Actually, the final routine will be more complicated than this, but I'm trying to simplify things to figure out why the error is happening....
Where to download SQL Server Report Designer for Visual Studio.NET 2008 for SSRS 2008?
I've already downloaded Report Builder 2.0 to design report for SSRS 2008. Is there also a stand alone Report Designer for SSRS 2008? Or is it only available through installation of SQL Server 2008? Thank you. ...
Reporting services 2005 export to excel without formatting
If you have a reporting services report with all the formatting you want for presentation, is there any way to export just the data excel without the formatting? Kinda like a data dump in a way; take the data set on the report and dump it into excel so that users can play with the data easier. Right now we accomplish this by loading th...
How do you comment out a line in a reporting services function?
Nothing I have tried so far has worked... ...
Charting table grouped data in SSRS line chart?
Hi, I have an SSRS table with data that is grouped. I am trying to chart that grouped data, however I'm finding it difficult to connect the table grouping paradigm to the chart grouping. Essentially I have two nested columns, a time and value and I would like to chart those at the group level. Here's what it looks like: Group 2 ---G...
Sql Server Reporting wrap output rows
With Sql Server Reporting Services I would like to generate a report with line details for some orders like this: Order Details 2315 1x5432 Apple Tree, 9x912 Roses, 1x13 Spade 2316 3x12 Lawn grass How could I do that most effectively, either with transact sql or by using something built into Reporting Services? (I might end up w...
change reports datasource through sql script in SQL Server reporting services
i need an sql script that is going to change the datasource of all reports that are inside of some folder, for example http://localhost/Reports/f1 i have 2 datasources(d1 and d2) and 2 folders (f1 and f2) with reports all the reports from f1 have as datasource d2 and i need to set them to d1 ...
How to determine the number visible children in an hierarchical report?
I am using SQL Server Reporting Services 2008 to create a report. A table in this report displays hierarchical data, using a ID and ParentID field in the data. Each data row has an ID field and a ParentID field, where the ParentID points to the ID of the row that is its parent. Displaying this hierarchically is no problem, but now I wa...
print web report in C#.Net
I need to create a clients details report for a web based application in c#.Net. There will be multiple client details one by one. When take print of this web page, the first page will be the cover page and the remaining pages contains clients details. The pages except the cover page should be numbered “page x of y” in the centre of the...
Unable to integrating SSRS 2008 with MYSQL
Hi, I would really appreciate any help for this problem. Basically I am using SSRS 2008 for reporting services. My choice of DB was MYSQL. So I installed ODBC MYSQL connector and created a DSN and used it in report design. If I preview the report in the Business Intellgence Dev Studio, I can see the records, but when I try to view in ...
Display table across multiple columns in SSRS
I'm trying to format an SSRS report. At the top there is a dynamic image the runs across the top. Below that is a two column table. The table is long and runs onto the next page. Instead of going to the next page I want the table to continue on the same page into another column. ...