HI, Can the number of columns in tables be set dynamically?? I know a matrix can be used..... I was wondering whether this is ever possible with a table??? Thanks in advance,...more >>

I was wondering if someone can tell me if there is a way to create a dynamic table of contents and index for a report that is run. For example, I need to create a directory of physicians based on a search query of our database. So each report run would contain a different list of doctors and ...more >>

Hi, I have a dataset that returns data for two entities. The columns are EntityName, ValueDate, DailyValue. The rows returned are daily values for the two entities. The report is defined as; Chart Type = Line Chart Data = DailyValue Category = ValueDate Series = EntityName Currentl...more >>

Riddle me this... Can I design my reports onto a development server that does not have SSL in the mix and then use the rs utility to publish them to a live server that has SSL? Well I did but I had to change \Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReport...more >>

Hello All. I have a report that uses a table. The table is designed to have a page break after each new table. When I view the report in the designer preview, it works fine by putting each new table on a new page, and generating the document map. When I export from preview to PDF, TIFF a...more >>

I have an XY scatter chart on one of my reports where some of the data points either partially or completely overlap one another. I've setup my chart value markers to have a transparent fill so that users can see when two points overlap. My problem is that when reports are viewed each data...more >>

I am building reports using MS Visual Studio .Net 2003 and Microsoft SQL Server 2000 Reporting Services. I am encountering odd behavior in the Preview Tab for one of my report RDL objects. I've set the report parameters up to allow null entries. But when unchecking the "NULL" checkbox nex...more >>

Hi, Can I embedde a reporting services object in my web based application so the clients can use the reporting seemlessly. Thanks in advance, Benjamin ...more >>

Since RS exports csv files using a comma delimiter, Excel doesn't by default, open the file correctly. Is there a way to export to csv using a format which excel will handle correctly using its default settings? Currently the user must open the file from within Excel and specify "Delimited"...more >>

Hi MSRS Mentors, I have to open My Reports developed using Microsoft Reporting Services in my Sharepoint portal, how to do this. Please send me some inputs on this. Thanks for your help. Balaji -- Message posted via http://www.sqlmonster.com...more >>

Im in the process of creating my first data extension for reporting services. Im getting an error while creating a new report via the add report wizard. My entry shows up in the type dropdown just as expected but the next screen has a text box that says querystring. When I click next I get ...more >>

All, I have successfully implemented a forms authentication model for reporting services in our dev environment. I took the code directly from the MSDN whitepaper "Using Forms Authentication in Reporting Services", although I did modify the authentication portion to use an in house Oracle so...more >>

We have a test server cluster with an app server (with sql server) and a web server. Excuse my ignorance, but on which one do I install RS? The app server would be my first thought, but is there a way to specify that the web server box should be used as the Report server host? ...more >>

Hi, If I was to query the ReportServer database, can I retrieve info that would tell me what directories or reports a Group/User has access to? If so, what tables should I retrieve the data? Thanks! ...more >>

I have a need to provide data, and ssrs looks like the ticket. The problem is that the ss2k database is behind a firewall; I can get to it with a web service that returns a dataset, but I dont see how to get ssrs to recognize it. Is that possible? Thx, Mark...more >>

I am using the visibility property to cause my report to only show the lines where the server availability is below a minumum threshold. The problem I am having is that I want to the toggle to allow ALL the lines to be seen as the alternative. I have a report with one group in it and that i...more >>

How can I force a table footer to be positioned at the bottom of the page. I'm creating an Invoice-Reprint Report which is more like a form style report where the header and footer should be stationary. The body of the report has a table, and I was hoping to force the size of the detail se...more >>

Hello All, I'm installing the RS using the "Standard Deployment Model" suggested by BOL, which uses one Web Server as the Report Server and the Report Manager and another as the Report Server Database. According to BOL: "The SQL Server instance hosting the report server database must be...more >>

I’m trying to show images in my report using a url path since I the pics are many and ever changing. I’ve set the image source=external; Image value= http://<webserver>/<IISVirtualDirectoryName>/filename.jpg If I set the IIS Directory security to ‘Anonymous Access’ with a proper Accou...more >>

Let me begin by stating that I am not now, nor have I ever been, shoked. Been lurking here for a month or so and have tried to read every post dating back to June that relates to report exporting issues. Can we agree that export to Excel and PDF often produces unexpected results? Examples: ...more >>

I have a multiple Column report with a group that I have specified "page break at end". The problem I am having is: if it just so happens to be printing in column 1, the next group starts printing in column 2 instead of on a new page. Any ideas?...more >>

I am trying to format dates that are in string format. When I use: =IIF(Fields!MyDate.Value = "","EMPTY","STRING") I get EMPTY and STRING right where they should appear. When I use: =IIF(Fields!MyDate.Value = "","",Format((Convert.ToDateTime(Fields!MyDate.Value)), "MMM. d, yyyy")) ...more >>

I have a report that uses a stored procedure (DB2). I sometimes get this error when running certain parameter combinations from the report deployed on a portal. "Server Application Unavailable The web application you are attempting to access on this web server is currently unavailable. P...more >>

I would like to find some best practice documentation on how to manage a development, test, and production configuration. For example, I have an SRS development server that runs on a development SQL Server. Developers write the SRS reports. Then it comes time to deploy the reports to user t...more >>

We are currently using Actuate as our Web-based reporting solution, but have been evaluating RS as an alternative. There are at least 2 issues (currently!) that I can't duplicate with RS. 1. Page-level security. Actuate provides what they call 'Page-level' security. Basically, I produc...more >>

I'm having an access problem when trying to bring up the report manager . I'm receiving the error "Access Denied to C:\Program Files\Micorsoft SQL Server\MSSQL\Reporting Services\ReportManager\BIN'. Failed to start monitoring file changes." From the research that I've done, I believe this ha...more >>

Hello, I have a webserver on one box and SQL on another... How should I install Sql Reporting Services so that I can get my ReportServer virtual directory installed on my IIS box but connecting to SQL on the database box....??? Thanks, yurps ...more >>

We're looking at having a single "Reporting" Server and having both applications on the same box. If anyone knows why this inherently wouldn't work or would be a bad thing please let me know....more >>

I want to be able to refer to a custom function in a query The Function is defined in the report proprties "Code" tab as follows: public shared function MyCustomer as String Return "ALFKI" end function I have tried different query formats, and I currently have: ="SELECT * FROM cu...more >>

I have many reports that run off the same query statement. The Statement uses parameters that are supplied when the report is executed. There are allso additional parameters that are used in filters and displayed on the report (such as title information). I have set up the reports to be cac...more >>

I have a tabular report that has horizontal lines separating the rows. The row heights are all the same in the development environment, but in the browser there are many different heights and it looks like crap. Any suggestions?...more >>

What are the Oracle Stored Procedure Design limits with MSRS?? I have a complex SP that is using temp table in Oracle. Frist deleting the data and doing two insert queriess from select queries to gather and transform data and place in the temp table. Then a final select query on the temp ...more >>

I have a start and stop date as parameters to report and I want to take the start date and increment it by one day and print in table cell until it reaches stop date. I want to group by the calculated value and print data from dataset. The dataset I am using doesn't use these parameters. I am ...more >>

I have a report with multiple tables, when I trie to export this report to excell it reporting services returns an error message: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help Exception of type Mi...more >>

I am trying to use the RS utility for deploying reports I create to our customers. I need to hand them an install CD that does everything. I can deploy reports via RS, but I am wondering how to preserve a folder structure for organizing the reports. Also, how do I script subscriptions, and ...more >>

I am trying to figure out the RS command line utility. How do I create/preserve a folder structure for organizing my reports, and how do I deploy RDSs with this utility. Also, the sample script just shows how to create data sources, not deploy the ones I have already created. -- Jason...more >>

Error: Parameter validation failed. It is not possible to provide valid values for all parameters. (rsParameterError) Situation: Have a report with beginning and ending date range and it also contains a subreport. If no data exists for a certain date range the above error appears. I...more >>

I am wondering how to use a stored proc that, in the procedure, uses TEMP TABLES to drive the parameters for a data driven subscriptions. In other words, I want this stored procedure to return a list of e-mail addresses to distribute the report to. This procedure gathers this list of addre...more >>

How can I do drilldown on recursive data? I have a table with products that have parent products Eg: ProductID ParentProductID 1 2 1 3 1 4 2 I want to drill down on all the levels. ...more >>

In the preeview mode of the report designer the print button and the print-preeview button are available, activated and can be used. But this buttons are not displayed if the report is displayed in the IE. Now I read, that printing will be possible with SP2. Printing is a feature and not a...more >>

Dear Sir/Madam I have a question related to the layout facilities of Reporting Services: I have a master report with a number of subreports. Each subreport has more or less the same form: TextLine+Graph + Matrix. Graph and Matrix could be hidden by the reports parameters. If both of th...more >>

Hi, I am using the Forms Authentication Sample to authenticate users in RS. I am trying to find a sample code to check setup groups and assign access on Folders to groups instead of users. Please help. Cheers Sai...more >>

Your help is genuinely appreciated! I'm having trouble using the example script file "PublishReports.rss". At the command prompt I type in: rs -i PublishReports.rss -s https://myserver/reportserver and I get an error: "The operation you are attempting requires a secure connection. (HTTPS)...more >>

Hi!! I have 2 tables in a report that runs against the same dataset. And when I try to filter on a field called T0650_CONDITION_TYPE_ID, I get an error. "The processing of filter expression for the table 'table2' cannot be performed. The comparison failed. Please check the data type retured ...more >>