Hi, How can I use RunningValue Aggregate Functions in a chart? I put "= RunningValue(Fields!Volume.Value, Sum, Nothing)" in the "Chart Data Values" properties, but it raise this error message"\\twajkp05\smm\reporting\smm\Vol Bill NRW.rdl The expression for the chart ‘chart2’ has a scop...more >>

Hi, I installed and configured RS to use Windows Authentication and given Browser permission to several users, all work well except for 2 users (well so far 2) who could not view reports. What comes up on their screens are just the the Home link, and an open folder image, they can not see an...more >>

is there anyway to add one of those yellow boxes with a comment to a cell in tables? Like the way it is when you mouse over a cell in Visual Studio. ...more >>

I'm using an rss script to render a report and save it to file. All is well except that, for the life of me, I can't get the TIF's color depth set to 1. Setting DPI works but not colordepth. A nudge in the right direction would be most appreciated. Mike Dim format as string = "IMAGE...more >>

I need to group data in one of my reports by week end date (Saturday). I've created a custom assembly with code to do this, but am having trouble getting the assembly to load. So, I've decided to go to the community. Anybody got any ideas on coding a function to return week end date given any ...more >>

I've created a custom assembly using C# that provides utility functions for reporting services. I'm getting a the following compile time errors. 1. Error while loading code module: 'accentopto.report.utilities, Version=1.0.1885.19928, Culture=en-US, PublicKeyToken=null'. Details: File or as...more >>

Hi all, I have a RS report which uses the records returned from a Stored procedure as it's dataset. There are graphs on the report but we get the Red X and no graph. Like other posts in the forum this is intermittent getting the graph sometimes and not getting it other times (more often not...more >>

Hey peeps, One quick question: Is there a way that I could customize the ReportViewer.dll...like in the sense, I have a param drop download list containing dates that the user selects. Instead, I want to embed a calender control beside the dropdown or anywhere in the ReportViewer.dll. Can you t...more >>

I have created a report that does check print. Most of the layout contains text boxes. I am not using tables to generate the check. However, I need to know if there is any way to do a page break when check numbers change like you do with tables using grouping. Please tell me if there is a ...more >>

Hi, In my matrix in the report, I need to add a column group which groups the columns based on months. But i dont have a field in the database for month. I have a field called Order_Date. Now I need to see all the orders for each month. So in the column group expression i used : Fields!...more >>

I have used Reporting Services for several months now - but have recently ran into a problem that I'm having a hard time overcoming. I have a report that has 3 groups - District, City/County, and Project Number. A Project will be in a city/county, which itself is in a District. So Distric...more >>

ok here's my situation, i have created a report that brings data similar to the sample below Date Col1 Col2 March 1 2005 10 15 March 2 2005 11 26 March 3 2005 7 14 so i created a column chart that plots this data with numbers going across the...more >>

Hello all, is there a limit on the length of a Parameter. All my reports are throwing the following error whenever the lenght of a parameter is more than 30 chars!. "String or binary data would be truncated" Can I alter this value somehow ? Or a way around this issue ? If not I will hav...more >>

Hi, Anyone have any ideas how I could create a GANT chart from within MS SQL Server Reporting Services? I have a list of activities that must take place on different dates and need to be able to display them all graphically. Any ideas would be most helpful! Thanks, -- Eric...more >>

Hi all, I'm sure I'm missing a simple step but I can't find a way to prevent a table cell from wrapping it's content. I only want one line of data in the table cell. If there is more data than a single line, I'd like it just to show an ellipsis at the end of the first line. I tried turnin...more >>

Hello I have textbox in my report whose value is a field from the database. When there is no data in the field of the database, I dont see the textbox(I have a solid border) when I view it from the Reportserver link But I can see the empty box when I export to PDF. Another strange thing is...more >>

Hi Gurus Now I am using the stored procedure to create reports using Reporting Services. The stored procedure returns the data so that the first row contains the column header information. Something like this. H1 H2 H3 H4 ...more >>

Hi all, I am facing an interoperability issue. This is what I am trying to achieve: "Access .NET reporting web service from Java Axis client" This is the SOAP request I send: Java Axis client --> .NET web reporting service <?xml version="1.0" encoding="UTF-8"?> <soapenv:Envelope xmlns...more >>

I have just installed the Feburary 2005 CTP release of SQL 2005 and I am trying to use the report builder feature in the reporting servies website. When running the web browser on the SQL server (windows 2003), I click report builder and it opens the "new report" dialog with an empty list of ...more >>

Will Reporting Services 2005 have multi-select capabilities for drop down parameters? Also, if I download SQL Server 2005 will I get RS 2005 with it? Thanks, Doug ...more >>

I thought I posted this issue last week, but I can't find the post so I have create it again. I apoligize if this has already been answered. Anyway, here is the issue. I get the following error when trying to send an email attachment within a subscription:Failure sending mail: An internal er...more >>

Hi All, i have been caught up with these issues the whole day... Please someone help me out.. 1) The report needs to be printed in Landscape format 2)i prefer $220,000 and not $220,000.00 for the currency format 3) Im displaying two dates in a single textbox using =dateadd("d",1 ,First(Fi...more >>

Hi, Can we combine multiple reports and render it in a single pdf file? For example: There are two reports deployed in RS Server. Rpt1 & Rp2. I am accessing those reports via web services, so i m having the those reprots as Array of bytes. Can i combine this two reports and render it in a s...more >>

Hi All, I am facing a prblem while i export a report to excel format, The report doesn't open properly in excel, the report is distorted. Is there any way i can overcome this problem. Thanks In Advance Gunjan Jain...more >>

Hi, I'm making a backup plan for Reporting Services. The problem is that I don't know what to backup in order to recovery a complete loss of a Reporting Services Server. It is enough to backup the databases ReportServer and ReportServerTempDB? There is anymore actions I should do? Thank...more >>

Hi, i was wondering if it is possible to export a cached version of the report to excel. Because now, when i render a report, it is quite time consuming. And it get worse when i try to export it to excel (probably because the report has so many sublevels, but i don't know how to turn them o...more >>