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