Hello again . This Is Saeed Tabrizi From Iran . I have Problem with Matrix , Is there any one to help me ? I want to show Sum of Matrix Columns in Each page Of Report (Matrix Page Summary Exactly). For Example : ----------------- Page Header ----------------------------- ...more >>

Is there any way in Reporting Service so that It will automatic refresh data in the report with specified time interval ? Thanks ...more >>

Im developing an asp.net 2.0 application which has SQL 2005 at the backend. I was intending to develop reports using Crystal but I thought I'd first take a look at Reporting services. I never used before so you'll have to bear with me. Im trying to work through a Books Online Tutorial. A...more >>

Hi - We recently upgraded from SQL Server 2000 to 2005. I made backup copies of my reports in SSRS 2000 format. I then opened the original reports in SSRS 2005 and they were then converted automatically. The reports run fine, but when I print them, they won't print. Instead I get several p...more >>

I have a report with multiple tables and datasets. The problem is if one of the tables/datasets doesn't have any data I get too much white space between the sections. I tried to set the visiblity property on the table but that doesn't work if there is no data being returned via the dataset. ...more >>

I have a very simple design that is causing a very large headache, and I was hoping you could point me in the right direction. All I need is for my report to have some information at the top, a list of 5 items, and then some information at the bottom. But there maybe more then 5 items, say 10...more >>

Hi All, I am new to SQL 2005 Reporting Services. I have done the reports and now I want to publish them to a folder in then local machine. I even tried that. I created a subscription and when it is to rum gives an error "Unable to write file <abc>, Report Server Configuration error, see log...more >>

Hi Experts, I got a report that takes in a parameter and run normally 20 min to produce the result. So I decide to take advantage of Execution Snapshot feature. I create a shared schedule and set my Execution Snapshot to execute every morning around 1 am with default parameter. The next day...more >>

I don't even _have_ VS 6.0 on a machine anywhere, so I can't muck around with it, so I'm hoping someone can supply sample code and/or links to examples or other info that can show how to execute a report from "Classic" ASP (not .NET). We have some legacy apps that aren't being migrated to .NE...more >>

Hi Experts, I am working on Reporting services 2005 and i am new for this software. I have some reports, and some reports contains more than one parameters. Now my problem starts.... My client want reports with more and more parameters, and at the same time he does not want to select all ...more >>

We are displaying reports in a PDF format through an aspx page. I have put and URL link in an report as follows to open a new window(cotaining another report) ="javascript:void(window.open('http://localhost/ReportViewer/ReportFrame.aspx?rptPath=REPORTPATH&args=" & REPORTARGS & "','Gra...more >>

Hi, I guess this is a simple question. When I'm using "jump to report" in report A, it will navigate to another report (report B). The problem is, in report manager, there is no "back to parent" button in the report B, so I can back to report A. Is there any solution to solve this? Thanks ...more >>

Hi; i dont know if this is possible; i have 3 reports and each report has 4 parameters (parameters names are the same between them). i want to integrate those 3 reports on one single report, I BELIVE that i need to declare the parameters on the main report and link subreport's parameter...more >>

Does the link below works with RS 2005? http://msdn2.microsoft.com/en-us/library/aa902691(SQL.80).aspx I did work with RS 2000 but with RS 2005 I have problems. Can someone help me please? Thank you. ...more >>

I have a row in which I am trying to hide if there is no data. However, I can't seem to get it to work. The value returned in the stored proc is null. I have tried the following: =IIf(First(Fields!Judge.Value Is Nothing, "dsAttorney"), True, False) =IIf(First(Fields!Judge.Value = 0, "d...more >>

hi Gummy I have one problem. I don't know how to embed a SQL report (2000) onto window form(VS2003), I do some research, a lot of information is VS2005. I think you are done before. Can you give me some information or sample code. I really need you help. Thanks so much. -Alber ...more >>

hi; im affraid this will be an stupid question... i have a table with records like this cve valor R1 100 R1 120 R1 145 R1 50 R2 67 R2 98 R2 200 R3 345 R3 20 R4 122 R4 80 R4 12 R4 2...more >>

What were the problems with SP1 that SP2 fixed and what new problems did SP2 cause? ...more >>

I'm using WinForms ReportViewer in local mode. <Textbox Name="Label51"> <Value>='='</Value> </Textbox> and <Textbox Name="Label51"> <Value>=Chr(61)</Value> </Textbox> causes error . How to display = character in report ? Andrus...more >>

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 >>