Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server reporting services > august 2004 > threads for friday august 6

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Report Manager in Web Site?
Posted by AbiBaby at 8/6/2004 10:33:02 PM
In short, how can i get www.roadhouse.com.au/ReportManager deliver reports? Description: I developed reports managed to get them work on localhost/ReportManager and through ASP.NET pages. I want to deploy on to a Web Server which hosts several websites. I see that i can access reports throug...more >>


% of Report Total
Posted by Costas at 8/6/2004 5:24:18 PM
I want to show the line by line % of a Report total in the detail section of a report e.g. $25.00 - 25% $50.00 - 50% $25.00 - 25% Report total $100.00 - 100% What is the best way to do this? ...more >>

Making text bold in a table cell
Posted by alien2_51 at 8/6/2004 4:59:37 PM
I want to build a string to be displayed in a table cell using an expression, I want to make some parts of the string bold. Can I do this..? here's an example, in my table cell I have the following expression: = "Cause:" + Fields!Cause.Value I want to make the text string "Cause:" bold TI...more >>

First(, Last(,
Posted by Cindy Lee at 8/6/2004 4:50:55 PM
There's no Second(? Or Third( ...more >>

Parameters in Reporting Services
Posted by Delphos at 8/6/2004 4:19:02 PM
Hello I'm trying to send any parameters to reporting services I using URLaccess, but it not valid nothing examples http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fReportes+Acceder%2fImpresiones%2f01+Acceder+Catalogo+de+Personal&ordenar=C parameter name =ordenar value=C what can I d...more >>

Is it possible to display the selected label (not value) of a query based Parameter in report page footer?
Posted by Wendy H at 8/6/2004 4:18:22 PM
Hi, If I have a query based parameter which has labels and values, for example, parameter: Department, label: DepartmentName, Value: DepartmentID, I am using the parameter value (e.g. DepartmentID) in the dataset filter, but I want to display the parameter label in the report page footer. Is t...more >>

Sumarize parts of column
Posted by Marius Trælnes at 8/6/2004 3:58:02 PM
Hello! Below is a resutl of a dataset in a query. I can't get get the "Total New 20" to work. How can I group it so that I only sumarize the New status? I tried filter in grouping but the filter seems to work in the table rows as well so then Pending and Complete statuses are gone. I've tri...more >>

RS ...Server/Firewall Issue-Configuration
Posted by spheroid at 8/6/2004 3:13:02 PM
We have been developing some reports using RS on our SQL Server box which is behind our orgs' firewall. All was well until trying to open a report from a web page from the Internet. The reports would not open and it seems that it is because of the SQL being installed on box that is behind the ...more >>



rsFailedToDecryptConfigInformation
Posted by vonpatogm at 8/6/2004 3:11:02 PM
I have Windows XP(SP1) With Framework v1.1.4322 - When I build a Report the application display this message: Build complete -- 0 errors, 0 warnings - When I deploy a Report the application display this message: Deploying to http://localhost/ReportServer?%2fReportesSINPHOS Error rsFailedToD...more >>

Repeating data
Posted by alien2_51 at 8/6/2004 2:41:16 PM
I want a table with fields from the dataset that repeats for every page in the report. How can I do this...? Dan ...more >>

Reporting Services Configuration issue
Posted by Ameen at 8/6/2004 2:25:30 PM
Hi, I have a question on Reporting Services Security.Any help is greatly appreciated. we installed reporting services 2000 on windows 2003 O/S. also applied SP1. Reprots are also deployed on this server. When we access report server or report manager. The following error is b...more >>

PDF Byte Error?
Posted by rwiethorn2002 NO[at]SPAM yahoo.com at 8/6/2004 2:00:05 PM
I've been reading through the group and seems like a lot of people have been trying to display the report as a PDF in IE. However, the byte stream is wrong so it won't allow it. Does this happen in both methods that generate the output: the SOAP Render method, and the URL Access (Format='PDF')...more >>

Print Preview
Posted by alien2_51 at 8/6/2004 1:01:01 PM
When my report renders it looks fine in the report viewer, when I goto print preview there is a blank page between each page with data. I'm sure this is a simple problem, can someone please help...? Thanks, Dan ...more >>

Different images based on condition...
Posted by Lisa at 8/6/2004 11:47:55 AM
I was wondering if there is a way to display a particular image into a table record based on a condition. For example, I have a list of questions that come in 3 different types, each type has a different image associated with it, so it would look like this: <Image1.bmp> First Question (type i...more >>

RS Forms Authentication single sign-on problem
Posted by TechnoSpyke at 8/6/2004 11:37:20 AM
I am trying to implement the forms authentication (using the MSDN custom security extension), to enable a single sign-on (SSO) between our web application and RS. SSO works fine when both application and RS are on the same machine. However, I haven't made SSO work when RS is on a different mac...more >>

Resetting the pagenumber at new every group
Posted by Daniel Aebi at 8/6/2004 11:19:49 AM
I need to print multi-paged invoices. Therefore I'd like to reset the page number to 1 whenever the customer changes (i.e. pagenumbering on group-level). The whole print-job encompasses hundreds of pages. How can I do this? ...more >>

DPE parameters
Posted by montgoss NO[at]SPAM hotmail.com at 8/6/2004 10:18:18 AM
I'm creating a DPE to accept a serialized dataset as input to my report at runtime. But I can't get the parameters working correctly in VB. I assume the reporting service has some mechanism to set the parameters, but what is it? I have the readonly property Parameters that implements IDbCom...more >>

Nested Table
Posted by Shane Castle at 8/6/2004 9:31:06 AM
I have a table nested inside another table. Within the nesting, I want my data to show me the detail, and not do a grouping. Unfortunately, the inner table wants to keep doing an aggregate of the data, but I want to show the detail. So I have a part number that has multiple customers being ...more >>

Ganntt Chart
Posted by Joe at 8/6/2004 9:12:48 AM
hi guys, any way to creat ganntt chart in RS? JJ ...more >>

rsactivate error - trying to install on 2003 with Sharepoint servi
Posted by Jeffffffffff at 8/6/2004 9:11:03 AM
I am trying to install SQL Reporting Services on a Windows Server 2003 box that is running Sharepoint Services 2.0. When you run the install you are warned that you will need to manually initialize SQL Reporting because of Sharepoint and are referred to the documentation. In the rssetup.ch...more >>

Plot data as line (is disabled on <Edit Chart Value> dialog)
Posted by Kam at 8/6/2004 8:25:02 AM
I have a requirement to plot a line on the Area chart, and am wondering if Reporting Services even allows us to do that ? Right now, I am plotting the data using marker (X) however, it does not give me adequate information of where does this particular Customer record fall on an Area chart th...more >>

IIF Statement Not Working
Posted by Mike Collins at 8/6/2004 6:59:02 AM
I've added the following IIF statement to a table in one of my reports, and the second IIF statement does not ever evaluate to True. I don't see anything wrong with the statement. Can anyone help? =IIF(Fields!DisplayOrder.Value = 0, Fields!Total.Value, IIF(Fields!Successful.Value = -1, "Su...more >>

Security Problems
Posted by Jakob Christensen at 8/6/2004 5:49:02 AM
Hi, I having a bit of a problem with the role based security in RS. When I first installed RS all domain users belonged to the local Administrators group on the server. I then removed the domain users from the Administrators group and added myself. As a result one of my colleagues was un...more >>

Intergrity of forms and windows Auth
Posted by Rags Iyer at 8/6/2004 4:55:01 AM
i Have an ASP.NET Application with forms authentication which uses sql reporting for report purpose ,but report server works on windows authentication ,due to which dialog box is popping up,i need to know a way of integratinf the two to have a single sign on Process?...more >>

Multiple item selection from a queried report parameter list
Posted by RW at 8/6/2004 4:33:01 AM
I am trying to mirror a report originally published through another non MS reporting application which allows multiple selection from a query parameter list by use of the normal Windows 'Ctrl' or 'Shift' keys in cojunction with the mouse click. This method does not appear to function with ...more >>

Reporting Services Currency Symbol
Posted by Neil at 8/6/2004 4:11:01 AM
I have added User!Language to my report which returns en-GB but the currency format 'C' still returns the values in $ and not £ MSDN and an earlier post here mentions the help text that has this section 'you can set a locale on the report and on individual text boxes by using the Language p...more >>

Using Render method
Posted by Chiara at 8/6/2004 3:47:02 AM
Hi I have a struts web application in which i need to call a report. Currently, i do this through URL Access. However, i want to block the grey Microsoft javascript pop-up message asking user whether to Open/Save. I read that i must use Render method from RS WebService. How can i call this ...more >>


DevelopmentNow Blog