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.
LVL 1
jsctechyAsked:
Who is Participating?
 
Éric MoreauSenior .Net ConsultantCommented:
or add a column and fill it with the username. crystal can then filter on this column.

another option would be to pass a dataset to CR instead of having it connecting to the database. see http://www.emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx
0
 
mlmccCommented:
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
0
 
jsctechyAuthor Commented:
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?
0
 
mlmccCommented:
That or somehow add something to the temp table name so each user gets his own table.

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.