Last Page of Group

Hello, i am new to this, but here it goes (only using Crystal about a week)

I am using Crystal XI,I have a financial report, grouped twice.
First by 'main account' then sub-account'.

The detail section contain transaction data. For every new main account a new page is started. My issue is is that occasionally the transactions will need more than one page, upto around 3 or 4, depending on the size of the account, and the number of sub-accounts (the sub account header takes up a lot of space)

I require specific information to be displayed on the last page of group one('end of coalation mark' for our OCR system), and i can't figure out how to determine what is the last page of a group by any means

can anyone help with this?Use formula and write this

if NextIsNull(filed) then
--last page

Last Name Only

I am fairly new to Crystal Reports and need some help with a report design. I am trying to extract just the Last Name from a field that contains both First and Last Name in one string.
Any help would be greatly appreciated.
Thanks,
Hanseleg. Create a formula and write this
stringVar sp;
sp:="Test1 test2";
mid(sp,instr(sp," ",1)+1,len(sp))

Large TempDB

Hi
I have many reports running from a SQL Server DB, from Crystal Enterprise
reporting system. However I have noticed some performance degradation, and
I noticed that my TempDB had ballooned in size. Is there a way to reset
this? I tried Shrink, but this did not reduce the size of the DB?
Kind Regards
Ricky
(SQL2K-SP3A/WIN2K-Client/WIN2K-Server/Crystal Enterprise 9.0)http://www.aspfaq.com/show.asp?id=2446
David Portas
SQL Server MVP
--
"rikesh patel" <trikky@.rukp28.freeserve.co.uk> wrote in message
news:ubgD8RnxFHA.3124@.TK2MSFTNGP12.phx.gbl...
> Hi
> I have many reports running from a SQL Server DB, from Crystal Enterprise
> reporting system. However I have noticed some performance degradation,
> and
> I noticed that my TempDB had ballooned in size. Is there a way to reset
> this? I tried Shrink, but this did not reduce the size of the DB?
> Kind Regards
> Ricky
> (SQL2K-SP3A/WIN2K-Client/WIN2K-Server/Crystal Enterprise 9.0)
>