Hello All: We have setup Reporting Services. I want to integrate it with Fax server for creating new subsciptions using custom delivery extension. Apart from this custom extension, I am having one more solution for this scenario and that is sending email (in the format <fax number>@<fax ser...more >>

Just curious if anyone has any hints to embed HTML directly into a report. I am doing reports that will be exported to excel when run as a subscription and using an index (which jump to bookmarks) and page breaks to get each report onto new tabs. My current report, done with a different to...more >>

=sum(iif(Fields!PDDAYS.Value>30, Fields!CBAL.Value),0) It returns #ERROR Isdbnull did not seem to work and the LEN thing did not seem to do it, but maybe I am not using them right. Help!...more >>

Here is my problem. I am using code in a report that uses the System.Data dll to access data from a remote SQL Server. On my development machine, I can view the report without a problem. When I deploy the report to the Report Server (Windows Server 2003), I get the following: Request For...more >>

Hi, I'm using Microsoft.Samples.ReportingServices.ReportViewer for visualization of the my reports in dotnet C# application. But, my the ReportViewer position in my folder and do not in my report when i show my dotnet application. Example: My RS manager is: http://maq-100911/Reporti...more >>

The bug fix No.883647 - you render a report to a PDF file, the page breaks are incorrect in SQL Server 2000 Reporting Services. - Didn't help me. I still have page breaks problem after I install SP2 and hotfix. I have include a subreport (with table on it), it has proper page break if table r...more >>

We are having problems with Reports that Access MSAS. After about 15-30 minutes the reports no longer work and we have to stop and restart IIS and make one visit to the report manager page. We have to continue to visit reports or the report manager page every 15 minutes of we get rsProcessingA...more >>

I want the bars in my bar chart to be sorted from highest to lowest. I want it to look like a pareto report. How do I sort this ? Doing it directly in the query will not work because I am letting the chart do all my counting and summing. ...more >>

I'm trying to format negatives to be surrounded in Paren () rather than preceded by - (accounting style). I know that if I pick currency it will do this, but I want to format numbers to be just integers, not preceded by a - sign, and have commas. Here is my current format string: "0,0" , whi...more >>

Hi all, Does anyone known or recommend for good publisher issues articles which have good tips/tricks on sql reporting services. Thank you. L ...more >>

I have a database with a reservation system, and I need to display a weekly view of the reservations from each room. The reservations are stored as a start date and an end date. Does anyone have any suggestions for how to display this properly? Do I need to set up 7 individual queries? Here...more >>

I know there have been many questions regarding extending RS to report off of different data sources (xml, ado etc) - we are successfully running our reports off of SQL Server stored procedures and are using the web services (not url) to render directly to PDF from a custom asp .net UI. We wo...more >>

How a client, can from VisualStudio2005 associate to a report a SharedDataSource published on the reportserver. I have seen that the association can be created from the web interface of the report server, I, would like instead to directly create the association from VisualStudio. I have...more >>

Hi, Does Sql reporting services support Bmp BLOB files? Sapnil...more >>

I have a simple select statement I am using to gather possible values for a parameter. I would also like the end-user to have the option to select all records if they choose. I have several parameters that need to meet this requirement so it would not be practical to create a seperate report f...more >>

Hi guys, Is there any method to add/delete dynamically columns in a table, not in a matrix? thanks, Radu...more >>

Hi, This is probably easy, but I couldn't find a nice way to do it and had to delete the <Groupings> from the .rdl in the end: I had a Grouping added to the DetailRow of a table (to be able to show/hide detail rows). Then I wanted to delete this Grouping. But no luck. Is there a way to do ...more >>

Hi, I have a minor problem with grouping a Sub Report. The Sub is a "Daily Total" table, grouped by day, using date parameters @StartDate and @EndDate which are also used in the main body. The Sub Report run on its own displays each day on separate pages, however when inserted into the m...more >>

I got the following error when exporting a report to Excel Reporting Services Error -------------------------------------------------------------------------------- Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get On...more >>

Hi, a lot of my users were asking me to have the possibilty of a freeze pane (similar to excel) in the RS web reports because often the reports are to long to see the column haeders. Especially when you have drilldowns it would help. Has somebody tried to implement such feature by DLL to RS...more >>

My (all) subscriptions dissapear from the 'my subscriptions' dialog, but they still exists in the database, datatable 'Subscriptions'. Anyone have an idea how I can 'enable' them again? Is there a setting that I nedd to set? Maybe in the ConfigurationInfo table ...? Thanks.. - Frank...more >>

Hi all, I have created about 40 reports that access our core ERP solution. All these reports function perfectly. In the last day I have created 2 new reports that access a different server/database thus a new shared datasource was created. However, I am intermittantly receiving the followin...more >>

Is there any way to start up a windows application and pass parameters from a report. I know its a long shot but I am sure somebody knows how to do this. -- Gene Hunter Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200508/1...more >>