I have a report rendered in HTML, how can i allow the user to sort the report based on the user clicking the column?? any ideas? ...more >>

I'm running several hundred parameterized versions of the same report on a single shared (timed) schedule. The reports have a dozen or more sub-reports. I'm getting sporadic instances of the report where I get the infamous "Error: Subreport could not be shown." Usually all of the subreports fa...more >>

I was trying to create a simple report to compare two years' sales by region (2004 vs. 2005). We used to have 13 regions before 2005. Now we only have 12 (DOM013 was removed starting 2005). How can I make DOM013 to appear in the comparison table even if we have no data for it in 2005? Any hel...more >>

I'm assuming that you can use the "jump to" report to run a subreport from a pie chart. I would like to be able to click on a section of the pie chart and have it display the detail records that make up that portion of the pie chart. Has anyone worked with such? Any suggestions on how to ma...more >>

For one of the tables on my report i need to allow only the records where a certain datetime field has Null value. I have not been able to figure out the expression in the filter that would do this. Any ideas? I cannot do this in the select statement as other data regions require records...more >>

Hi all! I am trying to filter a dataset. Could someone help me? I only need the last 12 months from the system date. systemDate.field< 12 Months Anyone have any suggestins? Thanks in advance, Kerrie -- Message posted via http://www.sqlmonster.com...more >>

Are there special considerations for installing Reporting Services in a clustered SQL environment? Specifically a Veritas cluster in Failover (Active/passive) mode? I know the installer seems to expect you to install to the default directory, but the cluster environment uses multiple named...more >>

I am installing Reporting Services on a Veritas cluster environment on a named Instance of SQL Server. The installation seems to go OK, but afterwards when I try to call up the ReportManager I get this error: Access is denied: 'Microsoft.Samples.ReportingServices.CustomSecurity' I'm using ...more >>

Hi Present we are using crystal reports 8.5 in VB application . database is SQL server 2000. How can convert existing Crystall reports into SQl Server reports and How to call SQL server Reports in VB 6.0 as like Crystal reports. Would appreciate if any one gives suggestion on this. T...more >>

Hello I have just created some reports and I want to expose them to the internet without windows authentication. I mean that every user outside can see my reports without being part of the domain. Thanks for your help. ...more >>

Is there a property for the hide in list view that I can tap into. I am using ListChildren to get the reports into a treeview but I want to exclude reports or folders that are hidden from the list view. Any help is appreciated. ...more >>

Hi, How can I hide subreports from being listed in report manager using the deploy script? I can do it manually afterwards but when deploying to test and production environments this needs to be automated. Thanks, -- Fairfield...more >>

I get an error when I create a subscription for a report that contains the value = User!UserID The report runs fine If I view the report (or run live). The actual error is: "Subscriptions cannot be created because the credentials used to run the report are not stored, the report is using ...more >>

Does anyone know of a guage and meter chart package that will work with RS 2000? Dundas says theirs will only work with RS 2005. Also, recommendations for any other chart options would be apprecieated. For example 2 column line/bar graphs and the like. Thanks!...more >>

Hi, I'm using the following in the colorbackground of the group header to change the color of the group when a group name changes. =iif(RowNumber("DTM_Group1")Mod 2, "White", "Cornsilk") But this is not working properly when the group name changes! Could some one help me with this? ...more >>

Hello, I have a problem when I export my report to Excel : the cells are not considered as numbers. In my report, I have a table witch fills data formatting with 1 decimal if the data is not null. It's important because 0 and null must be considered as different values. An example of on...more >>

Hello, I need a optional watermark (some colored retangles) on every report page. I have tried to add retangles with different background colors. Doesn't work because the retangles match the size of the including table (if the table has half size of page, the retangle also -> Should fill th...more >>

Hi All, Has anyone wroked on Reporting Services webparts. If so please clear my doubts.... I need to integrate Reporting Services Report to Windows Sharepoint site, I need to show the Report in the Sharepoint Site (this is possbile by Reporting Service Weparts). - How do I create a sim...more >>