Good Day all Since a week i am working on SQL REPORTING SERVICES as well I installed SP2 i got the feature for client side printing also and i am able to print my report but the problem is, i am getting 2 pages instead of 1 it is supposed to be only 1 i mean to say, in the preview i am getti...more >>

I have a report generated using Reporting Services that contains a report parameter of integer datatype. I was asked to put a "validation" on the report parameter to accept only numeric data. The RS used to crash if any alphanumeric data was input in the report parameter textbox. Basically, ...more >>

Is there any documentation of setting a RS web farm while still using Form Authentication. Thanks, Jas....more >>

I created a report with a subreport. When running the report from VS.Net the subreport runs fine. However, once I put the report onto the report manager page only the main report runs and the sub report has a Error: Sub Report Cannot Be Shown. Does anyone have any suggestions on how to fix ...more >>

Hi, We are accessing Reporting Services via the Web Service, using a report image page to handle streams off the render. This has worked great for months. Recently, some of the staff have upgraded their IE to 7. What has happenned is these images are coming up blank - not the red X m...more >>

I am new to reporting services and I have heard that there are reports available to report on reporting services. IE. Which reports are run, how long they run, how often they are run... Can somebody tell me where to find those reports? Thanks, Ron...more >>

I keep seeing post saying that you can hide parameters and pass the values through a querystring by clearing out the prompt string and unchecking prompt user. However, when I try this i get an error saying the propery is read only. Any Suggestions. -- Thanks, Danny Bader...more >>

I am calling ReportManager home page ( http://webservername/Reports/Pages/Folder.aspx ) when i click on the Reports link in my classic ASP application. Right now it asks for authentication and i have admin rights and i created a user account with browser access in ReportManager for other use...more >>

Looking for assistance out of a difficult spot. I have several subscriptions that need to run on the last day of each month. However, Reporting Services has a problem if I set the schedule to run on the 30th or 31st of each month. Has anyone figured out how to do this? Currently, I must ma...more >>

Hi all, our team is really excited about the new ReportViewer control. Heck, it even supports custom data sources, which fits in nicely with our overall application design. The only thing that seems to be missing then is a control that allows our users to design (or at least modify) reports t...more >>

Hi Is there any way to remove any hyperlinks in a report when they are exported to another format like Excel. Thanks ...more >>

I have 3 Datasources setup in RS. 4 Parameters Startdate, Endate, paymentType, LoanType. The Main query uses the 2 other Datasets created as Unions in order create the 'ALL' parameter and display queried parameter values. Everything works beautifully, however I converted the Main query in...more >>

Using the MS SQL Server 2005 CTP on os win2k prof. I have set up two datasets in a report that are supposed to be referencing to separate data sources where the following connection strings are aimed at separate files in the same target folder: - DataSource1: - Dsn=Excel Files;dbq=<dr...more >>

I am currently evaluating reporting services. I haven't been able to find any information of the following subjects. Can Multiple Reports be dynamically combined into one at run time? I need to allow users to select which reports to run (all which can be run individually else where) and if...more >>

Hi all. Product: SQL Server 2000 Reporting Services Service Pack I am trying to display a calculated field in the Page Header for every page. I have tried the suggestions written, but the textbox only appears on the Page Header on the last page of the report. For example, textbox29 in the ...more >>

I've got 2 tables and then 2 matrix on my report, all seems fine but I want a page break after each, after the second table the first 2 rows of the matrix is printed on the same page. then there is a page break and the whole matrix is printed on the next page. I've tried putting a text box i...more >>

Hi I had the problem of my linked reports not picking up the same page settings as the base report it was linked to. After googling around a bit I found what looked like the solution, a nice little script on Brian Welckers blog which resets the linked report page settings to the same settin...more >>

How do you clear or remove unwanted historical Project Names within Recent Projects in Visual Studio?...more >>

I’ve developed a CustomReportItem using VS 2005 RC and SQL Sept CTP. All work great if I use a Report project in Server Mode i.e. I can drag & drop the control onto a report and test it. Sadly, when I try to create a report in LOCAL mode, I’m unable to drag & drop the control onto the rep...more >>

I've loaded up Reporting Services 2005 and it's all working, but under Subscriptions I only get the choice of "Report Server File Share", and not Server E-mail delivery, any one know why? -- Regards <<<Bryan Avery>>>...more >>

Hi there, My report needs 4 parameters. So as normal the report opens up and you fill in the parameters at the top. Fill in the parameters. Generate report and all is good. But now, Is there a way to fill thouse top parameter fields when populating the report initialy? The problem comes i...more >>

Hi, I have developed a simple app using asp.net (vb.net 2003). Normally I would copy the application files from c:\Inetpub\wwwroot\ to the server and paste them to the same location on the server. I have installed a new server with win2k3 sp1 and installed beta 2 of sql2005. I have ...more >>

Has anyone published (web or otherwise) any guidance on building SSRS 2005 data models yet? Books Online is pretty much just a step by step low value guide at this stage although I'm sure white papers etc will come along eventually. ...more >>