i have the following dataset pay date, branch, hours group is based on branch question is how can i sum branch hours based on a certain paydate ? thanks...more >>

Hi, Can anyone let me know how to add a group in the domain to reporting services.I tried adding email address and could easily subscribe to reports. but when i tried to add a group by spacifying domainname\group name, it did not work. Can anyone please help!!! Sachin...more >>

Why the first conection on the ReportServices its so carrie to much time?...more >>

I have a report that charts our weekly sales and monthly sales. I use the following SQL statement to reflect 7 days or 30 days, which works but not properly. I'd like for my report to run from Sunday to Sunday for the 7-day report, and from the 1st of the month to the end of the month, regar...more >>

I've seen examples here and there... I've created a reports sql using sql builder in reporting services. Anyway it works great with Select this from that and the other thing where this=@myparam and then I add a parameter to the report that takes in a parameter. I'd like to allow them to c...more >>

Im running RS on Windows 2003 server, connecting to a remote instance of SQL. When I try to set up a schedule for any report, i get... "The SQL Agent service is not running. This operation requires the SQL Agent service. (rsSchedulerNotResponding)" I know its not finding any local sql ag...more >>

My report has 2 parameters. One I would like to set the value of in my vb code, the other I would like to be queried according to the report design. In the designer the first parameter is non-queried and will allow blank but not null. The second is "from query". Obviously everything works ...more >>

Hi all, I've spent the last two hours looking for an example of this, but I've come up short. What I was trying to do was create a 'test' which would toggle a rectangles hidden property. Unfortunately, I can't seem to figure out how to send my toggle function a document object. Here's wha...more >>

Can anyone tell me if Reporting services has it's own service packs that are distinct from SQL server? ...more >>

When I use the Webservice Render method for a PDF, the PDF shows perfectly in IE but in FireFox it dumps the text of the pdf instead of rendering it... Any ideas? Tim Philomeno tphilomeno@sparling.com ...more >>

Is there a way to pass in the reportname to my datasource for a data driven subscription. For example: exec usp_Rpt_MySubscriptionParms @ReportName The reason for this is so I can append the reportname in front of storenames for the subject header without having to create multiple datasou...more >>

I have a report with a parameter list. The parameter has no default value. When I open the report it renders without waiting for the parameter to be selected and the parameter list is empty. I ran SQL Profiler and the sproc that is used to populate the parameter list is being run and I ve...more >>

Hello We are currently generating reports in PDF format and leading spaces are now being stripped from printed reports. This started to happen when when we applied SP2. Has anyone else encountered this problem and if so how did you get around it. Much appreciated, Kevin Weir Direc...more >>

We have a report that returns more than 65,000 rows that we need to render to Excel. Is there a way to make RS parse the data into multiple worksheets, or will we need to split the data into more than one report for rendering? ...more >>

Hi, I am investigating Reporting Services and wouldlike to develop some reports in Report Designer. Visual Studio 2003 is such a pigfor hard drive space I only want to install the minimum requirments. What do I need to install to be able to use Report Designer to develop reports for RS? ...more >>

We are in a diverse workgroup here and I didn't do the install. How do I know if I have SP2 installed? I tried to check in VS, but it didn't know. Thanks!...more >>

Hi, If I install SQL RS Enterprise on SQL Cluster , do I have to create IIS Cluster Resource for the "Reports" and "Report Server " web virtual directory ? Norman ...more >>

Can I install Reporting Serer 2005 and 2003 on the same server, each 1 accessing a seperate SQL2000 database? Are there any white papers on this regard? Thanks...more >>

Hi all, i created a data processing extension which connects to a web service to get data. Everything works fine so far. But when i look in my DebugView, i see that the RS calls my web service 3 times for one report. is this a normal behaviour or do i have to inquire the connection state? ...more >>

Hi, This topic has been raised a few time in the newsgroup and the solution has been to set the 'Langauge' property of the report. In my report, I can't find the Language propertie, neither in the properties from he menu in VS nor in the Property Grid. Can anyone point me in the right direc...more >>

I am having an issue with the RSClientPrint control. We have a .net Proxy class (ASP.NET handler) which is being called by the RSClientPrint.Print command, bringing the data from Reporting Services and relaying it back to the control after regex'ing all the urls to point back to our proxy. The...more >>