Hi, I have seen a couple posts about this but none seem to answer my question. I have a bar chart currently grouping by month; category groups expression =month(Fields!CLSDDATE.Value) I would like to group this chart by quarter but I am at a loss, any suggestions? Thanks, Marcus...more >>

I am using SQL 2000 Reporting Services. I am trying to get a column group to shade if it starts with the word Total. The problem is there is not always a "Total" value for a particular "row group" (date). Is there a way to shade the entire column? Here is the current formula. Is there ...more >>

All-- Can the VS.NET 2005 ReportViewer control be hosted as an ActiveX control in VB6 if it is wrapped so that it can be consumed as a COM object? TIA, booboobear in Queens, NY...more >>

Does the ReportViewer support hierachical subreports (a subreport in a subreport)? If so, how do you get the SubreportProcessing event to fire on the second or higher level subreports? Or better yet, how do you add a subreport to a subreport and get it to populate? -- Thanks, Paul...more >>

We have a two node clustered setup with couple of instances on each node. I am trying to setup a reporting services on one of the nodes. For testing, we did IIS install on the same machine. Used configuration tool and setup reporting database on one of the sql instances. The install didn't...more >>

I have written a CLR stored procedure and loaded it up into SQL... I can run from there but when I reference it from Reporting Services, I get an error saying that the stored procedure does not exist. IT DOES!!! There was a post in this group where the answer was to have the Command Type set...more >>

i am trying to concantinate onto a string but I only want to add results that have not already been added. here is an example of what I am doing. I have tried it with both where clauses and get the same results. any explenation? declare @seq nvarchar(32), @counter int set @seq = '' set @coun...more >>

I am having a hard time figuring out how to total a column. If I have January Febuary March Type1 10 4 3 Type2 4 8 2 Type3 1 9 1 I want a total for each month, NOT each type. I have tried ...more >>

One of my clients is asking me if it is possible to use Apache (Oracle's web server) as the front end for Reporting Services. I am guessing that the answer is no, but does anyone out there know for sure? Any details would be helpful. Thank you, -- LaurieT...more >>

Working in SSRS2005 I've been asked to create some simple reports that use t-sql to generate a couple of tables. Easy, me thinks... The concern is that dates in the tables are supposedly stored in UTC, and MUST be displayed in local time. Even if I do a datediff() to find the UTC offset...more >>

Let me preface this by saying that am relatively new to SQL. I have a database that is updated every10 to 15 seconds with broadcasts from our customer. These broadcasts come from 2 distinct points in their operation. The first point - 39 - tells me what to build and ship to them. The second p...more >>

I would love to have my graphs dynamically to be grown or shrinked. Though, no property (like can grow/can shrink) is being shown in both the standard graphs and dundas add-on. Does somebody have some custom code or a proper workaround to have axes to be dynamically grown or shrinked? A worka...more >>

hi, after changing the order of my report parameters (in this example test) in the menue via the up and down arrow I get the following error message: an error occured during local processing. an error occured during report processing. the value expression for the query parameter 'date' con...more >>

Hi, Is there any way of leveraging the new report model / ad hoc functionality when reporting from xml data sources? Everything seems to be based around if your data is actually in an xml format. Is this at all possible? More specifically would it be possible if the xml data source was in ...more >>

hi, I made a report with a diagramm and I enabled the option to show the values in the diagramm. Unfortunately it also whows 0% values (not the bars but the label). Is there any way to switch this off? Thanks! ...more >>

hi, I made a report with a diagramm and I enabled the option to show the values in the diagramm. Unfortunately it also whows 0% values (not the bars but the label). Is there any way to switch this off? Thanks! ...more >>

Hi, In RS2005, is it possible to re-order the report columns at fly? How can this be achieved? TIA, Tanmaya ...more >>