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 > july 2006 > threads for friday july 21

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

Cannot preview or print: Invalid Page Number error
Posted by C17 at 7/21/2006 5:29:26 PM
(This is a repost, under my correct subscriber ID.) I have a report that I think is not too complex (a matrix inside a list). With small datasets, all is well. But with large datasets (the threshold seems to be around 5500 rows, which should turn out to be about 25 printed pages), the report ...more >>

Matrix Sub-Totals
Posted by SG at 7/21/2006 2:48:06 PM
Hi, I have one column group and 2 columns (one Amount & other Text) under it in a matrix. I added subtotal to that column group and now Amount total appears fine but first TEXT value appears in total coloumn. I would like to hide the TEXT value appearing in Subtotal column. I sure there ar...more >>

empty cellset issue with mdx in reporting services 2005
Posted by msdnuser at 7/21/2006 2:39:02 PM
Hi all, I am using reporting services 2005 based on analysis services 2005 cubes datasource. I use oledb provider and connect to analysis services 9.0. I am writing an expression in dataset which will evaluate to mdx query during runtime. Now the issue is if the generated dynamic query cann...more >>

Filters
Posted by Joe at 7/21/2006 1:46:04 PM
A common question is on reports with parameters - is there some way to also display what the parameter values were for this given report? ...more >>

Restricting the # of rows displayed per page in table
Posted by venkat.oar NO[at]SPAM gmail.com at 7/21/2006 1:11:01 PM
Hello, Is there a way in SQL RS 2000 to restrict the # of rows in a table per page basis. for Eg: i have a query which returns abt 2000 rows, i want to display only 10 rows per page. Appreciate if some one can lookinto this and let me know . Thanks & Have a gr8 weekend!!... --Venkat...more >>

Hidden Subreport Executing Queries
Posted by fred_mumble NO[at]SPAM yahoo.com at 7/21/2006 11:56:10 AM
I'm currently developing a report in which the customer has requested a drill-down type of interface that starts at a regional level to a district level to a territory level and finally to the individual customers within the territory. The drill-down interface was easy to create by using Groups...more >>

Limit Dimension Parameter
Posted by DrBob at 7/21/2006 11:30:02 AM
Does anyone know how to limit a dimension used as a parmeter in rs2005? The technique used in rs2000 does not work. (INSTR function used within an expression). Thanks...more >>

Filtering data in groups
Posted by WaterGuy at 7/21/2006 10:00:01 AM
I have two tables, both date related, one table contains measurements, the other a list of changes in altitudes. Ex> Table 1 Date Alt 1/1/1980 3000 1/1/2005 3002 Table 2 Date Meas 1/1/1980 23 1/1/1985 24 1/1/2006 25 I am struggling getting a SELECT statement or group of stat...more >>



Interactive sort not working if sub report
Posted by chris at 7/21/2006 9:56:33 AM
Hi, I am having an issue that when a sub report that contains fields that are setup to do interactive sort only work if they are displayed as the parent report. If they are included as a sub report when trying to do a sort the page just posts back but comes back unsorted. Is there a work a...more >>

Report Manager Error - Object reference not set to an instance of an object.
Posted by GearĂ³id at 7/21/2006 8:30:21 AM
Hi, I can browse to my ReportServer without a problem. But when I try to browse to the Report Manager I get the following error - Object reference not set to an instance of an object. I checked the log file and I'm seeing the following (snippet) Object reference not set to an instance of...more >>

Reporting services when printing a multiple page doc on single sheets
Posted by Fung at 7/21/2006 12:00:00 AM
Reporting services when printing a multiple page doc on single sheets, the first page prints correctly, but the pages after start printing too low. how can i slove? i found out the printer doc below: ------------------------------------------ When printing a multiple page document on single s...more >>


DevelopmentNow Blog