i have create a paramenters and use in the sql, but after i deleting it from the sql statement, i still need to enter the paramenter in the PREVIEW. i have check and clear the parameters clicking the "..." button but when i check the properties of a table and set the expression, the parameter...more >>

Development Environment 1 Web Server - name: dev1, platform: windows 2003 web edition, .net framework 1 SQL Server - name: dev2, platform: windows 2003 enterprise, .net framework 1 Workstation - name: dev3, platform: windows xp pro sp1, visual studio 2003 pro, .net framework Will reporti...more >>

Now I met this question: Our project need us must write a driver to retrive data from file but not from database to form a report. That is to say: I want retrive data from a text file to form a reporting service. How did I ? ...more >>

Is it possible to access report properties in embedded code? An earlier post was looking to set the visible property of a table column depending on the "RenderFormat" of the current output. I am also interested in doing this and began playing in the embedded code window with code similar to.. ...more >>

Hi I'm installing RS Dev Ed. on my WinXp SP1 machine. At the end of the setup project I get this error. Error 1920. Service 'ReportServer' (ReportServer) failed to start. Verify that you have sufficient privileges to start system services. I'm in the Adminitrators group. I also tried wit...more >>

Can I do a check if a field name exists like in an expression: iif(Fields!Time_Month.Value,,) iif(Exists(Fields!Time_Month.Value,,))...more >>

This is my first report. I used VS.NET 2003 wizard to create the report, which consisted of a very simple select query report. When I switch to preview tab in IDE, I am getting the following error. Processing Errors: An error has occurred during report processing. Cannot create a connecttio...more >>

I'm trying to use dates. And sometimes I'll call a query with month, = and sometimes by year. Sometimes if I run the mdx query for month I'll get fields, = Fields!Time_Year.Value and Fields!Time_Month.Value But if I do year, I'll just get Fields!Time_Year.Value. When I try to = write an e...more >>

Hi, is there a way to show labels and value to data point in a pie chart? I'm able to show the value, and i am able to show the label. But I want to show the two. ex: a pie chart of departement, I want the point labels show DEPT1 : 500,2 DEPT2: 200 ECT... thanks francis ...more >>

Hi, this is a pretty vague post but hopefully someone will be able to help. I've recently experienced some problems where the charts wouldn't render at all and the standard IE broken image X would display. Refreshing the page doesn't help and neither does reopening the report. I have a feeli...more >>

When trying to Deploy from my workstation (XP Pro) to the Win Server 2003 which is hosting both the Reports Web site and the SQL Server installation where the ReportServer database is loccated I get the following error: Deploying to http://localhost/ReportServer?%2fRepReport Error rsReportSe...more >>

Will the table header row not print on the last page if the only output for that page is the table footer row? This seems to be that case in my report, but I would like the table header row to also print. Can this be done? ...more >>

Hi, How can I display the report description on the report itself? Have been looking over the books online but can't find the answer there. Maybe its not supported? regards, ...more >>

Hi, I need an application that displays reports, and prompts the user for the parameter values. I have used the GetReportParameters() to retrieve the list of parameters. However, i could not find a way to get the available values when the parameter is of a list type. For example a countr...more >>

Repost of a question / bug I reported one week ago. As I am an MSDN universal member, I think I have the right of an MS employee answer. I want to set report parameters to the first day of the previous month. In order to do so, I calculate a parameter value by entering the following into th...more >>

Does anyone know how to kill a subscription at a certain time. The only options I see are to pick a date to end a subscription (from a date picker)? I would like a subscription to run from 6 PM - 10 PM on the same day, and then end. In fact, I need to have it run 6 - 10 for 6 straight days. ...more >>

I have to create a report that will list the room bookings for a certain hotel in a certain time frame. Sound easy enough right... This is what the report should look like, first lets accept that I pass in parameters for the following: 1. Start Date 2. End Date 3. The hotel I want the the...more >>

Hi! I have a task of delivering a report generated by Reporting Service and exported to PDF to a remove FTP server. I know that RS has support for custom deliver extensions and I need to know a) whether there's already such exntension available (i've seen on RS documentation a mentioning of s...more >>

When RS was installed no RSExecRole was created, or perhaps the workaround for the 64 bit box caused it to be missed. Either way, is it okay to just create the role? and if so, is it okay to run catalog.sql? or should I just pull out all of the grant statements? Thanks in advance... ...more >>

Hi there, I'm having problems figuring out a way to increment a number in a table grouping. I have a report with a table that prints out the top 5 events watched and currently it looks like this when displayed: Rank Event Name Number of Hits 1 Even...more >>

I am trying to implment the third lesson in the tutorial that ships with RS, in step 7 of this walkthrough it is indicated that I should replace the static T-SQL by another in the generic query designer which is : ="SELECT FirstName, LastName, Title FROM Employee" & IIf(Parameters!Department...more >>

Has anyone had experience with developing reports based off items in Exchange 2003? Is it possible to use reporting services to connect to Exchange to report on types of emails or does another type of connection have to made? Any insight would be much appreciated. Thanks. -- *************...more >>

Hi, I started playing with reporting services, followed the first 3 lessons int the walkthrough, I find it a very interesting tool. When viewing a report in IE, we have the possibility to export to excel file. I woudl like to do a dynamic report, let's say generated on the fly at 6 o'clock mo...more >>

Can anyone shed some light on this one? <Func Name='PerformDetections'> 0 Failed to find property in cache: InstalledInstances Failed to perform discovery on machine: DEV01 HRESULT: 2147749891 <EndFunc Name='PerformDetections' Return='2' GetLastError='183'>...more >>

I want to build a report that from an OLAP data source that uses a named set that is a rolling 12 month view. The problem is I don't like the field names that are displayed. For Example, 'ArrivalDate_All_ArrivalDate_2003_Quarter_3_2003_August_2003'. All I want is August 2003. I know I ...more >>

Hi, I wish to save my reports to a fileshare on our network but I need to save the report with a particular name that may vary from week to week or month to month. eg1 : Report1.WK40.pdf eg2 : Report2.CM9.pdf WK40, (week 40) or CM9, (calendar month 9), being the part of the file na...more >>

I am trying to deliver a report to a shared drive on the network that is mounted via Samba. The drive is accessible through normal file explorer and Dos commands. Reporting Services lets me put in a username and password in addition to the path. The credentials are valid. ReportServer ...more >>

I've built my report which uses a stored procedure to supply the data. All works fine. I've now added a new field in the proc that's returned to the report. I've tried right-clicking in the fields window, choosing Add Item... and entering it's name, and I've tried adding it in the Fields list ...more >>

Is it possible to access reports over the web using the viewer control and RS standard edition RS server behind firewall Web app in DMZ I have looked at the security extension example for forms authentication, but I have also read that STD edition of RS cannot use Forms Auth (after we ...more >>

I found a post by someone who was having a problem with their reports refreshing and the solution they got was.... "Please make sure that Report property "Autorefresh" is set to 0 (disabled)" Where is this report property?? I can't find it and I need this to refresh my report.......more >>

Since I installed Windows XP sp2 and reporting services sp1 I cannot modify my reports anymore which are using dynamic queries. If I modify a dynamic query and click on refresh fields my devenv.exe hangs for at least 10 minutes and more. On other development machines with same hardware and sa...more >>

Sali zäme :-) In a report, i have got multiple pages as it should be. Now, i'd like to have just 1 sheet in an excel export including all data, but several pages in preview are generating several sheets in excel. Any idea? thx...more >>