Showing posts with label twice. Show all posts
Showing posts with label twice. Show all posts

Wednesday, March 21, 2012

Last repost: linked server local SQL login romote Windows login

I have posted this twice, no response. Anyone from the MS SQL Server team
or anyone else could give me an answer? Thanks.
Win2K, SQL Server2K.
Hi group,
can someone confirm me that this is not possible, or tell me how to do it?
For a local sql server login, the connectivity is to be established with the
remote login being a Windows login.
Thanks.
QuentinIf you mean local as in a non NT Authorisation then no.
If you mean local as in local NT User (non domain) then no.
If you mean a domain user id then yes, but you will need
to set up the remote computer.
J
>--Original Message--
>I have posted this twice, no response. Anyone from the
MS SQL Server team
>or anyone else could give me an answer? Thanks.
>Win2K, SQL Server2K.
>Hi group,
>can someone confirm me that this is not possible, or tell
me how to do it?
>For a local sql server login, the connectivity is to be
established with the
>remote login being a Windows login.
>Thanks.
>Quentin
>
>.
>|||Thanks.
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:2275701c45d2a$9c543370$a501280a@.phx.gbl...
> If you mean local as in a non NT Authorisation then no.
> If you mean local as in local NT User (non domain) then no.
> If you mean a domain user id then yes, but you will need
> to set up the remote computer.
> J
>
> >--Original Message--
> >I have posted this twice, no response. Anyone from the
> MS SQL Server team
> >or anyone else could give me an answer? Thanks.
> >
> >Win2K, SQL Server2K.
> >
> >Hi group,
> >
> >can someone confirm me that this is not possible, or tell
> me how to do it?
> >
> >For a local sql server login, the connectivity is to be
> established with the
> >remote login being a Windows login.
> >
> >Thanks.
> >
> >Quentin
> >
> >
> >
> >.
> >

Monday, March 19, 2012

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