Hi, While using Reporting services, I have come across the following situation where the grouping cirteria for the report is defined by the user using ASPX page. My problem is, I am not sure how I can send the the grouping preferences to the Reporting service(I can't send this data as a ...more >>

Hi all, Do I need to define the Data Processing Extension (DPE) DLL's in the Designer policy file: rspreviewpolicy.config ? It's been my experience that the Report Preview mode runs in some "special" mode that seems to bypass CAS (Code Access Security) - this makes me wonder then if I n...more >>

Is this possible? We need to set the from address differently for groups of people so if the email bounces the right person sees it. Any help would be greatly appreciated! ...more >>

I am recieving this error anytime I access the Reporting Services WebService. Has anyone else ran into this? "Only one WebServiceBinding attribute may be specified on type 'ReportServicesManager.RS.ReportingService'. Parameter name: type" at System.Web.Services.WebServiceBindingReflector.Ge...more >>

We have the MS CRM installed on the same machine as our Report Server. Sometimes (infrequently) when accessing the report manager (http://ComputerName/reports) we are presented with the following error message. Any Ideas on how to solve it? Server Error in '/Reports' Application ---------...more >>

MS team please help! I am running SRS SP1 (Version 8.00.878.00). I have a report with this parameter in the Report Designer: Name: DBName Prompt: (blank) Data Type: String Allow Null Value: True Allow blank Value: True Available Values: Non-Queried (none) Defa...more >>

I have two issues: Issue#1 1. Using ReportViewer set to PDF format 2. Once the User Clicks a Button the code behind sets the path to the report in the report viewer 3. this opens a prompt on the client machine to Open or Save the PDF 4. once the User then Clicks Open as the PDF is opening ...more >>

I have a Matrix Report with 2 RowGroups (Product & SubProduct) and 3 Column Groups. The layout of the Report is below: +Product SubProduct Revenue XX XX Currently, when the Report renders Subproduct is hidden and when user clicks the toggle button next to the Product, ...more >>

doesnt work. This i a testquestion to look att the behaviour: CREATE PROCEDURE sp_testingReportsDeleteThis (@arg1 varchar(100)) AS declare @sqlString varchar(800) set @sqlString = "select firstname from tbl_personalData where firstname like '" +@arg1 +"'" execute (@sqlString ) GO ...more >>

I am findng that when I add a document map and then later remove it that it is still appearing in my reports.......more >>

I find that if I use a bunch of textboxes in a 'tabular' layout in the page header (or anywhere) things dont line up quite right. I need a table in info in the page header (not from a dataset just static text and param labels) so I figure I'll use a table in the Page Header but it tells me tha...more >>

Hi All, Forgive me if this was answered before. I have installed the printer delivery sample, and all seems okay. I can see the option wehn I create a Data Driven Subscription, but not when I try to create a regular subscription. Have I done somthing wrong, or is this how it should w...more >>

Hi there, I am making a report to show every system's usage/outage statistics for every channel in that system, every system has same design layout but different channel numbers, system number is also unknown. 1) How can I design one layout for one system and repeated for others? 2) How to us...more >>

Group, Does anyone know how to set the height of the Page Header dynamically, it's not letting me set the Height property of the Page Header to an Expression [something like = IIf(Globals!PageNumber = 1, 1.5in, 1in)? Or is there any other way to achieve the following: I want a certain page he...more >>

When I try to export very large amounts of data from a report published from one of my servers to excel, I get a dialogue box that pops up and asks for a user name and password. however, should i use the same report and ask for smaller amounts of data to be exported, it does not. I do no...more >>

I am using RS web services to render a report within my application. The values associated with the parameters are not being returned by the GetReportParameters member. Report parameters values are query based and work without issue in my development environment and when deployed out on the ...more >>

Installing Reporting Services with IIS and Report Services running on one machine and Reporting databases on remote SQL Server. Getting the error below when attempting to view http://servername/reports page. Any ideas? Thanks. Frank Server Error in '/Reports' Application ---------------...more >>

Seem to not be able to get set up right. Have split-brain dns (Server2003 with AD) natted at the firewall with 5 domains - one internal only and dynamic; all others static for basically websites and email pointers. Websites, email, sql, asp pages are working fine - EXCEPT REPORTING SERVICES...more >>

Hi all, Is there anyone know how to access subReport's item? For example, can i use: Reports!subReport.controls.textbox1.value in main report to access subreport's textbox value? I have tried that, but failed. :-( Thanks, Lisa...more >>

Maybe my question is stupid, but I still post it here. Hope somebody can give me an answer. MS released Service Pack 1 for Reporting services. Should I only install the SP 1 into the server machine, or should I ask each user install the SP 1 in his/her computer to run reports? Thanks!...more >>

I am allowing users to specify through a parameter whether they want a column to be visible or not. If they specify visible = false, the column does not show on the report. However, when that same report is exported, the column is visible in the export. Does anyone have a solution for this?...more >>

I want to suppress printing of a couple of columns on my report and have positioned a textbox in the upper right hand corner that says "Printable Format" and have the columns to be hidden, listing it as the toggle item. But since I don't want "Printable Format" to print either, I've set the te...more >>

Does anyone have a good feel for a typical engagement involving the installation of RS and the authoring of 8 to 12 reports that will get their data from flat files? Is this a 3 to 4 week engagement for an RS consultant? -- SharePoint Specialist...more >>

I am testing a new install of Reporting Services with Mom 2005. Every report that I try to view that contains a graph simply displays an empty box with a red X in the upper left. Is there some component that I am possibly missing that contains the graph object? Any help is appreciated! -...more >>

I am trying to find out the MS reccomended way of installing RS onto an Active Passive SQL Server with IIS installed on the cluster as well. After speaking with the powers that be, I need to make RS work in the cluster since they will not buy additional SQL licenses to be put on the web servers. A...more >>

Using Parameters, I'm allowing users to supress lines out of a line chart. However, the item still appears in the legend. When I use the same formula in the series lable property to supress the label, I get "Series " and then the series number. Is there any way to supress the label for that se...more >>

I need to change the color property of the values in subtotals (row or column)of a Matrix. I need to change it in a variable way. I tryied this but it does not work: = iif(Me.Value < 100, "Red", "Black") May you please help me ? Thank you....more >>

Hello, One of my group field is a date, and I need to return day name, like Monday, Tuesday, .. how can I do this? Thanks, ...more >>

Hi, I have a report with reference on ReportLibrary assembly. In the Code section of the report there is the following code: Public m_myClass As ReportLibrary.DatabaseInteraction Protected Overrides Sub OnInit() m_myClass = ReportLibrary.DatabaseInteraction.GetInstance() End Sub ...more >>

Hello, I have a user (myUser), I used it in my SqlConnection and in IIS side: enable anonymous access checked and myUser is given as username and password. Integrated Windows Authentication is also checked. I was thinking this way I do not have to deal with each user in our network. Now wh...more >>

Is it possible to create a custom extension (DLL) that will push multiple tables (or datasetes) into SQL report? If not what is a way to push multiple datasets into report? Thanks ...more >>

Hi , I having a lengthy report which brings around 500 rows of data.. I am having a graph at the bottom of the table representing all the 500 rows of data. Since the data is large it lost its readability. Is there any way to have a graph for each of 100 rows ??????? Any help or suggestion w...more >>

I have a pb when trying to render a report with OWC. the render step precess well but when i use Response.BinaryWrite(result); to show the report to client a get an error. here is code of my pgr : result = rs.Render(Report, format, historyID, deviceInfo, paramVal, credentials, show...more >>

Is it possible to have 2 or more tables from different databases in the same dataset? This would make things a lot easier, instead of building tables from different datasources and putting them in a single repository database. Thanks ...more >>