If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Recordset match to Crystal Report

Re: Crystal Report

It was really a major relief to see someone helping out in Crystal Reports (cr). Otherwise, hardly anyone knows cr properly in the industry today. The help that cr gives alongwith the software is also not elaborate enough.

I am right now developing an accounts package using VB6 as frontend, Access as backend and Crystal Report 8.5 Report Designer Component.

The points for clarification are as below:-
(1) If i am putting a password in my access database, and then designing some reports using 'Report Designer Component', it gives the following error when I am using ADO connection string to connect to the database and clicking on Test Connection - "Test Connection failed because of an error in intializing provider. Cannot start your application. The workgroup information file is missing or opened exclusively by another user". The Access database was not open when doing this. Provider name and other details that i am giving are all correct. Any solutions for this? Or is it that, i cannot set a password for Access database if i want reports in cr?

(2) Since the software is going to be a multiuser application, do you forsee any problem while installation. One problem i found out was setting the path for reports. I am using .dsr files. What i am doing is setting the location as under :
Report.Database.Table(1).Name = "xzy" ' table name which matches with actual design.
Report.Database.Table(1).Location= App.Path & "\database.mdb"
Are there any other alternatives to this? If am am hard coding the query itself in the RDC, will the above codes run? What should i write as table name then, since the query user multiple joins? Also what to do in case if i am giving password for my database.

(3) Is cr really powerful than Data Report of VB? Many people have told me that there are several problems like setting the paper size etc. in Data Report. Apart from that are there any other problems?

Many Problems in Crystal Reports

It was really a major relief to see someone helping out in Crystal Reports (cr). Otherwise, hardly anyone knows cr properly in the industry today. The help that cr gives alongwith the software is also not elaborate enough.

I am right now developing an accounts package using VB6 as frontend, Access as backend and Crystal Report 8.5 Report Designer Component.

The points for clarification are as below:-
(1) If i am putting a password in my access database, and then designing some reports using 'Report Designer Component', it gives the following error when I am using ADO connection string to connect to the database and clicking on Test Connection - "Test Connection failed because of an error in intializing provider. Cannot start your application. The workgroup information file is missing or opened exclusively by another user". The Access database was not open when doing this. Provider name and other details that i am giving are all correct. Any solutions for this? Or is it that, i cannot set a password for Access database if i want reports in cr?

(2) Since the software is going to be a multiuser application, do you forsee any problem while installation. One problem i found out was setting the path for reports. I am using .dsr files. What i am doing is setting the location as under :
Report.Database.Table(1).Name = "xzy" ' table name which matches with actual design.
Report.Database.Table(1).Location= App.Path & "\database.mdb"
Are there any other alternatives to this? If am am hard coding the query itself in the RDC, will the above codes run? What should i write as table name then, since the query user multiple joins? Also what to do in case if i am giving password for my database.

(3) Is cr really powerful than Data Report of VB? Many people have told me that there are several problems like setting the paper size etc. in Data Report. Apart from that are there any other problems?

Great: you should write atricle

If you have time and will, you should write an article about Crystal Report usage: these are valuable informations for all of us. Mail to Brad Jones (the moderator), to know how to do.

Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood, TCartwright, Bruno Paris, Dr_Michael
and all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.

The Rater

...at present time, using mainly Net 4.0, Vs 2010

Special thanks to Lothar "the Great" Haensler, Chris Eastwood , dr_Michael, ClearCode, Iouri and
all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.

* The Perfect Platform for Game Developers: Android
Developing rich, high performance Android games from the ground up is a daunting task. Intel has provided Android developers with a number of tools that can be leveraged by Android game developers.

* The Best Reasons to Target Windows 8
Learn some of the best reasons why you should seriously consider bringing your Android mobile development expertise to bear on the Windows 8 platform.