Can you use SQL Server Reporting Services that comes with SQL Server 2005 and have that be the only thing that is installed on a SQL Server 2000 box? I need to use reporting services with Whidbey but want to use them against a SQL Server 2000 machine. Thanks!...more >>

Hi all, I'm getting a headache trying to figure out what is going on here. I've set up Reporting Services on 1 dev machine and 2 servers and using a Web Application that I am developing to access Reporting Services to generate a report for me. Everything works fine on both my development mach...more >>

Let me preface this I need to design a report that displays data for 3 branches of same companies, Branch A ,Branch B and Branch C. The problem is that each Branch has their own distinct server and database. The schema is identical between them, just different data in each. The report...more >>

Hi, I have a report server that is working almost fine and dandy. The only little snafu seems to be if no one hits the server for "a while" the report server seems to "go to sleep". Bringing up a report after it has done this can take a little time, but any subsequent reports come up nice and...more >>

I have a column in a the main (matrix) report that runs a subreport passing the parameters based on information on the record/line. That seems to work fine, but... How do i get back to my Main report without re-running the whole thing? Seems as there are no visible controls to close the subre...more >>

Hi all.. After some days working with Reporting Services, sometimes I get frustrated because of an errant behavior of Report Server. For example, sometimes, a building error is shown telling that a field is badly defined. Then I close Visual Studio .NET, reopen and build the solution again,...more >>

Hi, When I select the export to excel file format, I get the following in the excel file: "Data Regions within table/matrix cells are ignored". Is this a known bug in RS.. Any info will be appreciated. Thanks Suresh ...more >>

Is there any possible way to bundle my reports with references to other controls to build a visual representation of data? I realize that this is all informational, but I've got a problem with the stock graphs, they look HORRIBLE. Anyway, thanks in advance Weston ...more >>

All, I'm looking into the ability to move a report and it's history from one reporting server to another. Moving the reporting is no problem, but I am not having any luck in finding a way to move the associated historical reports. I have used RSScripter to move reports, but the history does...more >>

Hi All, I must be overlooking something obvious, but I could reallt use some guidance. I can't find or figure out how to format a string in my report. The datacolumn is just a string containing numbers like 123456789 and I need to display it in the report as 123-45-6789 . From the books on...more >>

Hi Is Microsoft Reporting Services a good tool to use for the generation of datasets to be exported to external systems (as CSV or the like) or does it start struggling with large data volumes? We will have data feeds, which will soon have 100,000's of records. Is this type of thing fine fo...more >>

How can i start printing a report from a trigger activated store procedure ?...more >>

Hi all.. I have a dataset named "Primas" that returns 3 records with 3 fields each. I want to display a list of those records with a header and a summarize row. To do that, I placed a Table control into the layout. Assigned "Primas" as the dataset and I placed a textbox control into it w...more >>

Hi, I am trying to figure out the way to embed a plug-in (Chime for Windows) into my report, so that I can display a certain object from a database, that is stored there as a string. This Chime plug-in would read the input string and convert it to video display. This embedding is easily do...more >>

Hi, To clarify the previous post. I would like to write a stored procedure that a client can call. The stored procedure will then output its result in an excel file. Thanks, charia ...more >>

Is there a way to generate a report that looks like a calendar. If i want to view a schedule with people assigned to days of the month. ...more >>

Hi, How can i have white spaces preserved ?? i tried giving =" " & fields!test.value in a text box expression, but still i get the value without empty space. Thanks in advance...more >>

Hello, I am developing a statement for a dental practice. What I need to do is to list all the charges related to the patient and list patient name at the button of page so that she/he can tear it and return that part with the payment. So I created a group based on patient name, and listed ...more >>

Hi, I am using ASP.NET to display reports using the report viewer object. I have multiple MS Access databases that can be used as the datasource to a report. I know how to make a connection to multiple different SQL databases passing the database as a parameter in the URL of my query a...more >>

I am wanting to reset the page number on the break of each group. For example Group A - 3 pages Group B - 4 pages So for group B on the 4th page it will start with 1, using the following code this does this fine Shared offset As Integer Public Function GetPN(reset As Boolean, pagen...more >>

I guess I'm doing something wrong. I need a report to display details of an item and for each of those 2 lists of related Data Something along these lines: Name: [Name of Item 1] Created Date: [Date Item was created] Related Data 1 Id Name Other Data 1 Name1 Other Data 1 2 Nane...more >>