Hi, I know this topic comes up alot and i've tried everything mentioned here with no luck. Basically what I want to do is accesing the reports via the Web Service from an ASP.NET form. below is how I do it: ReportingService rService = new ReportingService(); rService.Credentials = new Netwo...more >>

When exporting a report to Excel 2003 my calculated field exports as "Number Stored as Text" is there a way to set these to export to Excel as Numbers? ...more >>

Hi there I am using MSSQL Server 2000 Reporting services to generate my web report, my query regarding this is that i want to read session variable and pass it as a repot parameter to the reporting server, in order to get the desired report.I will be highly obliged if any body could help me ...more >>

Hi there I am using MSSQL Server 2000 Reporting services to generate my web report, my query regarding this is that i want to hide the parameter passed through query string in a url from appearing in a Internet address bar.Is there any way to pass the parametrer without displaying it. I will...more >>

hello all I have situation where fullnames of persons from different databases have different number of spaces seperating first-name, middle-name, last-name. which is resulting in duplicate entries when I do a search from my reports. Is there a way to strip these white spaces inside the fulln...more >>

It has been mentioned that a custom assembly dll can be deployed under either /Report Designer folder, or under /ReportServer/bin folder. I am wondering if the first location is simply for preview to work. Also, if the custom assembly needs to access some configuration data, what config file ...more >>

I need to install the sql server report service on 2 web sites on the same server. The urls are www.xxxx.us and test.xxxx.us. How do I go about doing this? I successfully installed the report service on the default web site of this server, but normally it is not started. I copied the v...more >>

I've been trying to convert a complex Excel worksheet into a Reporting Services report. So far I have a report that has several tables, each with its own dataset. One thing that seems very tough to do with RS, but easy in Excel, is to refer to fields of one dataset from another. In Excel, y...more >>

The only documentation that I can find about this method is that it exists. What does this method do and how is it used? Thanks Scott ...more >>

Hi, I need to change the look of the report manager. Like add different color to background...add a logo & stuff like that.. Is that possible? & how? Thanks -- pmud...more >>

Is there a method for doing simple validation of report parameters? I would like to limit numeric input, for example, to a min/max range. Also, I would like to apply an input mask. (what I'm actually trying to do is provide an input parameter for IP address, in the format xxx.xxx.xxx.xxx) s...more >>

I've only ever used Reporting Services a little bit yesterday & today and it has locked up VS 3 times. It appears to be when I lock my workstation and come back a while later, but that may just be a coincidence. I am unable to click anywhere within the VS environment. I can click on the ta...more >>

Hi, Is there a way to run a command line to trigger my subscription to run reports, generate PDF report and drop it into a shared folder? Thanks. Charles ...more >>

I want to export my repot to PDF and excell, with my toggle button's pressed. I see 2 ways to export. 1 with the Toolbar, and by making a url with FORMAT= Problems with the Toolbar: 1. Toolbar doesn't work without IE. 2. When I have a toggled table, Top 5/ Show all. When I export to exce...more >>

I have a data driven subscription that runs every day and distribute a list of each reps orders to them. Today a rep claimed to not get hers. I think she deleted it. When I checked the subscription status it said 52 processed 52 done 2 errors. How can I find what those errors are. I check...more >>

Hello hello hello hello (say with an echo effect) where are you you you you you you (again, say with an echo effect)...more >>

I need to count the number of unique transactions in a report. I have a report that shows credit card transactions grouped by Approved or Disapproved. Group 2 shows how many different payments they made. For instance, they can make a payment on utilites and another payment on cable bill. Fo...more >>

Can someone tell me how from a stored Procedure how to put results out to a flatfile without column headers?...more >>

Hello All: I would like to modify the background color of a textbox based on its value. A simple iif statement would suffice, but the report is grouped by product, and each product has a different error band for this parameter. Ex. for product DFT, the background color should be transparen...more >>

Hi all, I'm having some major trouble in importing Microsoft Access reports in to Reporting Services. When i use Visual Studio .NET to import reports, it throws the following error: -- Error : An error occurred while the report blah was being imported: Reserved Error -- This happens...more >>