MS provides information about how to install and run SQL Reporting side-by-side with WSS2 installed. Are there any changes or special problems to install WSS2 on a Windows 2003 server running SQL reporting? Thanks Dan ...more >>

Hello all.... im trying to figure out... how can i use an expression in a parameter formula? I have a report which takes a date parameter. I want to make a subscription using last week as the date. So for example, i want to set up the subscription to run every Sunday, and use a value of TOD...more >>

Is anyone at Microsoft aware of the issues outlined below? We recently installed SP2 and discovered the following problems: Problem 1: All our reports are now printing a blank page at bottom of report when we use NEW client printing feature. To troubleshoot the problem we created a repor...more >>

Hey Peeps, Is there anyway I could get a radio box added to my report either by adding the radio button control to the tool box or adding a custom DLL with radio button functionality. My objective is to simulate a "Jump to report" inbuilt functionality using radio buttons. Like when the end...more >>

We have two charts sitting on top of one another and we want to have only one visible at a time. Wondering if this could be done programmatically passed upon a user action. ...more >>

When we generate a report directly to PDF the user is asked to open or save the PDF before it is displayed. Is there a way to have the PDF open automatically without that window being displayed? Thanks!...more >>

Hello, I have a stored procedure that accepts input parameters and depending on the input, returns multiple columns. For example depending on the month range passed in, the stored procedure creates and populates temporary table with columns for each month and returns the values in the t...more >>

How do I create a simple temp table in RS. ...more >>

We're trying to implement a simple "proof-of-concept" drillthrough report where a list of master records can be drilled into supporting detail. We have this set up and working through the designer and would like to programatically implement the functionality using ReportViewer. We are display...more >>

Can I upload a bulk of reports using Report Manager?...more >>

Is there anywhere a Crystal Reports user can get help without getting overwhelmed by designer lingo? I don't know SQL, XML, VB or any other set of initials. I just got to know Crystal 8.5 and Frontpage 2000 well enough to create a company intranet of over 300 reports and forms. Some sim...more >>

I am working with a well-studied DBA who claims that all report parameters must have default values in order to configure instance caching. Is there any truth to this? I don't see anything of this kind in BOL. We actually get rsProcessAborted errors if they don't have defaults (even thoug...more >>

Hi, I have a report that converts expression to Excel formulas. The Excel formulas in a table are incorrectly rendered in a way that the references are all off by 6 or so cells. When I set the "Omit Formulas" device setting to true the values are correct, though there are no formulas. I ...more >>

Hi, In my report I want to dispaly a different image based on the parameter user enters. For ex., the user enters a company name , then the image for that company should be displayed. Now in my database, the images are not stored using the complete path or a complete URL, but are stored ...more >>

Is this possible? I am trying to access the global variables via custom code. However I get this msg when I use the following code. Public Shared Function Hello() As String Return Globals.UserID End Function ERROR :- There is an error on line 1 of custom code: [BC30469] Reference to a n...more >>

we are currently using access to be the front end for adhoc reporting information from SQL server 2000 data warehouse. I wanted to touch base to find out what is the best way to do this if we wanted to SQL Server 2000 for the whole thing. I have heard that you need a secondary front end to g...more >>

I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's designer friendly interface. So please be patient & simplistic with your responses. If you can't place fields in page headers or footers how can you get fields to repeat on multi-page forms, like shop travelers and packi...more >>

Does anybody know what the URL Access method for printing is? It's not in the documentation under URL Access changes. Also, with SOAP Printing, if I call Print() and the client doesn't have the ActiveX installed already, will it install it automatically? Thx, Joel ...more >>

I am using SQL Server 2000 Report Services (SP1). I am using groups in my report and I have a report table where the Visibility Hidden property of the group is set to an expression. When the report is rendered to Excel, the report table is correctly visible or hidden according to the express...more >>

I have a situation where i am binding a Dataset Dset1 to a table. , I also have a Dset2 which i am not binding. Now as the Rows gets rendered depending on Dset1 i also want to populate a value from Dset2 (2nd Datset ) in a cell for a particular Row. How do i do that? Any help. Thanks ...more >>

I am trying to figure out a way to pull the values of one of my report columns once the report has been rendered to create a comma separated list of those values to pass as a paramater to another report. I figure i will have to do this in the code part of RS. Can anyone help me with the prop...more >>

Is it possible to set a drillthrough target programmatically using any web service call? I'm not sure if SetProperties() could be used - haven't found any documentation on this. Thanks, Matt...more >>

Hi, We have some websites. We want to attch a link on each wrbsite which would take the users to a different reports. Please suggest what will be the best security mechansism for this scenario.. Also, I was trying to implement the simplest security mechansim,i.e I craetd a user called Us...more >>

Was very excited after installing SP2 to see the printer icon. It was too much for the Managers in my company to export to PDF then print. Too much work they said. But once I clicked on the icon, my heart raced with excitement. Now I can stop listening to them about how much work is involve...more >>

I am having some issues with expressions as I am attempting to perform the following: iif(budget=0,0,actual/budget) it seems that regardless of the expression all clauses are evaluated. The actual expression is as follows: =iif( Sum(Fields!BudgetMTD.Value, "DepartmentDetGrp")=0,0, Sum(Fiel...more >>

Hello all, I am hoping someone may have an idea on the best way to approach this problem...at the top of all our reports (above the usual page - field - headers)is a sub report in all our old crystal reports. This sub-report shows the name of the report, the particular client database that...more >>

I need a way to format fields without having to write a conditional statement based on each textbox's value. I'm dealing with hundreds of fields. Something like a HideZeros setting on the field. Any help would be appreciated...more >>

Hi, I am trying to find confirmation that SP2 corrects the problem of missing rows when exporting to Excel. I checked the list of bug fixes and have not seen any mention of this. Thanks, -- Chris Hanley...more >>

I have a report that has its Pagesize set to "11in, 8.5in" and it's displaying and printing as portrait. I can export this to .pdf and it works, but I really need it to work without exporting. Please reply, is everyone having this issue with lanscape reports and SP 2? If there is somethin...more >>

Does SP2 need to be installed on both the development clients and the server? We have many development installs. If the SP changes are significant only to the server then installing it there only would be much more effective for us. Thanks...more >>

Hi, On my Win 2003 box, sharepoint portal service is running for a specific domain acct. Recently the password expired for the domain user acct and when we updated with the new password the report server has stopped working. It gives an error Reporting Services Error ------------------------...more >>

Im certain I already posted a topic on this this morning but it seems to have disappeared. Basically on generating a report I get an error when it decides to try and call OnLoadReport in my page. function OnLoadReport() { var pageHits = null; var rep = new Report(1, 35, pageHits, false, d...more >>

Morning all, One of the things i normally expect to find or do but am struggling. I have a table on my report that is populated with data. One of the fields is of type ntext but this needs to be set to a limit of 1155. Is there a way of setting this up in the report so that no more than 11...more >>

Bit stuck here and hoping someone can help. I have a web page with two sections - the first is a couple of drop down lists populated from a .net back end where the user can specify what report they want run and a few parameters. The second section is an iframe which when the user clicks a 'r...more >>

I have an issue with default papaer size and margin sizes. My printer is configured with a default paper size of A4, every time I print a report with the print control it defaults to Letter. So I have to hit the go button to the print to run. Secondly the default margin sizes are 12.7mm (1...more >>

How to incoporate with vs application using soap method please guide me advance thanks Raja ...more >>

Is this now possible with sp2 applied? Thanks Frank ...more >>

Hi, I am new to VS and Reporting Services and would like to know 1) We are running SQL Server 2000 on Windows 2000 Standard Servers, is it possible for us to install Reporting Services ? This is because someone says that it requires Windows 2000 Enterprise Server ? On the other hand, i...more >>

Is there anyway for reporting services to display measures on rows instead of columns as in Excel? I'm trying to format my data in rows but this doesn't seems possible in reporting services... does anyone has any examples of how this can be done? ...more >>

Hi, I am looking for a very simple and straighforward way of calling an already deployed report from ASP.net. I simply need a hyperlink that displays the report on screen if that is possible. Any help would be tremendously appreciated....more >>