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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|