All, WHile I am able to query the dataset I want, and able do query it. However, I did so using #temp tables to achieve my desired result, and encounter errors when attempting to add this dataset in Report Designer in VS2005 (Microsoft Report Designer: Could not generate a list of field...more >>

Hi The reporting services is generating large log files of 9GB daily and using all the virtual memory that all applications on my win2003 server stop running. Application is running on sql server 2000 and Microsoft Report Server SP1. How do I go about trouble-shooting this? -- Regar...more >>

SSRS 2005 I have figured out how to use a custom code assembly to dynamically control the content of the textboxes in the footer of my report. For example, I have an expression like this in one of the textboxes: =Code.OakRptLib.BuildPageFooterLeft() This approach assumes that the textbox...more >>

My SQL server logs this in Application log: Error: 7105, Severity: 22, State: 6 Page (1:952446), slot 39 for text, ntext, or image node does not exist. MS KB890755 http://support.microsoft.com/kb/890755 asked to contact MPSS for a hot fix for this problem. I believe this call is free bec...more >>

I have a function in the Report Code of one of my reports and an expression that references it. Here is the expression that is in the details row: =Iif(Code.Check(Fields!fullname.Value), 0, Code.AddClient(Fields!fullname.Value)) The Check function basically looks in an array to see if the ...more >>

Hello, Is this a true statement: "The only Data Sources available to a Report Model are SQL Server 2000, SQL Server 2005, and SQL Server Analysis Services 2005"? I had read somewhere that there was going to be an ability to specify a "custom" query processors so that you could use data so...more >>

Hi, I have a main report with multiple subreports. I need to insert a new subreport between two existing subreports. When I run the main report, a pre-existing subreport is now jumping and printing out of sequence. Any idea how I can fix this problem? Does anybody know why the sequence...more >>

I want to setup a subscription for a report to be copied out to a sharepoint site. Is this possible? If so, then how do I do it?...more >>

I have a report that when exported to Excel creates multiple sheets. Im doing this on purpose. I wanted know if anyone new a way to automatically name the Sheets in the Excel export? I wanted to name them from a field on the report. ...more >>

Hi! Has anyone figured out what causes a "Execution '2ye0gq45qszd0m55wlgy0n55' cannot be found (rsExecutionNotFound) " error? Our scenario is this: A relatively new/unused sql server 2005 (so load is not a factor). A new report (the first one on this server) conisting of a main report and ...more >>

I have a query that I am using in my report as a text dataset (i dont want it in a stored proc yet) but my issues is that I have a variable defined that I want to become a parameter for the report. What happens is if I refer to the variable at all before the select statement its used in, it do...more >>

I think I'd like to use the IN operator in a filter expression in a SQL Reporting Services report and I cannot find documentation for the syntax or an example showing its use. The variations of delimiters I've tried have not worked. Is there documentation or an example out there showing use of...more >>

I am trying to filter a dataset that is displayed in a table. However when I use LIKE as the Operator I cant get it to work. What is the correct syntax for the VALUE column? I have tried (where Text is my sample string I am searching for): Text %Text% =Text ="Text" =%Text% ="%Text%"...more >>

Hello. I have a subreport in a cell and I can't specify the background color of the cell. I have a "dummy" dataset in the subreport to always return data so that it appears grey, but the problem lies in when there is a carriage return/line feed. The next row will be white with color only wh...more >>

Is it possible to set a printer to duplex within SQL Reporting Service 2000? I have several reports to print and need to switch back and forth between duplex (Front and Back) and one sided printing. TIA ...more >>

Under a table with headers, groups, details and footers .. say I want two sets of details that should not align with the headers. Or for example, say I have a subreport in a group that I would lke to span the entire width of the the table.. How do I do this? Thansk. ...more >>

Hi folks, I am describing the issue as below: 1. create a stored procedure as below .....where age in (@p_age) note: age is the table coumn of table table1 with datatype tinyint 2. ..... and create a second dataset for parameter @p_age select distinct age from table1 3. asso...more >>

Anyone know a way around this one? I needed to get XML data from a web service. The web service (which I can't change) outputs some of the elements as CDATA. Doesn't look like the XML data provider included in RS2005 can handle these. Thinking it might be a problem with the web service I c...more >>

Hi all, I'm quite new to SSRS. I have installed everything, and when I navigate to my local report manager web site, it all works, but I have javascript problems... When I navigate anywhere, The new page will render but I get a JS error: "Unterminated string constant". Once I click to ackn...more >>

A couple of days ago, I asked about changing the Reporting Services web page. I asked about changing the "SQL Server Reporting Services" text, and including a company logo where the folder icon now resides. I got a response that I could change the text by clicking the Site Settings in the uppe...more >>

I need to pass parameters dynamically at runtime to a report created using Report Builder in a Report Model Project (Reporting services in SQL Server 2005). Currently this is possible with a simple report server project and not with a report model project. Also the Data Source View of the repo...more >>

Hi, I was curious if any one could help me figure out a small problem I am having. I am attempting to create a Stacked Bar Chart in Reporting Services. My data set contains a lot of points. With many points, I notice that RS is automatically removing some of the labels on the X-Axis in ord...more >>

Hi! We have implemented a custom DataProcessingExtension for Reporting Services 2005. Now we want to implement a Report Model based on this DataProcessingExtension (for the usage in ReportBuilder). Can can I accomplish this, because as the documentation says you can only create a Report...more >>

Any ideas or known approaches on how to better develop reports. I have about 30 Crystal Reports based on stored procedures. Now I need to develop SSRS 2000 reports. What is the best way to achieve this in terms of layout development? Is there any kind of a style sheet or templates in SSRS...more >>

Hi all, Is there any way to have the report parameters appear in the subscription email, for both custom and default reports? Currently, the goal is to just get the team project name to appear along with the sent report. The other idea I can think of is to just put a field in the actual r...more >>

Hi, We are using forms authentication with reporting services and are trying to setup subscriptions for the reports. Currently, our subscriptions send out the email at the scheduled time with the report link in the body of the email and we receive it. But we never receive the report as an att...more >>

HI, I have a group on two fields (ie SalesPersonId and CustomerID). I want to print a total after any of this values change (ie. If CustomerId changes, a total line for the customerID will be printed but not for the SalesPersonId). How Can I do it with running values ? Best regards ...more >>

Hello. I have a query whice look like this: select a,b,c,d from table1; Now - when pressing a cell in the first column we are jumping to another report with the value as parameter (called- p_param);. In the other report the query is: select * from table1 where a=::p_param. What I want to do...more >>

Hello. I have a query whice look like this: select a,b,c,d from table1; Now - when pressing a cell in the first column we are jumping to another report with the value as parameter (called- p_param);. In the other report the query is: select * from table1 where a=::p_param. What I want to d...more >>

Hello, I have a matrix in my report (rs2005). I added a "subTotal" column to the matrix (by right clicking on a column and chose "subtotal" from the popup menu). Now i want the column to be colored in blue but i can't do it. I can only select the header color (where i'm writting "TOTAL") but ...more >>

Hi, I don't know if it is the right place to post this question, I am trying to populate IISLOG DB with IIS log file using the following expression (provided in the package DOC) LogParser "SELECT date, time, strcat(strcat(strcat(TO_STRING(TO_TIMESTAMP(date, time), 'hh'),':00-'), TO_STRING...more >>

I am wondering if it is possible to have 2 datasets in the rdl report that are linked together by some key. Or do I just have to combine the information in the two datasets using a query into one dataset. If at all possible i would like to use two datasets that are linked. ...more >>

I am in the initial stages of setting up a Reporting Services on a production envronment and I am not sure how to go about setting this up. I currently have 2 web servers and 2 sql servers. I also have an aditional server that could be used if needed. My initial thought was to instal sql and r...more >>

Is there a way for a project to take different reports [with different data sets and formatting] and include them on one report and dump them into Excel with in each their own tab?...more >>

I have a client who is running SQL 2005 but wants to run the SQL Reporting on the seperate server. Question I have is does that mean, the clients have to acquire additional set of SQL license? Thanks, -Paul Chung- Technical Consultant, SunGard Higher Ed. www.sungardhe.com ...more >>

In RS 2000 I was able to create a template report and put it in the Project Items directory, then when I would select New Report Item, I could choose my template report instead of redesigning everything from scratch. Where is this folder, or to better phrase this question: Where do I put my ...more >>

People are really very happy with the reports I'm creating using SQL 2005 Reporting Services. Great stuff! One question though. When users go to the Report Manager: http://MyServer/Reports/Pages/Report.aspx They see "SQL Server Reporting Services" at the top of the form. Is there any wa...more >>

I am attempting to install SQL2K Reporting Services on a WinXP box with Visual Studio 2K3 installed. SQL-RS install reports ASP.NET not registered with IIS. Have attempted running aspnet_regiis -i from the \Microsoft.Net\Framework\v1.1.4322 folder as recommended at http://msdn.microsoft.co...more >>

Why are there problems with using FireFox and IE 7 with accessing the Web interface for SQL 2005 Reports? I know that the Frame is the issue for FireFox (is there an easy way to fix this??) but I am running into problems where IE7 just crashes when it connects to SQL Server Reporting Services. ...more >>

Reporting Services Noob here. I have a simple grouping report that I'd like to add a second dataset to. The report looks like this: Id date date date Id date date date Id links to the new data source returning multiple rows. Th...more >>

Hello, Bruce L-C, are you there? Haha. Anyway, I have two datetime parameters in my server report. I've run into an issue if someone enters in a date that's out of SQL Server 2005's date range (less than 1/1/1753), i'm getting an ugly error that says the query execution failed on my data...more >>

How can I let all domain users run reports without adding them one by one into Report Manager? Thanks ...more >>

Hi all, I have SQL 2005 and WIndows 2003 Server, I am an adminsitrator and have installed SQL 2005 Reporting Services. However when I got to configure the reporting services the following happens When creating a new report server virtual directory on our server, (I am installing to the def...more >>

Hi Ya'll, I saw a MS demo of RS and decided to give it a try, do a little learning. Perhaps toss Crystal reports if RS is too cool to ignore. I have SQL 2K and had RS Installed but don't see the tools to begin design. Is that only in SQL2K5 ? Am I suppose to fork out the bucks for VB.n...more >>

Any way to load my new template, and then call wizard? seems wizard is not accessable if after I start with open existing item. Can anybody recommend and easy to follow book on on reporting services 2005? dumb question, say I have a grouping report like this group detail detail...more >>

I'm trying to use a local report in a Windows Forms application that uses an ado.net dataset. The trouble is that I'm trying to figure out how to access data within related tables. If the dataset has a table called Customers with two records in it, how do I go about displaying the data from ...more >>

I need to do an asp.net application that has reports and Forms Authentication (no windows authentication). I have absolutely NO need for centralized reports or load balancing. On my last project I used sql05 reports within asp.net vs05 on a win03/32bit server and used LOCAL reports. The...more >>

In my report, one column is a calculated column based on two others ColumnA - Quantity ColumnB - Cost Then, Column C multiplies Column A * Column B =Fields!Quantity.Value*Fields!Cost.VALUE That part works just fine But - I need to (not in Footer), create a cell, that sums up all the valu...more >>

In SQL, this works beautifully: SELECT 'All' AS RootName, ' All' AS SortValue UNION SELECT DISTINCT RootName, RootName AS SortValue FROM dbo.APP_OnlineReportingRoots ORDER BY SortValue It adds the word "All" to both the RootName ans SortValue columns of the results which I then use for ...more >>

SSRS 2005 I would like to be able to write a function which takes a reference to the Parameters collection in the report and then iterates through the collection to dynamically build a string which outputs the prompts and values for all of the visible report parameters. The only problem ...more >>