Number of rows

Hello!

I try to figure out how to change the number of rows at each page, but I'm stuck.

I have no page break , but I get a number of pages when I view my report. Is there any way to set the number of rows shown at each page?

//Cissi

Checking out these two threads might help:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1028484&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=892738&SiteID=1

|||

It works up to about 30 rows at each page, but I don't want any page break at all.
The reason is that I use a report viewer which I have a link to from an asp page. In the report I have a "jump to url", which take a value back to the asp page. When I change page in the report and then jump to the url I get the head of the reportviewer with me like a frame back to the asp page. This only happens when I change page in the report before I jump to the url.

|||I solved the problem by changing the properties for the Report Viewer. I changed AsyncRendering to false. But I still dont know what to do with the row number.

Number of remain periods (Quarters, Months)

I will need to figure out how many remaining periods (remaining quarters, months) within a fiscal year. For example, today is still Jan, 07. So there will be 3 quarters remaining if my current member on time dimension is at quarter level. There will be 11 months remaining if my current member on time dimension is at month.

I need that numeric value in order to do some calculation.

How can I get that number?

Here's a sample Adventure Works query (only works below fiscal year level):

>>

with

Member [Measures].[YearEndCount] as

count({[Date].[Fiscal].NextMember:

ClosingPeriod([Date].[Fiscal].CurrentMember.Level,

Ancestor([Date].[Fiscal].CurrentMember,

[Date].[Fiscal].[Fiscal Year]))})

select {[Measures].[YearEndCount]} on 0,

Head(Descendants([Date].[Fiscal].[Fiscal Year].&[2003],

[Date].[Fiscal].[Fiscal Year], AFTER), 5) on 1

from [Adventure Works]

--

YearEndCount
H1 FY 2003 1
Q1 FY 2003 3
July 2002 11
July 1, 2002 364
July 2, 2002 363

>>