Is it possible to retrieve the connection sting from a shared datasource or the datasource of a dataset from custom code? My problem is not unique, I want to put data from the database in the report header. My solution is to create a function in custom code and simply connect to the database t...more >>

I have a sql table with a nvarchar type and I would like to use this field for a parameter but when I try to create a parameter for it. I receive a "Application uses a value of the wrong type for current position" Is there anyway I can use a parameter for this field? I've tried all of t...more >>

I'm using LocalReport.Render to create PDFs from my VB.Net 2005 application. The resulting PDF is about 10x the size of the same report rendered from RS 2000. Looking inside the generated PDF file, I see that the main body of the report is no longer using any compression. Is there any way...more >>

Everything I find about it just mentions putting it on the form. I can do that but I want to have programatic control over the report it should use, its parameters, etc. I started off just trying to set a parameter programatically. I tried this code: Dim Params(1) As ReportParameter Dim L...more >>

This is an odd one. I received notification a couple of days ago that some of our users just stopped getting the reports I'd set up by subscription. I hadn't noticed because all of my reports still come through with no problems. I added myself to the list of recipients for one of their reports...more >>

How do I use the new calandar control available in 2005 when select date parameters?...more >>

On one of my reports, I am getting the following error when I try to print: An unexpected error occurred in Report Processing. (rsUnexpectedError) I have read from somewhere that it is because I have a subreport within a table on my report. Does anyone know if that is true and if so, what ...more >>

I have figured out that you really can't place a function like CountRows directly in a report header. So I tried creating a textbox in the header that points to a textbox in the body that does the calculation. There expression for this new textbox looks like the following: ReportItems!tbRowCo...more >>

Hi, I have setup a dev version of Reporting Services 2000 and have removed all access to the reports via the report manager except for a single domain user (i.e. me) When other developers access the (http://server/Reports/) portal they are unable to run the reports however, they are able to...more >>

What is the backword compatability with VS 2005 and creating reports for SRS 2000? ...more >>

I take a snapshot of a report an it views fine the first time but I get the following error on subsequent viewings: An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Access to the path "C:\Program Files\Microsoft SQL Serv...more >>

I have not been able to find info on how to do this. I want to be able to group reports in subfolders on the report server. i.e. Accounting in one, sales reports in another. Does anyone know how to do this using rss scripts? ...more >>

I have a function that apparently returns value in string format (pls correct me if I'm wrong). When I try apply this in ‘textbox13’ =Sum(Code.HoursUsed( Fields!date_opened.Value, Fields!last_updated.Value )), it brings me error "The value expression for the textbox ‘textbox13’ uses...more >>

I have installed MS sql server 2005 developer edition beta2. In report designer,i have given a parameter to a multi value and when see in preview i am able to see the multi valued parameter. but when i run it and see it in reportserver,even though i select multi values,while displaying the res...more >>

I am testing the upgrade process to Reporting Services 2005. I ran the upgrade advisor and no problems showed (other than there are things we can't detect error). I ran the upgrade just fine. Now here's a couple of notes: After upgrading, I didn't see the Report Builder icon. Figuring it wa...more >>

Hi, I'm looking for a way to justify text in reporting services, I thinking that with a custom assembly I will can do it? Somebody did it? Can somebody tell me how? Thanks Manuel ...more >>

I created a Web site using VS2005 and one of the Web forms has a ReportViewer control. This works great on the development computer itself. I then deploy to a computer with only the Framework 2.0 installed and not VS2005. Everything works, except when running the page with the ReportViewer, ...more >>

Is it possible to use different datasets in the same region in the report. Let's say I have 2 sources which I need to combine, I have a field in each source I need to add together and see that result for a list of different accounts. I tried to do it in an expression choosing the datasets,...more >>

I am not understanding what my issue is on this one! I can look at the data returned from the dataset in Data view, but when I attempt to show a table based on at least one value being true (from several) it says: "The hidden expression for the table 'table1' refers to the field 'SSFLunchRegula...more >>