Hi, I have a report that use fixedheader in some of its tablecolumn. The reports also using drill through. In report designer, the fixedheader works fine. Also when I'm jump to another report (the drill through), there is a "back to parent report" button in the new report shown. The problem ...more >>

I'm using WinForms ReportViewer in local mode. Some textboxes in my report display #Error How to get exact error message for this error or any other information about error in expression ? Andrus. ...more >>

I have Report A and report B. Report A has under "navigation->Jump To Report", report B selected from the list. I also used the parameters button to insert both parameters required by Report B. Deploy both reports. On the catalog (server/reports/<folder>/A), I run the report A and can dri...more >>

Hello I have a field in my dataset which could hold the path of a file sometimes or would have some plain text. Before I give set that field in the "Jump to URL", I want to check to see if it's a file and if so, then assign that field for "Jump to URL" or leave it blank. Is there any funct...more >>

Hi; is there a function to add quotes to a string sentence?; like this exec('Select * from Customers where Name='+@NAMEC+' and AGECUST > 25') if @NAME is only William, i need to add quotes to it to get a sentence like: Select * from Customers where Name='William' and AGECUST > 25 is t...more >>

Does anyone know if a change is made to a model, will reports created based on it be affected? Or, once created, are these reports independent? Thanks...more >>

Hi, I have a parameter whice get his values from query. The parameter is check as "multi value". I want the default value for the parameter to be "select all". How can I do it? Thanks. ...more >>

Hi, When creating a report model, is it possible to configure a field so that a user must apply a filter when they create reports in Report Builder? In my case, I have a simple report model that contains summarized data grouped by date and then by hour. Due to the amount of data in the und...more >>

Hi, I have a report with text in the footer. When I exported it to excel, every thing except from the footer is exported (the report body and header are OK). I'm not getting any error but the text in the footer just doesn't appear. Any solution? Thanks. ...more >>

I have noticed that the directory path to the "executables" for reporting services is different on different computers. on one computer it is C:\program files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin and on another it is C:\program files\Microsoft SQL Server\MSSQL.2\R...more >>

We open reports in new window from an asp.net page..using rs.render method. Recently we have new reports with graphs...when clicked on detail for graph I have to open another report detail in a new window. I have created a link(naviagtion URL property for textbox ) in the main graph report to o...more >>

I have a report that will not run in "preview" mode in VS 2005. Whereas the deployed report runs correctly and shows results in about 15 seconds, the same report (downloaded from the report server) tries to run in preview for about 60 seconds and then displays "The given key was not present ...more >>

I am using SQGExpress, and can open the home page at http://localhost/reports, but after previewing a report, when I try to deploy the report I get a dialog asking for for a user name and password. 1. why do i get this dialog, and 2, what is it expecting; I have tried all that I could think...more >>

When I export my report to Excel, the dates in the report are formatted as text and need further work before they can be manipulated as dates by formulae. Is there a method to export the dates so that they arrive in my Excel worksheet as date formatted cells? Thanks for any help....more >>

Can I set the default style of my report like we do thecss in web development I don't want to edit the style of the report manager .What I want is to edit the report style. [mean the rendering style of the actual report] Suppose I have to set borderwidth of table =.25pt bordercolor of tabl...more >>

We are experiencing an issue that leaves us confused. We have a variety of reports that are run by a variety of people and for the most part, they run without any trouble. Every now and then we’ll get a report that we expect to complete within a matter of seconds (let’s say up to 20 seco...more >>

I am inserting page break after a table to put different data on different sheet.How can i name the resultant work sheet {like table1 should be DATA,table2 should be MYSummary}...more >>

We have an application that uses HSQL for its engine (http://sourceforge.net/projects/hsqldb/) which supports JDBC. Is there a way to access this from SQL Reporting Services?...more >>

Specifics: First machine: SharePoint single server Farm Second machine: SQL 2005 with Report Services Installed SP2 and RS Add-in, added SQL pc to farm, and followed steps to set up integration, including changing SQL service accounts to domain accounts. Everything went smoothly until we cl...more >>

Dear all I use a querried parameter in a SSRS report. This works fine. I now have difficulties to decide if I should eather use the dimension.all member or the ssrs (select all) member. What I do not like is to use both, because I think this confuses the user. Is there a way to hide the ...more >>

Hi I am a teenager who is very interested in IT as a career. I think I have exhausted the extent to which I can take my Excel and Access Skills. I have been looking into SQL and it looks like the wave of the future. I would like to be on this wave. However SQL seems so huge I have no idea wher...more >>

Hi Guys I had been creating charts in excel 2003 but there are some memory issues like I cant exceed 1GB of memory in excel for charts. I need to create aabout 50 sheets in a single worksheet. Can I use business intelligence as an alternative to excel for creating multiple sheets ni a singl...more >>

We have reports that render as tifs. The reports are called in batch rendering any where from a few times to a few hundred times. The report was on server A and got its data from server A and server B. After repeated complaints and slowness, we moved the reports to server C. Server C is no...more >>

How do you change the Y axis? For instance, instead of 10, I may want it to show 10% Or instead of 1,000 I may want it to show $1000 (with dollar sign). Basically I'm just trying to learn how to manipulate it period. Thanks! ...more >>

Hi there, My problem is that I have a DateTo dataset that receives a DateFrom parameter. The default value of the DateFrom param is taken from a DateDefault parameter value. However, when I run the DateTo dataset, entering 27/03/2007, I get an arithmetic overflow conversion error. If I ...more >>

Hello, Is there a a way to catch general errors on ssrs and display a custom error page to the user? The goal is that if a user try to access a report when the ssrs is down, He won't see the RS general error but a custom notice from me. Thanks. ...more >>

Hi experts, I have an ASP.Net application by which we are calling our remote report server. Till then it is fine but when i am clicking on any report then a pop up window comes and it is asking for username and password to logon on report server. I want to remove this popup login screen, ...more >>

I want to use C# syntax in report expressions. I use WinForms ReportViewer in local mode. How to use C# instead of VB.NET syntax ? I'm thinking about the following approaches: 1. Create pre-processor which converts expressions in RDL file from C# to VB. NET 2. Replace all expressions w...more >>

Hi, our programmer give me periodical a lot of .rdl and other bynaries files, used for render reports, I must deploy all the files on several server, how can I automate the deployment? at the moment I need to upload all single files on every machine ! THANKS for every feedback ...more >>

I am developing some reports and the only way I can deploy the reports to the production server is via files on a CD. The project manager would like to encapsulate everything into an .MSI file for deployment. Is there any documentation on whether this can be done? or how to go about depl...more >>

Hello: I have a report with multiple tables, one table per page. On the page header I need to show some information that is coming from a dataset, several records like first name, last name, file#, etc.. I've a single dataset in my report, which has the data for all the tables, and it in...more >>

Hi I'm new to the Reporting Services and need help. I'm trying to display a report created in the RS 2005 in the windows application created in VS 2005 using a report viewer control. The report viewer is imbedded in a form. After the form loads, user is prompted for a parameter. After it'...more >>

I think, first I better explain the characteristic of the report: • It’s a report of categories and their items(or products) • the report has a lot of information • At first only appears the list of all categories(which fulfill all the requirements) + Category Nº1 + Category Nº2 When I c...more >>

I have a multi-select drop-down list in report parameter. The list will contain... -All- A B C where value in -All- is -1 and values for A may be 1000, B for 1001, etc. When user selects -All-, I would like to iterate through all items and pass that into stored proc. I tried Paramet...more >>

Hello all, Microsoft provides a report pack of RS reports to use with Integration Services standard logging. The link is here http://www.microsoft.com/downloads/details.aspx?FamilyID=526e1fce-7ad5-4a54-b62c-13ffcd114a73&DisplayLang=en#QuickInfoContainer I have been trying to use thes...more >>

When deploying report project, it ask for report server URL. I submitted http://localhost/Reportserver in TargetURL box. And deployed again, then also it is throwing error. Please Help me. TIA Puneet ...more >>

Is there a way to force no page break when I see the report in HTML? I'm using RS2000 thanks, Pedro Geraldes ...more >>

Hello all.. I've put this question out before, but I still haven't figured out a solution.. When I apply this filter at the dataset or table level to get rid of commission code 100 it blanks out the report Expression: =Cstr(Fields!CommissionCode.Value) Operator: = Value: '100' I di...more >>

Ok, We have setup SQL2005 reporting services with MOSS integration. I have created a datasource that points at our Project server 2003 SQL database so that we can start to create project server reports. The data source works just fine BUT its *doesnt* pick up any relationships between tables fr...more >>

Hi; im still dont understand why this kind of things continue to happend to me, what im doing wrong?... This code works great on the data section, but on preview, i got errors that ask me to declare MESF and DATO variables, but those are the report's parameters!!! Any ideas? declare ...more >>

I have SQLRS running under MOSS (ie in a report library). Have created a datasource and use report builder the build a report. When I *start* a *new* report I see all the entitities (tables) in the database on the left hand side.......I can drag and drop tables/ columns to the report BUT once I ...more >>

Hi, while using a matrix to present data out of a cube we sum up single values. The sum's average should be calculated of each group ( =AVG(SUM(field.value)) ) which is forbidden because of the fact that we are trying to calculate with an aggregate. Unfortunately the kind of columns isn't...more >>

Hi, while using a matrix to present data out of a cube we have got a number of columns which is not known in forehand. We found the rownumbers()-Function and looking for something similar concerning columns... Has somebody got an idea how to solve this issue? Thanks in forehand, Sebast...more >>

Hi... is there a way to create a textbox on detail with a percent of a group total? TIA ...more >>

I'm using a report parameter as content inside an textbox and I'm exporting this report to PDF format from an ASP .NET application. The RS server has a lot of clients and sometimes the rendering engine seems to be using a wrong parameter value (I think from another session). Somebody faced thi...more >>

Hi; im having problems debuging a particulary complex procedure on my data tab, is there a way to debug it?, check variables values, define some break points, etc. TIA ...more >>

Hi, Is there anyway to create some optional parameters? What I mean is if I have a report that I want the user to be able to select EmployeeID or Department If EmployeeID is selected, hide all the parameters that are related to Deparement. If Deparetment is selected, hide all the param...more >>

I have two tables, I need a toggle item in table a to control the visibilty of an item in table B. I have been trying to figure this one out with no success. If anyone has done this please share the secret. Thank You, Nick Byers...more >>

Hello Experts, How to insert/include/import guage charts into sql reporting? I didn't find any guage chart type in chart control. Thanks & Regards, Sriman....more >>

Hi, My reportserver is http://acreports/reportserver and it works fine. But when I try http://acreports/reports, I get error "service unavailable...." acreports has its own ip and it is not in the default web site. it is the same level as the default web site. I am using server 2003 and s...more >>

I am using a table and at the grouping level, I am dividing the sum of one field (oputut format 1 decimal position) by the sum of another field (output format 1 decimal position). The output appears as follows .6 / 1.4 . If you do the math on a calculator, the result wound be arounded .43. ...more >>

Hi all, SSRS 2005 I have a Time Range parameter that has values 1 - This Week 2 - This Month 3 - This Quarter 4 - This Year 5 - Previous Week 6 - Previous Month 7 - Previous Quarter 8 - Previoous Year I have 2 other parameters (Start and End Date) that are dependant upon what they...more >>

Good morning all: I am having an issue when jumping from one report to the next. The issue is that the users want the reports to run without having to enter any additional information but may want to change some of the parameters after the report has run. I have accomplished the first part...more >>

I am looking for a way to group on a row. I am not sure that this can be done, but here is what I have. My dataset looks like the following: JobNumber Invoice Code Property PropertyValue Cost 071201 61556 Area 101 10.00 071201 ...more >>

Here's Hoping I have "eventually" managed to schedule reports and would like them to be emailed. The problem is, on the delivery method drop down box on the subscription page, there is not an option to select by email, how does one turn this option? I am running a "Demo" laptop that has ...more >>

Hi, I try to setup a server to test the integration of RS with sharepoint 2007. The SP2 is installed on the server and the Sharepoint addin installed too. I have created a RS instance and setup this instance to support sharepoint. but in the application management pages of sharepoint I don...more >>

This is weird: The Jump to URL option works for an external address but not internal ones. This configuration has now occured after we installed SQL Server SP2 and run the SharePoint intergration utility. If no links owkred that would be one thing but in this case some work and others do...more >>

Hi all! I try to make a report with a that is releated to another parameter. Eg: Parents Parameters - Month1 - Month2 - Year Children Parameters - USD_RATE - EUR_RATE This query is supposed to fill my @USD_RATE and @EUR_RATE: SELECT AVG(USD) AS R_USD, AVG(EUR) AS R_EUR FROM ...more >>

Hi at all, I have custom code written the to show a message Box. It was working fine in DotNet2005 Development enviroment preview tab. But it is't working when i deploy this report to the web. Please use a reference to System.Windows.Forms, Version=2.0.0.0 Public Function Test() As String...more >>

I just finished to install Sql server 2005 with Reporting Services but when I try to open http://localhost/Reports/Pages/Folder.aspx I get the following error: The underlying connection was closed: An unexpected error occurred on a receive. System.Net.WebException: The underlying connection...more >>

Hi In Reporting Services 2005, I am getting an error in the Print Layout view of my report. It renders fine in the Preview screen of the VS Development IDE, but when I click print Layout I get the following error messages: An error occurred during local report processing. An error occurred ...more >>

I have a requirements for a user to be able to run reports individually, or specify a list of reports to be run in turn for each of the exam centres in their area, creating one overall PDF for each exam centre. I can set up a report which has each required report as a sub report and wire u...more >>

Hi; is there a way to interact with every detail row that is about to print?; for acumulating values or perform special validations TIA ...more >>

Hi: We use SRS to pre-fill Federally Approved forms for student loans. We scan the form and use it as a background image and drop fields on top it. It works really well, until the government updated the forms... The new form has a table that has only ten loans, but there is an addendum ...more >>

I have RS 2005 running on a 2003 server. This report access an Access database located on a network fileshare, which is a different server than where RS is running. Using Windows Integrated Security, the report runs fine on the RS server (logged in as myself), but will not run when I try t...more >>

Hello, We are upgrading from SQL Server 2000 to 2005. We are doing fresh installation of SQL Server 2005 on the datbase server. Later, we'll do an in-place upgrade of SSRS from 2000 to 2005. For a while, we'll be running SSRS 2000 on a SQL Server 2005 reporting services database. My que...more >>

I have generated a model from a data source that is using an Analysis Services Cube as the initial catalog. I would like to create a report in Visual Studio, I add a Shared Data Source, Name the datasource, in the Type field I select Report Server Model. What is the connection string that ...more >>

Hello Everyone, I am having a heck of a time with this report. I have five datasets, all interacting with stored procedures in SQL Server 2005, all using the same parameter. The datasets run fine individually. I can run the report fine. When I try to build or deploy the report, I get this: ...more >>

Just thinking of ways to reduce server footprint in our Data Center. Is this possible? Thanks -- Jeff Bennett SQL DBA St. Louis, MO...more >>

We're running SSRS 2005 SP1 and have a report with a table that has different subreports in the detail rows. We see unexpected page breaks when a subreport can't fit on the remaining space of a page. For example one subreport takes 80% of the page, if the next subreport can't fit into the remai...more >>

Hi; im still VERY NEW with RS, is there a way to avoid the use of IE to view the reports?; right now we are using our VFP app to execute the reports using a URL. But we would like to avoid the use of IE and the parameters screen. We want to sent the parameters to the reports from our app a...more >>

Hi I am sure someone here has encountered this problem. I have a table which is linked to a stored procedure. When I try to use the filter under table properties, it doesn't get applied properly. Here for example Expression =Fields!CommissionCode.Value Operator = Value 501 This...more >>

Report X passes all it's parameters to Report Y via a "jump to report". Report Y then populates a select box based on the parameters passed to it. The user selects one of these values and clicks "View Report". This works perfectly in the development environment. But when I deploy it to the...more >>

I have a report where I have formated the numbers with #.#. When I run this repot this works well and give me the decimal only when it is needed. However, when I export to excel, I get te decimal point even when it is not needed. For example the when I have the whole number 100 it displays ...more >>

When I export a matrix report to Excel (65 rows by 228 columns, about 15000 cells) the file size exceeds 15mb. As the Excel file is sent out daily as an e-mail attachment in an SRSS subscription I receive a lot of complaints about this. Other export formats for the same report such as Web...more >>

I need to send subscription reports through a remote SMTP server that requires basic authentication and will not allow relay via no authentication. I see no way to send username/password to the remote SMTP server. Any help would be greatly appreciated. Thanks...more >>

I have installed Reporting Services on a production server that host a website using SQL Express. I have set up RS in the RS configuration manager and got green button all the way down Requesting http://www.xx.dk/reports replies: The request failed with HTTP status 400: Bad Request. ...more >>

In a table I put numeral-IDs in a Detail-Column During rendering these are replaced via user-code with the actual localized text. Detail: =code.CatTxt(Fields!CatID.Value) Example for replacing IDs with Text: CatID English German 1 --> Analgesics Analgetika 2 --> Sedatives Sedativa 3 -...more >>

Hi When creating a best practice enterprise reporting solution, would you normally create report models first, use these as datasources in Report Designer, andd create datasets on top of these? Or would you create datasets using SQL queries directly from Report Designer? What is the prefer...more >>