What query may I use? Oleg ...more >>

When a report is displayed it is displayed with one page, however when we print using the activeX print functionality 2 pages are printed. Is there any way to make the report page numbers be the same as the printed page numbers? ...more >>

I know this issue has been flogged to death on this forum, but I'm still having difficulties. I'm using this code to open a page from a report... ="javascript:void(window.open('" & Fields!url_address.Value & "','_blank'))" It works fine, but I get one user, ONE!!......that it doesn't work...more >>

hi, i'm testing the new reporting services with sql server 2005. i have the following problem. i have a table. the primary key is a type of string. if i select more than one value in the drop down list i got an syntax error. do anybody got a solution for this? thx Martin ...more >>

I am using Reporting Services with SP2; SQL Server 2000 with SP4; Windows 2003 Server; 1GB freespace and 1GB RAM. Previewing my report in either IE (ReportServer) or Visual Studio, the expand and collapse on my drillthrough works just fine. I can export to Excel from Visual Studio's previe...more >>

I have a PNG embedded image as the background image for a table in my report. Everything works great except that since we put reporting services SP2 on our server when you try to render the report to PDF, Adobe gives the following error: "insufficient data for an image". Everything worked ...more >>

I need to set a default start paratmeter for a client report where the period always begins on Aug 1st. The report & delivery via email on the first day of each month for the period 8/1/?? through the end of the previous month. Typically, we run reports for the previous month only and my st...more >>

I am VERY new to reporting services, so I think this should be an easy one. I created a simple report that uses a SPROC as the dataset. There are 2 input parameters for the SPROC... 1) a Dealer number 2) a Inventory number. The dealers are uploading pictures of the inventory items onto m...more >>

If your IT department were in a position to choose between Crystal Enterprise 11 and Reporting Services 2005, which platform would you choose and why? Also, if you don't mind answering one or more of the following questions that are specific to our decision making: - What is your overall i...more >>

Currently our users can filter data but they cannot manually group data differently without us having to create them a new report with their required group options. Is there a way perhaps to hard code maybe 1 or 2 group levels in a reports and then turn them off or turn them on dynamically ...more >>

Hi all, I want to create a report that let end user sort the table by click head of the any column, ascending and descending. How to do that in reporting service? My reporting service is in Visual Statdio .Net 2003 Best Regards, Sebastian...more >>

Is there any way to rotate the text on the X-Axis of a chart to a 45 degree angle or are the only options horizontal and vertical?...more >>

I have a subscription that will not deliver to a file share. I've ensured that the windows acct for share access for the subscription has read/write to the share. The error I get in report manager is: Failure writing file <report name>: The Report Server has encountered a configuration e...more >>

This was working this morning... My network login was set to expire, so I changed my password. Now I cannot compile or deploy any report. When I try, I get 1 failed in the Build Output but no error is displayed in the tasks. I have tried creating a new solution with no luck. Anoth...more >>

Hi All I have been attempting to get an ASP.NET app on one server to access a Report Server web service on another server using Windows Integrated authentication. This is done in VB.NET code. The crucial security line of code is: service.Credentials = System.Net.CredentialCache.DefaultCr...more >>

Hello! i have a report with a footer in it. The footer contains 2 textboxes. One for date and the other for page number. When I export the report to excel, it does not render, or show, these values in the file. When I export the report to pdf file, it only render, or shows, the date value...more >>

Hello, Basically I have a problem where I need to run SQL code to populate a table which the report then uses to generate data. The "easy" solution is to included the code before the SQL query in a single dataset. BUT I am currently using multiple datasets which all need to access the ne...more >>

Ok, I have written our invoice printing software using the rs.render on Bryan Keller' blog (of Microsoft) to directly send the Invoice with RS straight to the printer as an EMF. It is painfully slow, but I found that the speed almost tripples using my development computer which uses dual Xeon ...more >>

Hi We have a report which is linked to a subreport of further information. The subreport is simply linked through URL access with querystring parameters. If however you return to the main report and then click a subreport, we get the swirling logo (which I assumed would mean that it was ref...more >>

Hi, This is probably something really simple, but I haven't found a way to do it: I have a column chart and need to display the values (the gridlines on the y axis give an indication but you wouldn't know the exact value). Thanks for any help, Dom ...more >>