I am trying to generate a fixed-length format text file from a parameterised SSRS report for my client and the only way that comnes close seems to be to save as CSV with a single column query. I have created a large, parameterised, UNIONed SQL statement to generate the lines with the correc...more >>

I have multiple (multilevel) groupings in my RDL (based on line level data from SQL server). While using the RowNumber("GrouName") I am getting strange results. For example If that grouping was made out of 3 individual lines from data set, then I am getting Row number as 3. What I want is ...more >>

Hi All, Basically I want to render the report in HTML format, but needs to prevent the user to print. Thanks. Kavi...more >>

Is there a way to delete a dataset other than editing the XML (rdl)? If not, why not? Thanks, IanO ...more >>

Hi, Can anyone help me to create a report with all drill down features to be expanded at the time of display itself( without clicking the expand button) Thank you ...more >>

Hi, I have created a sample report called Report1 in SSRS 2005. This currently is running locally on my workstation. I can even browse to it using the http address i.e. http://localhost/Reports The question is: How can someone else access this report on my machine. They can not browse to my m...more >>

How to set week start number in RS. I would like to use WeekdayName and Weekday RS function but it returns wrong values (Tuesday instead of Monday) TIA, Kamel ...more >>

I am suddenly unable to access report manager : http://localhost/ReportManager/Pages/Folder.aspx I am getting the error : Could not find file "C:\WINDOWS\TEMP\_cm2qpki.dll". The name of the DLL is different each time I try, but the end result is the same. I can't find much on this. What I...more >>

Hi all How do I Delete Users Folders? I am a domain admin /system admin /system user and get an error message ever time I try to delete this folder. The permissions granted to user are insufficient for performing this operation. (rsAccessDenied) and the help file has none. I think this ...more >>

Hi, I'm looking for a way to display a boolean Value as a check box in a table. The box should be checked if the value is true. I've found a way using Windings as a Font, but is there another way? Can I display different Bitmaps depending on th value? Thanks in advance! -- Manuel Wen...more >>

Hi! I have two groupings placed in on list object and I'm trying to grouping data to be displayed on every page but without luck. The grouping data is displayed correctly at the beginning of the group but since it might be a long list of items in one group I would like to display the group head...more >>

Hi all, I am attempting to create a report similar to the default Sales Pipeline Report. When one of the bars in a bar chart is clicked, a list of the records that made up that total is displayed in a sub report. Any of the records in the list can be clicked open the selected record in CRM. ...more >>

I installed RS and IIS and then issued the following in the URL : http://localhost/Reportserver only to receive what I pasted below. Is that what I am suppose to see ? If not, whats missing ? localhost/ReportServer - / -----------------------------------------------------------------------...more >>

That's what appears at my client site. I have virtually the exact same configuration on a handful of servers using the SQL Reporting Services and the RDLC which is working great. Except this one server has: "An error has occurred when establishing a connection to the server. When connecting...more >>

Greetings! I have two scenarios going on. First (working as desired), I have a report that uses three groups and when exported to Excel, it creates a file with the plus/minus expandable groups to the left of the spreadsheet and displays all levels. Second (problematic), I have a report...more >>

Here is my question. Sorting and grouping question by allowing users to select the sorting field I have a report where I am giving the users a parameter so that they can select which field they would like to sort on.The report is also grouping by that field. I have a grupin...more >>

I installed SQL Reporting Services 2005 SP1 and eveything looks fine. I comleted the set up and when I go to http://Localhost\Report server I get the attached error message. I also tried to upgrade the SQL DB on the SQL reporting Database Serup and I received a warning message there that said...more >>

Hello, I'm trying to create a report on Microsoft CRM on the following tables dbo.FilteredAccount dbo.FilteredNew_internatsamenwerking dbo.FilteredNew_ImpExpCountry I have created a data source view in with the following relations : dbo.FilteredAccount 1 to many relation on dbo.Filtere...more >>

After a Report is rendered in a Winform with Report Viewer Control, when the users click the "Page Setup" button in the Control's toolstrip, what appears is "Paper Size: Letter." I tried to configure A4 the following ways, but couldn't achieve it to work for any printer driver - setting th...more >>

I am trying to hide columns on a report depending on specific parameters. Although the columns become invisible and the table resizes as per the data, the report width still remains the same. Hence, when the report is exported to pdf, although the data fits on one screen, it still prints one e...more >>

I have a client who already has SQL-2000 SP4 installed and now wishes to have reporting services installed. The installation indicates a pre-requisite of Visual Sudio .Net 2003. Further investigation on Microsoft web site reveals that VS would have to be version "Enterprise Developer" or "Ente...more >>

Hello, My doubt is how to change in a LocalReport environment the text color of a textbox of a report depending on certain condition at runtime. I will thank any help. Sincerely, Arturo Carrión at Tiempo Hard ...more >>

Hi, I am using MS SQL Server 2005 Reporting Services to develop the reports. = In my report I will be using 2 datasets say A and B.=20 Dataset A connects to the XML type Data Source Provider(i.e. querying = Web services through the XML data provider).So I am able to get the data = into the ...more >>

Hello: I need to show a page header that depends on a field from a dataset. My report has a list control and inside it I'm using a textbox and referencing it from the header using ="User Name:" + ReportItems!tbUserName.Value My problem is that inside the list I also have a sub-report wi...more >>

I have some questions about RBuilder that I need to address before my company can even think about switching from Cognos Impromptu to SS 2005 Reporting Services/Report Builder. How do I add page numbering? (i.e. Page & Page n of N) Does RB support persistent page, group, and report headers a...more >>

Is it true that we cannot create a template for a Report Server project? -- Harry Riddle...more >>

When I enter the following query in the MSSQL 2005 Server Management Studio, I get results, but when i enter the same query (Minus the top 2 lines) in RS, i get an a error: Title: Microsoft Visual Database Tools Error: The Parameter is incorrect. Any ideas what i'm doing wrong? This query...more >>

Hello, I'm designing a report which contains a sub report. The sub report show a list of data (firstname, lastname). I'm tyring to display data separated by columns. When you use the report Item "List" there is only the possibility to use a page break before or after. Is there a way to us...more >>

I have a lengthy report that can at times span 50-60 pages. One of the other dba's modified the report, now the results all show up on one verrrry long page. we have been tying for a few days to figure out how to get it to span multiple pages again, with no luck. Would someone please advise wh...more >>

Employee (Group H1) AVG( of all Ratings) Job # (Group H2) Rating Rating is a "Calculated" field in the Dataset. I put a filter on Job# (Group H2) to only include Ratings > 25% Results: Job#'s are filtered properly and every job < 25% does NOT show. HOWEVER, the...more >>

Coming from a Crystal background, I was assessing SSRS 2005 and ran into two things I know will generate a lot of pushback from my coworkers. In Crystal you can place group heading fields anywhere you want in a group band, where as grouping appears to be accomplished in SSRS by consuming an...more >>

Hi, What are the requirements for installing SQL 2005 Reporting Service? Can I install it in a windows 2000 server in NT4.0 Domain? I tried to install sql 2005 reporting service in a windows 2000 box, when I went into Configure Report Server, everything is fine except there is a red cross ...more >>

In SSRS 2000 SP2 the documentation for ReportingService.Render states that the ParametersUsed output parameter should only be populated only if the report being rendered is a report history snapshot. I'm invoking the Render method with a null HistoryId as follows, so I would expect the Parame...more >>

How can I set a default of A4 Page Size for my Reports? -- Rae G...more >>

How do you set up user as who can access what report in Report Manger. I do not see security tab in RS2005. ...more >>

I have reporting services installed on my xp laptop and haven't used it for a while. Now when I try to run a report I get the following error message. @AwaitingFirstExecution is not a parameter for procedure CreateSession Anybody seen this before? I can't find any information about this. T...more >>

I creted a web project with visual studio 2005 express but the report is blank. My report's source is on MySql; I connect runtime and send datatable to the report. this is the rdlc file; I canceled some rows [code] <?xml version="1.0" encoding="utf-8"?> <Report xmlns="http://schemas.micro...more >>

I'm using a 3rd part infragistics to store comments with formatting. Where reporting back something as simple as <STRONG><U>testing</U></STRONG> is not rendered. Does anyone know how to achieve this rendering within report pages? Thanks ...more >>

I have a textbox that reads " Money: " and then a cash amount..... I have formated the expression like this - ="Money: " & Format(Sum(Fields!Amount.Value),"C") but my question is how can i get the SUM to be a different color than what the word Money is. Currently money is defaulted to black...more >>

Is there a way to export a MS Rep Services report to PowerPoint? Thank you....more >>

I have removed the Document Map labels on my text boxes. When the report is rendered in RS, the document map pane is still displayed with only the name of the report in the pane. Question: how do I make this go away? ...more >>

I have a Reporting Services 2005 report that is emailed to users. I created/formatted the report based on how it looked in Outlook 2003 which all of our users had at that time. The report is wide, but just fit in the email window when it was full size. Now I have a user who has been con...more >>

Hi All, We are using 10 parameters in SRS report. When the report is executing, it prompts us to enter all 10 parameters. But we don't want to enter all parameters, we should be able to enter blank parameters without mandatory parameters. SRS prompts to enter all parameters. Kindly hel...more >>

Hi, I understand I can create a stored procedure to return all the parameters for data driven. The last statement of the Stored Procedure is Select * DataDrivenTableName. However, after I put Exec SPName, and when i go to the next page to fill out all the To, CC, Subject..., there is noth...more >>

I have a client that has a unique situation. Here is the back ground information: A Reporting Services 2005 server in a DMZ. This server is not part of any domain, only has local users. A SQL Server with the Report Database and an Analysis Services Server with the Cubes on which the repor...more >>

I can't find anything on passing multi-value parameters in the URL. I can pass one and it selects from the combobox, but when I pass more than one, it doesn't select any. I have a parameter named Locations that is multi-value. I have tried passing "&Locations=1,2". I have tried "&Locations...more >>

I have installed SQLServer 2005 Express with Adv services sp1 onto a windows 2003 platform. I have published some existing reports and when trying to run these from the Report Manager on the actual server, I get the following error: An error has occurred during report processing. Cannot create...more >>

Hello: I'm an SRS 2000 newbie. Two questions: 1. Is there a way in SRS 2000 to convert a GUID to a string or to pass a GUID as a parameter? 2. When a user clicks on a detailed line item, they are navigated to a new browser window with that detail field value as a parameter. This field m...more >>

Hello forum We are developing a WinForrms application that uses muti-layer technology in which the report viewer is a layer that includes a winform that belongs to a separate project within a single solution. This tier shows all the application reports using a single ReportViewer control in ...more >>

I just loaded Reporting Services for 2005 and when I go to http://localhost/reportserver I do not see the Report Manager like I did in Reporting Services 2000. I have deployed a test report to the server and it works, but when I go to the server I get a list view of the directory and don't ...more >>

Hi All , I installed SQL server 2005 Enterprise edition 64 bit on windows server 2003 enterprise edition 64 bit machine. I created a project and using a wizard created a report with Analysis services cube as a datasource.Preview works fine but when I try to fix the fonts or add elements and ...more >>

Hello. I'm developing reports in Reporting Services 2000 and Visual Studio 2003. I have a "drill-through" report. Upon drilling through to the report, and then clicking the back button to return to the main report, the report doesn't even render. However, while developing the report and ...more >>

Hi, I'm at my wit's end on this. I printed my reports from the development environment and all characters came out right. It's only when I printed my reports using the client-side printing after I deployed them to my web server that the strange characters come out. Instead of a smooth comma...more >>

Is it not possible to format text as bold and italic in SRS? I find this hard to believe, but whenener I specify both properties (FontWeight and FontStyle), the italic property overrides the bold property. Anyone else encountered this problem? Is there a work- around? ...more >>

I am getting the following error: The group expression for the list ‘Title’ refers to the field ‘Title. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope. When I reference the stored procedure ...more >>

Hi All, Im new to the Reporting Services. I have a report which will display all the department Report 1 : --------------- DeptID Department -------------------------------- 101 Software 102 Marketing Report 2 : -------------- EmpId Empname DeptID...more >>

Hello all, I have a particular problem with subscriptions when the subscription is created by a user who is not an administrator. The problem points to a permissions issue but I've tried several ways to resolve this without any luck. If the subscription is run only selecting a link to th...more >>