Link to home
Start Free TrialLog in
Avatar of jsctechy
jsctechyFlag for United States of America

asked on

how to create a Crystal report on the fly base on a datatable

hi there,
how can i create a crystal report on the fly base on a datatable it gets create once certain criterias are met?

thanks.
Avatar of Mike McCracken
Mike McCracken

Crystal doesn't work well on the fly.  Also depending on how you do this, it may require each user to have a copy of Crystal or at the very least a full runtime license.

Will the fields of the datatabs\le be known in advance so you could create the report?

Will the datatypes of the fields be known?

mlmcc
Avatar of jsctechy

ASKER

see thats the thing i'm creating a tmptable for this procedure but i dont know whats going to happend it two users are trying to create this table at the same time!

so that is the main reason to have the Crystal report on the fly.

when im creating my table i have these calls:
recordset.ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic
and
ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic

i guess this will lock the table while is been creating am i right?
That or somehow add something to the temp table name so each user gets his own table.

mlmcc
ASKER CERTIFIED SOLUTION
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial