In what scenarios will i have to use "custom code" (Report->Properties->CustomCode tab) for a report ? Is there any example i can see ? thanks Anand Sagar anandsagar@gmail.com...more >>

Hello, I'm trying to generate a snapshot everytime a report is viewed. I've setup the properties of the report to "Store all report execution snapshots in history" but no report is being created under the History tab. The datasource uses hardcoded credentials. The only thing I have fou...more >>

Uninstalled previous version - was recommended in another post - but when starting reportmanager it says: unable to finde script library /aspnet_client/system_web/1_1_4322/webuivalidation.js try placing this file manually or reinstall by running aspnet?regiis-c This is close to be russian f...more >>

Is there any filling effect on the stack bar ? e.g. Apply two colors on single bar and have gradually effect i.e. like Excel...more >>

Hi, I am totally new to Reporting services. I currently ran in to this problem, Any help will be appreciated. I currently have a pie chart with one piece having 95% and the rest 5% is shared by 5 to 10 peices of the pie chart. Now here when I have label in the pie chart, The percentage value...more >>

I'm having the most difficult time trying to generate a report that first calls a stored procedure and then retrieves the data produced from it. I get the error, "An error has occurred during report processing...query execution failed for data set dsOrgs...Must declare the variable @INum" whe...more >>

I have a table that has groups and group headers that start on separate pages for each grouping. When I add a 'visibility' filter the page breaks for different groups no longer work. Is this a bug in SP1? ...more >>

I am trying to change the DataSource of a report programatically using SetReportDataSources and I am receiving the following error: The required field DataSource is missing from the input structure The report has a datasource. What could be the problem?...more >>

I know you can make this work using this approach: http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=0064e121-fd26-4c83-8add-4a694e4fea7d&sloc=en-us ....but my problem is I have additional parameters to my report and w...more >>

Hello, I have a report that needs to be seen in other cultures. I don't see resource files for a report, so i'm wondering the preferred method to do this. Surely I don't have to create a report for each culture. ...more >>

How would I do a datediff between the date within a record in the dataset and an entered in parameter? The following works in giving me the difference from the record to now... but I need to change the now to the @to parameter. DATEDIFF([day], view.DATE, GETDATE()) AS noofdays Thanks ...more >>

Hi everybody, I would like to have a field (CustomerID) that is displayed in the header of the page. I can reference a field of the page with ReportItems!CustomerID.Value. This works fine as long the customer information is not spanned across two different pages. If this is the case the ...more >>

I have a report that will display certain records based on the user that logs in. I need to be able to change the query the report uses programmatically. I havent had any luck trying to find how to do this online. If anyone can help me that would be great. --- Posted using Wimdows.net NntpNew...more >>

I have a database where one of the fields is a large binary object. I would like to create a report where one of the columns shows a link to the "attachment". When the user clicks on the link, they should be able to download the raw binary data (with the mime type of my choosing). Can this be...more >>

Exporting to Web Archive (MHTML) is not working anymore after I installed SP1. When I export to Web Archive and open the file directly IE just hangs. When I save the file to my disk and open it from there it works. All other formats for export work fine. Here is a line from the report file. ...more >>

This is more of a .NET/permissions issue, but it is in the context of RS' forms authentication, which is making it more difficult for me to understand/debug. I have forms authentication working like a charm. However, I am now trying to do some authentication against an Oracle database. What'...more >>

Does anybody know how I can Clean up some European Characters such as "?" in a text field: "45000 m² new office project designed by Arquitectonica. Revised proposal and clarifications issued to client on 26 Aug: 1239K? for MOEX, 985K for Synthese as option. Ten competitors, including Coteba. ...more >>

Good Morning, I have a question. For Use sql reporting services I need on the same server Sql reporting services and VB .Net? Can I use Visual basic 6 or Crystal Report to create a report and only than use Sql Reporting Services to sharing the report? ...more >>

Hi all Is it possiable to have a calendar drop down in a date parameter field? I am not a programmer so be kind. This would be much easier for users than typing in a date. thanks ...more >>

When trying to use a report that requests parameters, while in Visual Studio everything works fine. I can preview the report and select a parameter, click view report and the report works. When I deploy the report to the server and test on the web site, after I select the parameter from the dr...more >>

I would like to display some textboxes depending on the rendering format. I would like to write an expression like this in the Visibility.Hidden =renderingFormat="Excel" Is this possible?...more >>

Hi, I urgently need the answer to a question about SQL Reporting Services licensing. I need to install SQL Reporting Services on an IIS server that hasn't got SQL Server installed on it. The Reporting Services database will deliberately go on a remote SQL Server. I don't want to install S...more >>

I tried to change the MS RS Server port from 80 to let's say 8080. But when going back to MS RS home page I have an error page from MS RS with the following message : "The underlying connection was closed: Unable to connect to the remote server." I can't solve this Could anybody help me...more >>

I want the URL link to be generated dynamically by a function written in a custom assembly. However instead of generating the link each time the link is clicked. The function only called once when the report is generated. Therefore that link always return the same value. How can i implement th...more >>