btw, this approach eliminates the ability to have subtotals for row groupings since each 'row' is a group of one. maybe ssrs 2008 will handle matrix reports better.

nigel.c.west (7/2/2008)

---

OK, I have managed to do this.

First, normally you would have two row groups in this matrix, the first based on the outer grouping (in my case County) and...

i've spent the better part of two days fiddling with every option i could think of. i still think the ability is there, but the product is so poorly...

If the Source of an image is External, the value is an URL to the image. You can use an expression like so to change the image based on...

but if the users have to open a browser to enter the parameters and trigger the report, then there isn't much redundancy in exporting that to CSV. it seems...

i'm confused. when the report runs in report viewer/manager, why can't your user(s) just export the report as CSV to the proper location?

Dimple,

If you can modify the proc to use temp tables, this tactic may help you:

create proc test2

as

begin

insert into #x

select getdate() as date1

insert...

the syntax posted is correct. is that the verbatim expression? try replacing the Iif parameters with literals until you find the real culprit.

=Iif( True AND False, "a",...

one last point.

computed columns can make it easy for lazy app/gui/report developers to get formatted data.

[font="Courier New"]table definition:

...,

empPhoneNumber dbo.typePhoneNumberUS null,

empPhoneNumberFormatted =

left(empPhoneNumber,3)+'-'+ substring(empPhoneNumber,4,3)+'-'+ right(empPhoneNumber,4),

...[/font]

gwque:

would you store money values as '$1,234.02' and '£202.00'?

Advantages

User controls formatting, including complex international formats.

No need to dynamically set input mask on UI based on country code...

Gwen (6/4/2008)

---

Steve,

By using the aggregate function on the COMBINED_DATA field, I'm

getting multiple rows per property, rather than one row per property.

Using the table #data Antonio posted earlier, the...

we handle our own authentication and our url looks like this:

[font="arial"]http://OurServer/ReportServer/Pages/ReportViewer.aspx?

/PathAndNameOfReport&rs:Command=Render&rs:Format=EXCEL

&rc: Parameters=false&ourReportParametersAndValues[/font]

you can do the calculation either in your SQL or in a ReportBuilder expression.

SQL always returns the current date and time. if you only want the date,...

if you're using a web link to access the report, just add &rs:format=excel to the url.

if you can invert your logic, you can use Previous() to find a value from the prior row.

row 41, person=john: Crystal's next( person ) returns 'sally'

row 42, person=sally: SSRS'...