It appears that to enable true authoring over the internet, you need to create local users on the RS/IIS box, and create identical SQL logins so remote users can build their DSN's for their reports. Other ideas? Jeff ...more >>

I specified the page size in report properties as 14in x 8.5in, which should be landscape on legal size paper. I only get 11x8.5 in PDF and Tif format. Is there another place to set the page size? Gerhard ...more >>

We just purchased the Visual Studio .NET Special Edition, which includes the Developer Edition of SQL Server. However, there was no CD of Reporting Services contained in the box, and I can't find it anywhere for download. Where can I get it? Thanks. Jon Pearce jonp at the domain below dg...more >>

I was wondering if someone could assist me in writing an experession that would subtract 2 DateTime's. I have 2 DateTime fields and want to display both in a report and in a third column the difference between the 2 values. However, I get an error: "Operator is not valid for type 'Date' and ty...more >>

I'm getting an error when running an rs command from a stored procedure. The same rs command works fine from a command line. Any help would be appreciated. The following is the trace message from SQL Server. System.Exception: Could not connect to server: http://[reporting services URL he...more >>

Hi, I have whitespaces in the first line of text in a textbox but Reporting Services always trims the whitespace. Does anyone know how to insert whitespaces in front of a text(It's similar to Paragraph: First line start at 0.5cm in Word) Ponnurangam ...more >>

My report has two DataSets. The first has two columns EmployeeId, EmployeeName The second has two columns EmployeeId, EmployeeEmail Doing a JOIN in the SQL is not a possibility. I want the following output table: EmployeeId EmployeeName EmployeeEmail -------------------------------...more >>

I need to run a report, output it in a CSV format, and store it in a specified directory. I am able to do it using VS.net report designer. How can I programmatically specify the output format and the destination directory? I'm new to RS, thanks for you help....more >>

The following query string locks up report designer on dev studio. Is there a limitation or unknown bug that causes report designer to not be able to parse this length of statement into xml? ( It's not too long for the query designer text box, since the whole statement fits. I've had other q...more >>

I have a report that I developed. When I click the preview tab and see the report it show's 1 page which is correct. When I click the "Print Preview" button it shows the 1st page and 3 blank pages after? It also prints this way. Why is it doing this? David ...more >>

Pretend I have a table called Employees. I want to know how many mend and women work for me. Something like this: =Count(IIF(Fields!EmployeeGender.Value = "M", 1, 0), Nothing) =Count(IIF(Fields!EmployeeGender.Value = "F", 1, 0), Nothing) Similarly I could get today's and yesterday's o...more >>

My report was beautiful until I put groups around my two tables... actually at first it looked fine... then I started changing text box sizes etc... suddenly every second page in my report is blank... not in the viewer... when I export to PDF... anyone know a RS exorcist?...more >>

I have a single node of RS server using another node of SQL 2000 server. I applied the SP1, developed reports, and everything is fine. I then wanted to install a second node of RS server, but unfortunately the setup fails with the following error: Report Server Database is a different versio...more >>

Hope someone can give a hint how to resolve this issue. RS manager indicates the report was sent via e-mail, but the mail is not received by the recipients. The wierd thing is that manually putting a file in the SMTP Pickup folder like the one below. it works fine. File is sent and receive...more >>

In my report, I am trying to set the top border of a textbox and the only values that seem to work are Dotted, Dashed, and Solid, unfortunately I am trying to use Double. The documentation says that only the aforementioned values work in a chart, but it says nothing about a textbox. By the way...more >>

I am using custom code to visit a webpage which is secured by ntlm authenication. The function will return 0 if it is success. I can successfully run this code using visual studio reporting environment. However, if I publish this report on the server, it is throwing error. Any idea? Thanks...more >>

Does anyone know why I get this screen? I have no interest in a web farm, but there's no way to cancel or skip this screen. Thanks, Burt...more >>

Hi, I have a report which has a Boolean parameter. from Visual studio I have set two 'non-quried' available values, one for describing the False value and another for the True value. From the front-end that i'm building, when i get the report parameters using the GetReportParameters web met...more >>

Ok.. I've been looking around and I just don't see how to do it. I used to have an eval copy of Reporting services on my local machine. The eval copy ran out so I got the enterprise copy on CD. when I try to install this on my machine I get an error saying that it won't let me install reportin...more >>

Can anyone tell me the status of the hotfix to resolve the runaway log file issue? I've been trying to keep an eye on this group as it had been mentioned in previous posts that an announcement would be posted here when the fix is available, but I haven't seen it yet. Didn't know if I had misse...more >>

Sometimes the chart axis labels are vertical. Sometimes the chart axis labels are horizontal. How can I control this? Thank you in advance. Jerry...more >>

I am an Oracle PL/SQL guy, and am used to formatting dates with a to_date conversion function. I can't figure out how to do this in RS. I have a couple of date parameters, used to filter by date range, with the default beginning value set at 1/1/1900 and the end value at 12/13/2050. What ...more >>

Is there a way to tell the report server to update a snapshot using a URL call? I know there is a "snapshot" variable that returns the snapshot, but i dont want the report at all, i just want the snapshot to update. Thanks Brian ...more >>

Hi, I have the following problem: I get from a database 2 double such as Num and Den In a graph component i use them as data for a percentage like that: =Code.Divide(Num,Den) where the Divide function returns (Num/Den) if Den doesn't equals zero the trouble i have is that RS auto...more >>

I have created a report that uses a SQL stored procedure. I am passing 3 parameters 1 of which is defined in the stored proc as NVARCHAR (10). I have created 3 report parameters and I am passing them to the stored proc via the parameters tab for the dataset. In visual studio the closest option...more >>

Simple question, but big impact. I have a shared schedule for 1:00AM every night. If I set 100 reports to that shared schedule do 100 reports start at 1:00AM? Thanks in advance. Jerry...more >>

Hello, I have a very simple report with one matrix setup on a landscape page orientation. Margins are properly setup. I cannot get this to preview in Report Designer. What is the solution for this? Thanks, Sam...more >>

I have a client who is interested in running a query that will indicate the success and start/stop of execution of reports so they can get an "executive summary" of how the many many many schedules are executing throughout the day and night. Is this easily available? Thanks in advance, Jerr...more >>

Using Visual Studio I am trying to arrange my reports. Here is what I have found: 1. I cannot create folders in Visual Studio. 2. I can deploy individual reports after changing the project property (destination folder) to have reports arranged in folders. 3. I can deploy multiple projec...more >>

This HAS to be the most common question - yet I have not found it. I have TWO developers. One is working on reports, now the other wants to help. How can Visual Studio open the RDL files already on the server? It's a "team" question really. How do I do it? Thank in advance, Jerry...more >>

I am calling a stored procedure from reporting services. The problem I'm having is that it's only returning the first field in the result set in the field list. When I query under the data tab, data and field names are there and all data is returned successfully. I have tried refreshing...more >>

Our production environment has multiple SQL Servers installed and running and i need to retrieve data from multiple different servers and databases. We have established multiple Web Service DAL's to retrieve data for out applications but i cannot see how to leverage that into Reporting Servic...more >>

I have uploaded a number of reports to the Report Manager on the server. However, the users can't see the report items when they view the Report Manager URL. Is the fact that they can't see the reports as result of a permissions/security setting in Report Services or IIS or both? Thanks in ...more >>

Is it ok to make changes directly to the ReportServer database - adding tables and stored procedures? Will admendments I make affect upgrades in the future?...more >>

Our production environment sits on a different domain, behind a firewall. We need to deploy our reports to our production server, but can't deploy to the other domain. Also we are avoiding putting VS .NET on the production server by not installing the Report Designer. So, I was thinking...more >>

Hi, I'm using a subreport that displays a NoRows message. Is there any way to format it so that the NoRows message/textbox is different from the normal subreport (i.e. big and red and ugly so people will notice that their data is incomplete). Is there a NoRows=True property or something th...more >>

does anyone know how to add row headers? I have a matrix with a row composed of 5 groups, but I'm not able to add headers to each group because the header cells are merged into one. Also, is there a way to move selective row groups around? i.e. I would like to move row group 2 and 4 to the ...more >>

Hi. I use custom asembly in report and everything works fine in preview mode.When published to report server and run following error comes: Failed to load expression host assembly. Details: Security error I have included <CustomAssemblies> in RSReportServer.config Code in assembly jus...more >>

Hi! I wonder if it is possible in any way to schedule reports to run every hour each day between 0800 and 1700? /Mattias...more >>

Hello, I've the following problem: running sql server on machine A running reportservices on machine B machine B is a week one, so I ordered from our IT a bigger server and reinstall everything (win2003 / reportservices ...) after setup everything works fine! (remember sql DBs on machin...more >>

I have a report with several parameters, and I want to load default values from a table (this is no problem). But if a user change the default value, I want this new one to be stored in the same table, so that when the user wants to run the report later on, the last used default value shows u...more >>

Hi, I have defined a boolean parameter in my report and I wish to display a list of possible values instead of the True/False radio button. I have defined two possible values in the Available Values list (Report Parameters Window) but it looks as though they are ignored, the parameter toolba...more >>