I have created a number of reports that I wish to run in the early hours of the morning so they do not choke our servers. I have based the report on a snapshot which seems to work fine as long as the parameters are fixed. Since this is a monthly report the underlying date parameters change ea...more >>

Can we use form authentication with Reporting Service? Is it more convenient to do with form authentication if I use Report Viewer in webapplication? ...more >>

Hi , I'm using the ReportViewer control on my web site . I need to implement the report bar : forward, back, refresh, pagecount, print. 1) How can I know how many page are in the report, the standard report bar display the pagecount but how can I get it ? 2) How can I implement the Print but...more >>

I can Install SQL Server 2005 (not Express) in Windows XP But I can't find Reports Virtual Directory in IIS. Can we install reporting(Sql2005) Service in XP? ...more >>

When I try and create a folder using the following syntax: folder/subfolder/anotherfolder I get the following error The item name is not valid. Item names cannot contain the following reserved characters ;?:@&=+$,\*<>|"/, and cannot consist exclusively of dots or spaces. When checking t...more >>

Yesterday, we upgraded Reporting Services to SP2 (from SP1) and SQL Server 2000 to SP4 (from SP3). Since then all email subscriptions for all reports fail with "Failure sending mail: Access is denied" reporting under Status in the Subscriptions tab. All was running well until the the service ...more >>

We are having two problems with the Report Explorer web part of RS 2000 SP2: - Using a List mode display in a zone that is narrow enough to force the report title to wrap, it still wants to scroll the list a little horizontally rather than just go vertical. For example: Report Example ...more >>

– export as CSV, XML or web archive creates an axd file. I don’t know why it does this… Exporting as different file types is not something that we set up ourselves when we create the report – SQL Reporting Services handle exporting files. I’ve had a quick look on the web and haven’...more >>

Hi, Does anyone know the maximum reports can be run at the same time in Reporting Services? I try to schedule a dozen reports (update snapshot) at the same time. When I check the execution log table, it looks to me that RS queues all reports and allows only 2 reports to be run at any given ...more >>

I have a column chart that has y-axis values that range between -100% and 100%. I'd like the y-axis to autoscale at both the maximum and minimum end, but always be sure that 0 will appear on the graph. So, basically I'd like my minimum to autoscale anywhere between 0 and -1, and my maximum to ...more >>

Hi folks - I am trying to figure out how to set up the visibility (expand/collapse) for my grouped matrix. So for example: A A1 10 A2 15 Total A 25 B B1 35 B2 30 Total B 70 I want the user to be able to click and collapse to just see this: A ...more >>

I have a customer that wants to use Reporting Services on Sql 2000. I have looked over RS 2000 and been having a horrible time getting the trial to run through one report creation (going on 2 days now). I am wondering if RS 2005 over SQL 2000 is/will be available soon ... as that would see...more >>

Using RS 2003, SP2. I have a bunch of reports and several report servers. All of the reports use shared data sources, each report server uses a different data source (one goes to a production database, another to a test database, etc). What I want to do is put a TextBox on the report and ha...more >>

Hi! I have added parameter fields for Start Date and End Date selection on a report using Reporting Services. They are behaving like independant fields. How do I tie them together so they behave like a between 2 date selection. Also when I preview the report, it looks like it goes throug...more >>

I have a matrix report that has an embedded Pie chart on the Rows box for the Matirx. This produces a Pie for each row that shows up on the report. Everything shows up fine but I want to show a percent on the Pie rather than showing the hours calculation. I have figured out how to do this f...more >>

Do anyone know what the following error messages mean? ERROR: [rsOverlappingReportItems] The line ‘line1’ and the textbox ‘textbox2’ overlap. Overlapping report items are not supported in all renderers. [rsReportItemOutsideContainer] The textbox ‘textbox1’ extends beyond the r...more >>

Hi, I just installed reporting service on a new box and it contains SQL server 2000 also. But, when I get into the manager screen, the options such as New folder, Upload files etc are all disabled. The hyperlink appears but nothing happens when i click on them.. Any suggestions? Thanks in a...more >>

Hi, I am trying to get a link out of a report to open another web browser with the HTML rs:target=_blank as part of the string parameter that is passed in...but it still opens the link in the same window. ?How does one open a link out of a report so that it will open a new window? THANKS!...more >>

Hello all, Hopefully this is an easy question.:-) I have a server setup on a notebook that gets around all over for demos and classes... Just tried to setup Reporting Services for app we need to demo. It works great as long as it has network access. Stops working when network access is remo...more >>

I've got a parameter that I am populating from sql, but I'd like to be able to add some functionality that does something like check for permissions of the logged in user and use one dataset over another. Is there anwyay I can achieve this or simulated it in any way? Thanks in advance W...more >>

Hi Group, I posted this problem two days ago, but it went unanswered, so here I am, giving it another try - it's really important for us ! Reformulation : We have a report that we can run in ReportManager. It takes about 15-20 second to generate, but it displays the html on the screen. It ...more >>

Does anyone know any alternatives to Visual Studio for creating reports in reporting services? I have tested on 3 different machines and formatted my HDD 2x and still cannot get this app to hold stable for more then an hour or so.... Visual Studio .Net is by far the most unstable MS app I...more >>

Has anyone experienced this? One of our users cannot see the Document Map icon on any report he views. Clearly this is an issue with his browser or O/S or how his system is configured, as everyone else can see the icon (and the map!). Any pointers to what might be causing this greatly appr...more >>

--Hello All , I am having a problem generating data models with SQL Reporting services 2005 from the web .I installed and configured 2005 Reporting services , created few reports and gave access to the users to view the reports from the browser .Everything goes well till this point . Bu...more >>

I keep getting a "Logon Failed" beside my subscription in the GUI when it Runs. SQL Server Agent is running. SMTP is setup right in the RSServer config file. My DataSource is setup to use "Credentials stored securely in the report server" And this is a user we created to access both the da...more >>

When I try to access the reports site using http://myserver/reports I get the following error The request failed with HTTP status 401: Unauthorized. Is there any error happening with respect to web service level?? If so how can I track that service?? ...more >>

I am having a lot of difficulties in grouping totals. Could someone please help! EXAMPLE: Group1 123 Group2 456 Group3 789 ...more >>

Hi, I've got a report that I invoke from within Javascript using a direct URL hit to the report. When the report generates it asks to either "Open" or "Save" the PDF file. When I click on Open it opens Acrobat Reader to view the file. I need the report to open within the same browser as the...more >>

I need to run RSCONFIG and change the account used for reporting services. The password I need to use has the character | (it looks like two sideways minus sings one on top of the other) When rsconfig runs, I get the error "the rest of the statement is not recognized" and the text after that c...more >>

I have the following data: Name Note Type John Needs 2 more credits Schedule APPT. John Needs 2 more credits Phone Call John Needs 2 more credits Office Visit Jane Final Check List Phone C...more >>

I have a report setup against an analysis service cube. It runs fine. Users choose a date from the parameter list and then it pulls out the data nicely. I need to programatically have it select a parameter for yesterday's date. Somebody suggested setting a default script for the parameter ...more >>

Hi there I am wanting to dynamically set the background colour of a textbox by using a colour value passed from the data. How would i go about this? thanks, Jennifer ...more >>