Hide Last Line 1

[bburnell]

Hi,

I am using SRS 2005 and would like to hide the last line if it is the last record of the dataset. Any suggestions?

Thanks!
Brett

--------------------------
My new website coming soon!

 

[paulkeys]

You could set the hidden property of the detail row of the table to the following expression;

=iif(CountRows()=RowNumber("YourScopeHere"),True,False)

which would hide the last row of the data e.g. if there are 10 rows of data, countrows() = 10, so for RowNumber = 10, the row would not be displayed (hidden=true)

 

[bburnell]

That worked great. Thanks!

An FYI to those who weren't sure what "YourScopeHere" should be, I put in the name of the dataset that the report data is generated from.

Thanks again!
Brett

--------------------------
My new website coming soon!

 

[bburnell]

Ok. How about for the very first record?
Brett

--------------------------
My new website coming soon!

 

[bburnell]

Nevermind. I figured it out.

=iif(RowNumber("YourScopeHere")=1,True,False)

Is there a site with a list of all of the possibilities and examples for formulas? SRS seems to have so little documentation and examples as compared to CR.

Brett

--------------------------
My new website coming soon!

 

[bburnell]

Is there any way to tell that you are at the top of a new page of data? I feel like such a newbie with SRS. Why didn't they just buy out CR?
Brett

--------------------------
My new website coming soon!

 

[paulkeys]

Not sure if there is a site with all these on to be honest - but i can recommend the wrox press books for reference.

Re. new page of data - do you mean first row in a new group, or new print page?

If group you could put something in the group header on the table - if print page, you could put something in the page header

hth

 

[bburnell]

I have a "line" on the top of a list (in the detail section). When the first record or new page is identified, it should print, otherwise it should be invisbile. Make sense?

Also, is there a way to make a second detail section like CR?

Thanks for the recommendation. I'll check it out. I'm really disappointed in the amount of documentation and tutorials available with SRS. I still don't see it being better than CR, but maybe in the future.

Thanks again!
Brett

--------------------------
My new website coming soon!

 

[paulkeys]

You can have multiple detail lines - right click on the detail line in the table and select insert rows below

Am not sure you can achieve what you're trying to do directly (it may be that you can, but i don't know how!).

A workaround may be to use groups, and force a new page for each group, with the line in the group header?

hth

 

[bburnell]

Good idea. Thanks!
Brett

--------------------------
My new website coming soon!