Hi, I have a report with a dataset_1 (select * from SQL_ServeTable // Name: "dsDATA"). Is it possible to use this dataset "dsDATA" in the same report from an other dataset_2 for example "select sum(AMOUNT) from dsDATA"? Thank you for your consideration, Ralph ...more >>

It seems quite easy to format date parameters any way we like when displaying a report, but how do we set the date format to use when entering that date - as an input parameter. Everything works fine with if we accept the default US style (MM/dd/yyyy) but we need to use dd/MM/yyyy. Can we fo...more >>

I need some instruction in how to fix this error. "Failed to load expression host assembly. Details: Security error. (rsProcessingError) Get Online Help" I got a reportserver and a separated reportdesigner for development. I got no error in deployment, its because the dll or assembly is alr...more >>

Hi, I am trying to implement dynamic sorting using Reporting Services. I have 3 dropdowns on a page which contain the list of fields returned by a stored procedure. What I am doing is creating the <Sorting> tag and its children dynamically based on the sort the user selected. Then I am loa...more >>

Here is a consolidated list of features that would make this a GREAT product: Top most requirement: Webforms for Parameter Menu - Ability to Specify the location of a parameter box on the menu bar - Explicitly define which parameters depend on which parameters. - Listbox / ComboBo...more >>

Can I set a URL in such a way that as soon as a report opens; it takes us to a specified aspx page first? ...more >>

I have a Pie Chart that currently diplays the numeric value for each slice of the pie. The visual however it not a concrete percentage of what is happening. I cannot find a way to have the graph display the percent value used to generate the individual slices of the pie (as you would with Ex...more >>

I already installed reporting services, but I didn't see report designer anywhere. is it a separate installation? where can I download it? ...more >>

Here's how my report is laid out, basically I have a header which I repeat on every page. In the body I have a table that repeats data (3 rows worth of data per page), the problem I'm having is in some cases, the header gets printed out on the last page even though there is no data for the tab...more >>

i recently read an article on how you could do reports on your exchange environment with the SQL 2000 report pack for Exchange. http://www.microsoft.com/downloads/details.aspx?FamilyId=108C2B01-2CC9-4A84-A669-EB22533FA5E2&displaylang=en I have installed this on my SQL box and am unable to acc...more >>

Generally, when I type http://MyServer/Reports in the location, it takes me to the home page. On that page I see a bar with "New Folder", "New Data Souce", "Upload File" and "Show Details" options. Below that I see "Sales Reports" and "SampleReports" folders. Clicking those links it takes us t...more >>

I have few reports which i need to distribute to a lot of clients and I have following requirements on the clients: - preview reports - print reports - count the number of printed pages (if the report is printed), this is absolutely necessary functionality because clients are charged by the ...more >>

HI, I am working with a developer who has an interesting problem. They have data field in a sql table that is of a numeric value a second field that tells whether or not the previous value is a debit or credit for a general ledger. They want to show on a report a sum of the numeric fi...more >>

Is it possible to use an expression for the width of a column? thanks, rob ...more >>

Hello, I use the RS to charting some blood tests results (i work in an hospital). These results have: Date:DateTime Results:Int At a specific Date one blood test has not a result (in database is NULL). The problem is that in line chart this appear as 0 values (this is very bad for our pati...more >>

I have a parameter called IndustryType - the available values are returned from a stored procedure whose return set is like the following: 2 Columns (IndustryType, DefualtValue) IndustryType = (ItemA, ItemB, ItemC) DefaultValue = (0,0,1) "ItemC" would ideally be my default selection when...more >>

I'm trying to incorporate the /ReportServer virtual into our application web site so we can point the Report Viewer control to /ReportServer rather than <default web site's IP>/ReportServer. I'm trying to remove authentication from <app>/ReportServer, but I've been unable to keep it from popping...more >>

I have a dataset that calls a stored procedure. it's command type is set to stored procedure. The stored procedure returns 1 result set from a temp table (like select * from #temp). In sql query analyzer it only returns 1 grid so I know it's not returning multiple result sets. when I h...more >>

I was cutting and pasting rows of the detail section of my report to re-order them. Seems reporting services removed the Iif clause in the Visibility.Hidden property for every row i cut and pasted. I was inside the same report, just trying to re-order the rows in the detail section. I dou...more >>

Hi everyone! I am developing a Work Order report similar to the "Adventure Works Cycles" sample provided with Reporting Services. What I would like to do is repeat the "Header" information on each page. I am looking at the samples for an example on how to do this but no luck. I even reduced...more >>

I have found that if you put in an explicit Page Break in a report then the Export to Excel makes a new tab for each page break. This is great. Now I'd like to put a value on the Tabs. For instance, if I was writing a report that breaks on Branch Code and creates a new page based on the b...more >>

I am having problems with Background colors when exporting to Excel. My "LightGreen" colors are coming out as a Gray color in Excel. Is there a list of colors that is supported by both?...more >>

Are Reporting Services Report Items self aware? I want to do some conditional formatting on the Background Color property of an aggregate field. This works: =iif(Fields!HardwareCost.Value+ Fields!ContractorCost.Value+ Fields!SoftwareLicenseCost.Value = 0, Nothing, "LightGreen") What ...more >>

I don't want to send parameters in my URL. I want to be able to read a Session variable inside my report. I had hoped to use the "Embedded Code" area for this. Basically I want to embed the following. EmployeeID = Session("EmployeeID") How can this be done?...more >>

I have seen other posts on this problem, but have not seen any solutions (maybe I missed it) - the problem is I have a report with the page setup to be 11 wide and 8.5 height - when I go to print I set up in the printer dialouge to print lanscape (seems unneccessary since I have already set th...more >>

Hello, Right know we have a small access application that we use to print all of our comercial invoices, it uses a simple access report that we open and print all the invoices together each getting printed in a different page. (around 200 each month) We are porting this application to as...more >>

I have a report which use a parameter on model number. We have some model numbers which end in a + sign eg TTI+ when i run the report and select TTI+ from the parameter drop down it gives me just the TTI models not TTI+ it seems to be ignoring the plus. When i try manually entering the par...more >>

I am having issues applying a filter to my report. I have one dataset that i want to filter and display serveral times in one report. The query is complicated and somewhat slow(yes i am working on optimizing it), so i want to pull it once, and then use it in 4 different tables in my report...more >>

Hi, In my group header I have a cell that I want to display "the group number". Ex. Group A - 1 XXXXXXXXXX Group B - 2 XXXXXXXXXX Group C - 3 XXXXXXXXXX etc. I can't find an easy way to calculate the groupnumber. I cannot use SUM disti...more >>

We are just now looking at implementing Reporting Services, and I would like to pose a few questions. 1. What are the issues (performance, etc)/dangers (security, etc) of installing Web Services on a SQL Server? 2. What, if anything, can be done to minimize these issues? 3. I would like to ge...more >>

I see by reading the operating system requirements for MSRS, you need at least Windows 2000 Server. Techinically and functionally, can NT host MSRS? Is Windows NT omitted from the list since it is no longer supported by MS? We plan to migrate our installed customer base to Win2003 Server, but ...more >>

Hi all, I am facing problems while exporting a report to Excel format I am using Excel 2000 bundled with MS Office 2000 and RS Evaluation version Do I need to do any configurations, Is any one facing the same issue or a problem with my installation Can anyone help regarding this... Regar...more >>

After struggling for days with a chart rendering problem, it looks like it might be solved if I switch the UseSessionCookies key to false in the ConfigurationInfo table. But ... 1. Are there any issues with doing that? 2. Where do I find it? 3. How do I do it? -- Thanks, CGW...more >>

I have a report parameter ”spare part number” that’s configured like this: Data type: string, non-queried (empty list), no default value. This field is rendered as a text box in preview. I also have other parameters but these are all based on queries and datasets and are therefore render...more >>

I'm attempting to take snapshots. I have the reporting services datasource set up as SQL Server login, stored creditials and all parameters have a default. The snap shot runs when the query is small but when using a large query I get a login window pop up. If I type in my (Windows) login ...more >>

I have a report which shows statistics for a user-defined year (using a parameter). I want to give the user the option of choosing another year (another parameter) which will show a side-by-side comparison. However, I also want the user to be able to leave the 2nd parameter empty to get no p...more >>

I am linking to MS Analysis Services datasrce. When reporting I would like to have the column to be displayed be determined by a parameter. ie. Parameter pFaccode = 'ABC' report layout using a table: Facility 'ABC' Case Count Male 100 ...more >>

Can I use a Web Service Method as a Data Source in Report Creation. Any help will be greatly appreciated. Vishwanathan Raman ...more >>

I have a table with orders. The user wants to view data for several orders at the same time by entereing the all the ordernumbers comma separated. (Have in addition other parameters to be selected from dropdowns...) Is this possible? How? JK411...more >>