Hi All, Can I ask you something about Grouping and Aggregate Functions in Reporting Services? My question is, I have a grouping in a table like the following; Group 1 - Manufacturer - TotalInvoicePerManufacturer Group 2 - Region - TotalInvoicePerRegion Group 3 - Distributor - TotalInvoiceP...more >>

Hi Lachev, Teodor S, As per talk with you can u help in how to create Toolbar (like URL Access method). I'm using webservice method. I want mainly Referesh, Export and Paging features.. Thanks, Gaurav. ...more >>

Hello, I will like to know if Reporting Services can support store procedures that uses temp tables or return queries from temp tables? I've tried to use store procedures that uses temp table with reporting services but i'm getting errors. anyone got any experiences with this?...more >>

Hi All, There is a posting in this forum already about this...but it doesnt really tell me how to modify the home page. Like the previous user who posted a message I am wanting to put our organisations logo on the home page. Any suggestions would be much appreciated. Regards, Terry...more >>

Is there a limit to the maximum number of parameters that can be used in Reporting Services when you render a report. I hava report that uses about 35 parameters. the preview works fine but when I deploy the report to the server and render no data comes back. If I have 30 parameters it works f...more >>

I'm going nuts... Alright, so I'm trying to write a custom web part for viewing reports using the sample that came with MSRS 2000 to be deployed in sharepoint. I know BML has a set of controls that heavily uses javascript, I'm trying to do this server side but running into a mess of issues...more >>

Hi - my config is as follows: - RS Standard on Windows Server 2003 (server1) - SQL Server 2000 for repository on a different server server2 (same domain) - I am logged onto server1 as domain admin (full SQL perms to server2) - I have successfully installed other RS repositories to server2 (dif...more >>

I am using a subreport to lookup up a name from a code value since the lookup table is in a separate database from the main report. How do I limit the white space on the name field? I have defined a single textbox in the subreport, but when I preview the subreport it displays a complete line. ...more >>

Hi, is it possible to use an SQL2000-Report direct from C# (web-form or windows-form)? or is it possible to start a report direct from C#? Thanx in advance Ralph ...more >>

I have a @StartDate and @EndDate parameter that the report user puts in. To this string value i want to at a time value such as 00:00:00.000 and 23:59:59.999. So the @StartDate parameter will look like this '11/01/04 00:00:00.000' How do i accomplish this in RS? Thanks! ...more >>

I have a question regarding page break. Is there a way to add a page break before a text box? I know you can do this with tables, but I need to have the textbox which contains the table title to start at the top of the page, instead of the table itself. Thanks. -Joseph ...more >>

I am using lists to group reports, and I belive I am not doing things in the proper order. As a result, sometimes the list and the fields contained in them can be moved outside of the parent list - this causes the report to not function correctly - for example, in the reports I have that seem...more >>

OK. I've got a tough one here. I am attempting to create a parameter .aspx page that will pass in start date, end date and multiple storeIDs to the report. A section of my query in the report dataset looks like this: WHERE (dbo.SalesCheckDetails.SalesDate BETWEEN @paramStartDate AND ...more >>

I've created a function Period in custom code block. Then I put expression =Code!Period() in the textbox. Then I got this message: The value expression for the textbox ‘textbox6’ contains an error: [BC30367] Class 'ReportExprHostImpl.CustomCodeProxy' cannot be indexed because it has ...more >>

If my database goes down, i get a popup error with the red x saying can't connect to database, can't find the cubes, or the cubes are busy, etc... Is there a way to change the error message to say: "Report Cubes are being refreshed right now, please try again" in the popup. Or point to...more >>

Hi, In the application that I am working on, we currently use Crystal Reports as the embedded reporting engine. I am trying to evaluate if we should move over to Microsoft Reporting Services. However, one thing confuses me. It seems Microsoft Reporting Services will work only as a server under...more >>

I have been asked to create a calendar-like parameter for dates like people are getting used to seeing on the web. Is there a way to do this or is it coming in a new release? Also requested was a multi-select list parameter with check boxes....more >>

I have a data series that resides on a single row of a table in multiple columns. Customer,Month1,Year1,Value1,Month2,Year2,Value2 etc. for twelve months. I am able to show the data within the report ok, but have been unable to chart it so that there is a single series of values for the custo...more >>

I have a report for a customer who wants to be able to print three different colors of an invoice by loading three different colors of paper in seperate trays of the printer. The report already done in RS, I have no idea on how to proceed from here... Any ideas....????...more >>

I am having trouble get the Total on a column, i get the following error: c:\inetpub\wwwroot\cireports\PurchaseDetails.rdl The value expression for the textbox 'textbox15' uses an aggregate function on data of varying data types. Aggregate functions other than First, Last, Previous, Count, a...more >>

I have set up parameters selected to show on top of report by using the following expression in a text field: =(Parameters!ContinentID.Value). This shows the ID no of the item selected and not the text name. How do I do a look up to the table that holds the text name for the particular ID ...more >>

Hi all I have a report that works fine for html and pdf rendering. But when I export it to excel RS throws a ReportRenderingException. The error is "Stack empty". Anything else like PDF, TIFF... is rendering without errors. Does anyone has similar problems or knows whats wrong? Can this be a ...more >>

I'm evaluating Reporting Services and currently converting a Crystal Report to this format. However I've ran in to a problem and it is to do with a function written in Crystal syntax but I cannot seem to be able to convert this logic Heres the functio -----------------------------------------...more >>

Hello guys, Well, nobody could help me and after many trys to produce my two sided pages report, I cannot succeed. I think now that it's impossible to produce a report having two sides of each page with different printing logic. Am I right ? Jean-Marc ...more >>

Is this a bug? I have two shared data sources (one points to a production server, the other points to a development server). One is named MyDB.rdl, the other is named MyDBDev.rdl. Both of these are SQL Server data sources, and they use a specific username and password. I'm using Visual Stud...more >>

I have a lengthy (750 line) SQL query that I was given to drive a report. It spits out about 10,000 rows. No matter what, when I attempt to refresh fields or even run the query in Visual Studio, my CPU almost instantly shoots up to 100%, and I have to kill the report. The databases that the...more >>

I know how to link to Reporting Services, and how to link to a specific report; is there any way to link to a specific directory? I'd like to send my CRM users to a specific directory for CRM reports. When I try http://RSSRV/ReportServer, I get to the general Report Server directory; however, ...more >>

hi I am new to reporting services of SQL Server. I just read an article about it. In our organization, we are using Crystal Reports to develop reports for our system. Backend is of course SQL Server 2000. Can anyone please guide me that from where I should start to explore this new techn...more >>

I'm failry new to Reporting Services and I need to put the name of the previous month into the Report Header. For example I need it to look like "November 2004...." How would I go about getting this into the Report Header. Thanks in advance, BJ...more >>

Is it possible to perform a calculation with fields from different tables on the same report? If so, what syntax is used to reference each field? David...more >>

Looking at the feature comparison on the MS page, it indicates, that the standard edition only supports up to 2 GB RAM and up to 4 processors. What does this mean? a) Standard Edition is not able to run on machines with higher/more RAM/processors b) Standard Edition can run on 'bigger' m...more >>

Hi, all, I'm having one of those "dense" moments. We've installed Reporting Services on our SQL Cluster. Have a workstation running .NET Framework and Visual Studio.NET. I can't figure out how to install the client portion of Reporting Services onto the workstation. Can anyone point me ...more >>

I am trying to display a RS report in a webbrowser control inside a Visual Basic 6 application. I have come across the following problem: Currently when a user navigates to the reporting services web page usign IE a login dialog appears to supply credetials to be used to run the report. ...more >>

Hi, I'm running into a problem with PDF attachments on a specific report. It happens that the attached PDF file is low-sized and Acrobat tells me that the file is corrupted. I've tried to apply the following fix on my RS server http://support.microsoft.com/default.aspx?scid=kb;[LN];87277...more >>