About stephenstuntz

stephenstuntz

I have a complex report that uses a table name. I would like to turn the table name into a parameter that gets passed to the report from a vb.net call. the idea being to change AttendRpt to AttendrptYYYY where the new table name is passed to the repo...

change table for different users

I have four users who use the same table for a report. the user name is name1, name2, etc. and the table is table1, table2 etc. where tables are identical. Can I have one report that references table and then change the table name at logon when I run...

stephenstuntz

I am running a crystal report using the viewer from vbnet (framework 4.0) and reports without record selection run as expected. If I add a record selection such as JobNum > 4000 to the report the report generates and database error code 17 which I...

stephenstuntz

the tutorial on Adding Ability to Change Database Location at Runtime saysIn this tutorial you will change the name of the Database server, not the name of the Database. It is not possible to change the name of the Database with the CrystalReportV...

stephenstuntz

We have a Crystal 8 report that runs off a Microsoft Access database in 26 seconds. the same report on the same data runs in 3minutes and 20 seconds in Crystal X1 R(2). clearly i have set something up wrong. what should i look for?

stephenstuntz

plugging along with it. next questions:should I use drag and drop or copy and paste special?can I do that to more than one object at a time?

stephenstuntz

here is potential sql changeold waySELECT "attend_rpt"."screen_nam", "attend_rpt"."contract_key", "attend_rpt"."unit_tot", "attend_rpt"."dol_Tot", "attend_rpt"."unit_rate", "attend_rpt"."invoice_date", "attend_rpt"."invoice", "attend_rpt"."slot_num",...

stephenstuntz

I have tried various means and I am getting nowhere. it maybe that the customer is using crystal 2011 for sage. but anyway a further question - is it possible to directly edit the SQL statement. I can view it from database show sql so if I put the...

Re: change table for different users

I think I can send the table names as parameters which should work.

stephenstuntz

Thanks for all that information. i was logging on because i need to change the database location from code and not on each report. having gotten this far i feel the question is answered. i will be able to deal with the change data base from the stu...

User Statistics

User Activity

changing a table name to a parameter that is passed to report

change table for different users

Report taking too long to generate

crviewer and changing database

Crystall 11r(2) slow with Microsoft Access

Re: changing a table name to a parameter that is passed to report

Re: changing a table name to a parameter that is passed to report

Re: changing a table name to a parameter that is passed to report

Re: change table for different users

Re: Report taking too long to generate