Search:

I am trying to deploy a VB6 app that uses Access97 db and Crystal reports. I have used the P&D wizard successfully for the application, but I do not know how to include the database and reports with...

Babu,
My VB6 program uses CRE8 for reporting. I just upgraded to Crystal 9. Do you know of any easy ways to migrate to RAS from RDC?

Regards,
SB

Babu,
My VB program uses CRE8 for reporting. I just upgraded to Crystal 9. Do you know of any easy ways to migrate to RAS from RDC?

Regards,
SB

Is it possible to password protect reports?

- If so, how do you run them from VB with the password?

- If not, how do you keep the integrity of the reports after they are distributed to users?...

Babu,
Never mind my question - I figured it out. Just in case you were interested this seems to work:

crpReport.Database.Tables(1).SetSessionInfo "", Chr(10) & "password"


SB

Hi Babu,
Do you know how to connect to an Access 97 db with db level password using the Crystal RDC?

I am able to connect for other Crystal reports using just the CrystalReport viewer.

Any...

Hi
I am having the same problems as stated in Cristiane's post.

Any suggestions.

Thanks,
SB

Hi Babu,
I tried your suggestion and I still get the same error. The report will work on my machine as the db location is the same as when I set up the report / subreport in Crystal.

I wanted...

Hi,
I tried your code:

CrystalReport1.DataFiles(0) = gDataBaseName
CrystalReport1.DataFiles(1) = gDataBaseName 'It is the same DB as the Main Report

I get the following error:
...

Hi,
In VB, how do you specify the datasource for a subreport in Crystal?

For example, I use the following code to specify the datasource for the Crystal report:
CrystalReport1.DataFiles(0) =...

Adding the Menu was quite simple. And I found plenty of online help searching on Menu Editor. Thanks for pointing me in the right direction.

Thanks - I'll give it a try!

Hello,
I am still learning VB (I will be saying that for years).

I am developing a standard exe application as a front end to an Access database. Can anyone provide a simple overview on how to...

Thanks for the input. I initially intended to only use DAO for this application since it is a single user, MS Access DB. I just started to learn ADO and wanted to try it out, so I wrote some code...

I am developing a VB standard exe front end to an Access database. On one of my forms I import data from txt and Excel files. I need to validate the data in these records before loading into the...

Thanks Jeff B - this works great!

:)

I came across this thread in a search. I also need to append several text files into one text file. This codes works very well.

My questions:
- Instead of hardcoding the filenames, how do I...

K.Babu,
Your solution (using 'formula' fields) works for passing values to show in the crystal report. How do I pass values to represent the 'parameter' fields that the report is using in the...

Never mind Ice -
I figured it out.

SB

Iceman,
I'm sorry you didn't get the responses you were looking for (or any for that matter). I just started using the CodeGuru and have found it useful at times.
I would be interested in seeing...

Hello,
Yes I was able to solve my problem. Thanks for your advice. I 'm sure to have more questions in the near future.

I have been using Crystal for a reporting tool for a few years. But I...

Hello there.
I have a crystal report with several parameters. I want to pass a value to one of the paramters (or at least set the default value) but let the user enter the other parameters.

Any...