sql server reporting services: Usage of Ceiling(RowNumber(Nothing)/15) -- sql server reporting services

Usage of Ceiling(RowNumber(Nothing)/15)

SDRoy
3/7/2006 12:45:03 PM

sql server reporting services:

Hi:

I am showing 15 records/page on my report. The problem is when I export it
to excel from SQL report, I get 10 sheets on my workbook for the 15*10=150
records. Is there any way to avoid 10 sheets and have the export in a single
sheet ?

Thanks in advance.

RE: Usage of Ceiling(RowNumber(Nothing)/15)

Amarnath
3/8/2006 2:37:21 AM

Hi,

Instead of RowNumber(Nothing) give it as RowNumber("Group_name") (replace
group_name with your groupname in quotes since it accepts string)

It will works !!

Amarnath

[quoted text, click to view]

RE: Usage of Ceiling(RowNumber(Nothing)/15)

Amarnath
3/8/2006 2:38:02 AM

RE: Usage of Ceiling(RowNumber(Nothing)/15)

Amarnath
3/8/2006 2:46:31 AM

Sorry Please ignore my posting.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.