Telling a Crystal Report to use another database 
Author Message
 Telling a Crystal Report to use another database

Hi all,
I'm developing CRW6.0 reports which feed on a Sybase 5.5.04 database. These
reports are accessed by a VC++ application.

What we are tryin to do is allow the user of our VC++ application
to create a report from a choice of two databases. That is the
user would be allowed to report on the database he chooses.

So, how can I tell my Crystal Report to use a different database
when I receive the database choice of the user?


Thanks in advance for any suggestions
Tejonath Kasturi



Fri, 17 Nov 2000 03:00:00 GMT  
 Telling a Crystal Report to use another database

Hi Tejonath,

Take a look at the 'LogonServer' and 'SetNthTableInfo' API calls.  Just
remember to have the tables defined in both databases.

Cheers,

--George

Quote:

>Hi all,
>I'm developing CRW6.0 reports which feed on a Sybase 5.5.04 database. These
>reports are accessed by a VC++ application.

>What we are tryin to do is allow the user of our VC++ application
>to create a report from a choice of two databases. That is the
>user would be allowed to report on the database he chooses.

>So, how can I tell my crystal report to use a different database
>when I receive the database choice of the user?


>Thanks in advance for any suggestions
>Tejonath Kasturi



Fri, 17 Nov 2000 03:00:00 GMT  
 Telling a Crystal Report to use another database

Thank you very much George..
It is very helpful information. The funcs. let me do what I exactly wanted
to..I never heard about these functions before...
Where do you guys find 'em? Is there some documentation
I'm missing? I only have a CRW5.0 User's Guide which
doesn't tell anything about such cool stuff.. Is there some online
function treasure which I can look into?

Thanks again
Tejonath

Quote:

>Hi Tejonath,

>Take a look at the 'LogonServer' and 'SetNthTableInfo' API calls.  Just
>remember to have the tables defined in both databases.

>Cheers,

>--George


>>Hi all,
>>I'm developing CRW6.0 reports which feed on a Sybase 5.5.04 database.
These
>>reports are accessed by a VC++ application.

>>What we are tryin to do is allow the user of our VC++ application
>>to create a report from a choice of two databases. That is the
>>user would be allowed to report on the database he chooses.

>>So, how can I tell my crystal report to use a different database
>>when I receive the database choice of the user?


>>Thanks in advance for any suggestions
>>Tejonath Kasturi



Fri, 17 Nov 2000 03:00:00 GMT  
 Telling a Crystal Report to use another database

You can find this doc in the .pdf document in the CRW main directory

Paul

Quote:

>Thank you very much George..
>It is very helpful information. The funcs. let me do what I exactly wanted
>to..I never heard about these functions before...
>Where do you guys find 'em? Is there some documentation
>I'm missing? I only have a CRW5.0 User's Guide which
>doesn't tell anything about such cool stuff.. Is there some online
>function treasure which I can look into?



Sat, 18 Nov 2000 03:00:00 GMT  
 Telling a Crystal Report to use another database

Hi Tejonath,

I use CR6.0 Pro and that install includes a developer help file describing
the various API calls you can make.  I've also had to do something similar,
and that helps alot to.  *grin*  The link mentioned in Polo's reply helps
to.  :)  When you get a chance you should puruse the Seagate site and just
get a feel for what they have.  This groups also a good resource.  :)

Cheers,

--George

Quote:

>Thank you very much George..
>It is very helpful information. The funcs. let me do what I exactly wanted
>to..I never heard about these functions before...
>Where do you guys find 'em? Is there some documentation
>I'm missing? I only have a CRW5.0 User's Guide which
>doesn't tell anything about such cool stuff.. Is there some online
>function treasure which I can look into?

>Thanks again
>Tejonath


>>Hi Tejonath,

>>Take a look at the 'LogonServer' and 'SetNthTableInfo' API calls.  Just
>>remember to have the tables defined in both databases.

>>Cheers,

>>--George


>>>Hi all,
>>>I'm developing CRW6.0 reports which feed on a Sybase 5.5.04 database.
>These
>>>reports are accessed by a VC++ application.

>>>What we are tryin to do is allow the user of our VC++ application
>>>to create a report from a choice of two databases. That is the
>>>user would be allowed to report on the database he chooses.

>>>So, how can I tell my crystal report to use a different database
>>>when I receive the database choice of the user?


>>>Thanks in advance for any suggestions
>>>Tejonath Kasturi



Sat, 18 Nov 2000 03:00:00 GMT  
 
 [ 5 post ] 

 Relevant Pages 

1. Telling Crystal Reports where the database is???

2. Crystal Report Help Please or Tell me where to get Crystal Help

3. Changing a report that uses 1 database into a report using 2 databases

4. Using multiple databases with on Crystal Report

5. Connecting To Access Database Using Crystal Reports

6. Connecting To Access Database Using Crystal Reports

7. HOW TO RUN THE CRYSTAL REPORT USING THE ORACLE DATABASE

8. using crystal reports objectmodel and password protected Access database

9. Using Crystal Reports on Informix Database

10. Using Crystal Report Designer Component need to use mulitiple databases with same tables

11. Limitation of database size when using Crystal Report

12. Connecting To Access Database Using Crystal Reports

 

 
Powered by phpBB® Forum Software