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 2006 > threads for tuesday august 15

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

Help Using a field value in a url jump statement
Posted by Hotwheels at 8/15/2006 6:05:01 PM
I have a report that uses the table control, the last column has id's for dealcompanies in it(Fields!res_dealCompanyid.Value). When the user clicks on any of the other Columns in a row I would like to be able to grab the id from the last column in the row and insert it into the expression for ...more >>

Sorting Groups non-alphabetically
Posted by cobasi at 8/15/2006 5:12:37 PM
Is there a way to write an expression to specify the order that values in a group will be shown? Example: I have a field called "CodeField" with values 01, 02, 03, 04, 05, 06. The business rule is that the CodeField should be ordered in the report as 01, 02, 06, 04, 05, 03. I am grouping on...more >>

Export to Excel
Posted by smiksuek at 8/15/2006 2:25:19 PM
We are converting Crystal V10 reports to SSRS and have ran into an issue when exporting a large dataset 104,000 rows. In Crystal when the users export this same data it spreads it over multiple worksheets does any have a solution in SSRS that gives me this same ability. ...more >>

How to evaluate sum on change of group?
Posted by Ben Shaffer at 8/15/2006 1:47:01 PM
I have a data set that is grouped based on 2 fields, but the value of the set that I want to add by Group 1 is the same data that repeats for the first group. Example: Value Grp1 Grp2 ================= 100 1 1 100 1 2 100 1 3 200 2 1 200 2 2 200 2 3 I want to get a total of Value, ...more >>

Trying to Subtotal a Matrix
Posted by Amedeo Feroce at 8/15/2006 1:23:59 PM
I have a matrix report as follows: 7/22 7/23 7/24 7/25 7/26 pat1 as as dw dw pat2 as as dw pat3 as dw pat4 dw dw dw pa...more >>

External image not displayed in report manager
Posted by robbert at 8/15/2006 1:18:29 PM
Hello, I have a problem and I don't know how to solve it. I hope you guy's know. I have a report with a external image which refers to a image on a SharePoint intranet site. When I preview the report in visual studio the image is visible. But when I deploy the report to the report server t...more >>

Report is not printing selected parameters
Posted by Amedeo Feroce at 8/15/2006 1:11:22 PM
I have a report that a user can select one of five parameters. Lets just say those parameters are: ALL North South East West The default value is set to ALL and multi-values are not allowed. If the end-user selects North, the report displays just fine in Preview mode. When the user p...more >>

chart label mapping to strings
Posted by bhanoji at 8/15/2006 12:58:01 PM
How can I convert chart axis labels to strings. For example instead of showing 1, 2, 3.. on x axis, how can I show gold, silver etc? Thanks....more >>



problem with Selection criteria
Posted by Dan D. at 8/15/2006 12:48:02 PM
Using SS2000 SP4, RS2000, VS2003 I'm trying to put the start date and end date in the report header. I have a report title in the header now and it prints ok. As soon as I add a text box and the parameter for the start date, nothing in the report header prints but the body of the report print...more >>

Jump-To-Report Links In Exported Reports
Posted by mt at 8/15/2006 12:18:01 PM
Know It Alls, In RS 2K5, whenever a user exports a report containing links to other reports into Excel, the links are changed from http://<servername>/reportserver/etc to http://localhost/ReportServer?etc. Obviously, this renders the link useless unless you happen to be running a report on...more >>

Data tab works great but i can't get it work in Preview tab in reporting services
Posted by Dre at 8/15/2006 10:02:31 AM
This code works great in data tab but when i go to preview it i get a len function error. I am passing possible BLANK values in all the strings not NULL. Do you think its an parameter expression issue? If so, how do I write a expression for each parameter that will reflect this logic. NOTE: As you...more >>

HTTP Status 401: Unauthorized
Posted by Terry Smith at 8/15/2006 9:46:01 AM
I have a web application on server A and a reporting services install on server B. The web app on the web server is running under an application pool with a domain identity. Let's call the user, WebUser. The web server attempts to connect to the RS server as WebUser and receives "HTTP status 4...more >>

Order By with Query then bottom border
Posted by Colin at 8/15/2006 8:16:27 AM
Reporting Services 2000 I have a SQL query that is properly sorting a list of items I have by using the order by clause. I created a report using the report wizard and didn't use any fields to group by because I already have the list in the correct order. I did use RS to keep each team on i...more >>

iterating through a multi-value parameter
Posted by nitz at 8/15/2006 7:41:02 AM
is there a way to loop through a multi-value parameter and retrieve contents of all selected values to dislpay on a report. currently, i can reference individual parameter values by using Parameters!PARAMETER.Value(0...). However with dynamic parameter values generated from a query, this becom...more >>

Insert empty every X rows
Posted by emorgoch.public NO[at]SPAM gmail.com at 8/15/2006 6:59:11 AM
Hi there, I have a report I'm designing that's going to be a long list of data. I was wondering if there's a relatively easy way to insert an empty row into the report table after every 5 or so rows of data. Thanks ...more >>

export to excel without formatting
Posted by retkow at 8/15/2006 6:16:01 AM
Is is possible to render a report to excel without formatting? For example, I have a report that displays like this in my web browser. Country State City Sales USA MN A 100.00 B 50.00 ...more >>

Formatting Mailto command
Posted by Bob at 8/15/2006 5:08:12 AM
I am tring to format a mailto command for an email field. Properites - Navigation - Jump to URL option mailto:// Fields!email_address.ValueFields! This opens mail and inserts TO: // Fields!email_address.ValueFields! not the field data joe@joeco.com Thanks in advance. ...more >>

SP2 Print install
Posted by Tony Scott at 8/15/2006 4:54:01 AM
We have (finally) updated our RS installation to SP2, which, amongst other items includes the print-from-page feature. We have noticed though that when users access one of these reports and click the print button for the first time, they are being asked to install Reporting Services, to whc...more >>

Carriage Return ,VBCrLf in PDF
Posted by MikeT at 8/15/2006 12:51:12 AM
Hi, I have a report render out in PDF. There's a Employee Preference column which has "<BR>" to display each item on a new line. It works ok by using Replace "BR" with VbCrLf, but there is a problem when viewing in PDF. For example: Red <BR> Blue <BR> Green, should be displayed as: Red Blue...more >>

Out of Memory Exception
Posted by Phil Nicholas at 8/15/2006 12:00:00 AM
I'm getting an out of memory exception when designing by report model and selecting save. I'm using 64bit windows xp 4Gb Ram and two dual core xeons so presumably this is a bug! Anyone have any ideas? ...more >>

Updated Comparison?
Posted by Andrew Hayes at 8/15/2006 12:00:00 AM
There is a comparison between Crystal Reports, Business Objects, and Reporting Services here: www.goldencg.com/ssrs_comparison_pdf_version2.pdf But the SSRS version they compared with is old and I know that 2005 has at least some of those features now. Anyone know if there is a more up-...more >>


DevelopmentNow Blog