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...
Hi, I have created a report and grouped by one column so that if you expand that group you can see that details rows.I provided interactive sorting on the summary columns which is working fine. My problem is that when I add another grouping on top of my existing grouping to provided the page break say for 15 rows then paging works fine ...
I have SQL Server 2008 SP1 (64 bit) running SQL Server Integration Services Reporting Services on a Windows 2003 Server (64bit). I'm trying to get Reporting Services to use an integration services package as a datasource. I've created a very simple package that simple reads a text file and loads it into a DataReaderDestination. I ...
In my asp.net application, I am trying to open a particular report. I have the ReportViewer Control set with width of 100% and height of 100%. Now I expect that to mean that the report will take up the entire page. Well to my surprise, it does not. In IE7 while it takes the entire width of the page, it only takes up a small portion o...
I have a report that needs different header text on pages depending on the content of the page. Is there a way change the text in the header based on a piece of information on a page? Page 1 header: ITINERARY Page 2 header: ITINERARY Page 3 header: FARE RULES Page 4 header: RECEIPT The other issue is that eac...
Hi All, I just started working with a drill through report , where 2 reports are linked back and forth. In the designer each report shows the parameter pane even after linking to the other report. But in server, after deploying the report, the parameter pane is vissible just for the starting report and just for the first time. when i ...
Hi, Is it possible to delete or hide a particular row in a table item just in excel rendering of the report. I have a summary report , which has a link to its detail report(drill through), when i export the summary report to excel i would like to delete the row with link becasue it wont work from excel . any idea? Thanks for your ti...
I've got a couple of different user accounts set up in SQL Server Reporting Services 2005, and I'd like to programatically check (via their web services) which reports a given user has access to. How to I do that? ...
Working with SSRS and a SQL 2000 source, I have a stored procedure that takes three parameters and returns a result set. I have a dataset with the Command Type set to StoredProcedure and the procedure name in the Query String. When I attempt to execute the procedure in Visual Studio/BIDS, the Define Query Parameters dialog box presents w...
Hello, I am trying to print a report that contains a bar graph using the report viewer, but running into an error. My reporting server is running SQL Server 2005 Reporting Services SP3 on Windows Server 2003 SP2. Here are some steps that will reproduce the problem (at least for me)... On a clean machine, I open up the report, and it ...
In Short I am thoroughly confused by the array of SQL Server services available, and am having a hard time finding a brief primer. The Scoop I am a long time ASP.Net developer who has happily been churning out ASP.Net applications for years. These have usually been based on SQL server and a range of custom tables and views. Just re...
After some reading and posting, I am fairly sure that I want to use SSDS to analyze some data I have. However, I could use some pointers to help me get going. I have a simple SQL Server table: * PKID (Int) * ApplicationName (VarChar) * MethodName (VarChar) * TimeInMs (Integer) * DateTime (DateTime) This table records the length of t...
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...
Issue: Setting of exact format locations in page header LOGO subreports is not being recognized by the main report. The main report heading never recognizes the required location and scaling or any changes to the embedded subreport container items. Main report contains addressee page with embedded LOGO and addressee subreports. Exa...
Hi, I am wondering if there are any django based, or even Python Based Reporting Services ala JasperReports or SQL Server Reporting Services? Basically, I would love to be able to create reports, send them out as emails as CSV or HTML or PDF without having to code the reports. Even if I have to code the report I wouldn't mind, but the ...
I have a SQL 2005 Reporting Services report that has several report parameters. One of them is called IsActive and is of type Boolean. The parameter is hidden and set to allow null values. For its default values settings, I have it set to null. In my application that has the reportviewer control, I have logic that decided whether or ...
I am new to reporting services and have a reporting services 2005 report that I am working on to use as a base report template for our organization. I am trying to place the date that the report was last modified on the report server into the page header of the report. However, I keep getting a 'ParamX' parameter is missing a value erro...
Hi, I'm using the report viewer control included in Visual Studio 2005 and something odd is happening; when I set the margins on the report and I run the application the report viewer adds a page break after each content page, so if I have 2 content pages I end up having 4 pages of which 2 of them are blank pages. If I set the margins ...
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. ...