Reports

Background Color from SSAS cube on table's grouped rows
I have a report against Analysis Services (all in 2005) which uses the back_color I defined in the cube for the report's textbox BackgroundColor. It works fine for detail rows but on grouped rows it is using the color belonging to the first record instead of the color belonging to the aggregated values for that... 26 Jan 2010 22:19

Jump To URL issue
Report A jumps to Report B...good Report B opens in new window...good I have a parameter input box in Report B that is supposed to get populated from parameter in Report A...Not working. 1. How do I make this work 2. Is this efficient or is there a better way of doing this? 3. I did jump to report but could... 27 Jan 2010 14:56

64 bit SRS – Using an ODBC Connection to an Access Database
I have an Access database that we use to grab data for an SRS report. We just recently upgraded SQL 7 SRS to a new machine that is 64 bit and both SQL and SRS are now running on a 64 bit platform. Unfortunately the reports use a custom data source that is ODBC with a DSN pointing to the Access Database. Wh... 2 Feb 2010 17:35

What string to pass in URL to open report viewer in a new window?
I'm just launching a report via URL and passing a couple of parameters. What can I use within the URL to cause the report viewer to open in a new window (similar to &rs:Format=Excel)? This hyperlink is external to any SQL Reporting Services report (not using "Jump to URL" within a report). Just a simple exter... 26 Jan 2010 02:13

Strange paging problem - please help
I've messed around with all sorts of page settings and still no luck. I have a report that is landscape (11 x 8.5) and when I preview the report Globals!TotalPages reads "Page x of 5". However when I print the report out, it reads "Page x of 87". Many many more pages than expected. I've also noticed that the... 25 Jan 2010 16:15

OnDemandReportRendering documentation
Can anyone point me to the new Report Object Model documentation implemented in OnDemandReportRendering? thanks- -Jim ... 27 Jan 2010 18:21

Page SPlit
I am wondering if the Microsoft guys or someone please answer this or create a fix for this. Whenever a tablix is put inside another tablix the keep together functions do not work. My inside tablix has all the data I need to keep together but the keep together function will not work on any of them. I have trie... 25 Jan 2010 11:41

Sending subscriptions w/ PDFs to Blackberries
Has anyone else experienced an issue with the way SSRS 2005 sends PDF attachments to Blackberries in automated subscriptions? I am able to open the PDF if I save it and resend it from Outlook, but not directly from the SSRS email. ... 25 Jan 2010 09:26

Export to Excel problem (drill through)
I have a report that is driven by accounting periods. The columns are 1, 2, 3, Q1, 4, 5, 6, Q2...YTD. Currently when the report opens all that is shown is Q1, Q2, Q3, Q4, and YTD and the user can expand from there. When the user exports to excel they lose the column expansion for Q1-Q4. Can this be fixed. ... 23 Jan 2010 22:10

SELECT/INSERT statements via the RS utility
I'm trying to build a process that will copy reporting services reports using the rs utility. I'd like this process to be able to SELECT and INSERT records from a database. Does anyone have a sample of some code that will show how to issue a SELECT or INSERT statement via a RSS script passed to the RS utility... 23 Jan 2010 02:18