Finding System Values

[muffntuf]

Hi, got a question for yall-

If I wanted to use CRXI to find the system values, how could I do that?

Thanks,
muffntuf

 

[GJParker]

What system ?
what values ?

Gary Parker
MIS Data Analyst
Manchester, England

 

[Madawc]

I assume you're asking about Crystal's own fields. On Crystal 10, Currentdate is one useful field. 'Special Fields' on the Field explorer has others.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[muffntuf]

database info

 

[synapsevampire]

There aren't any generic database fields available within Crystal.

State specifically what you want from what type of database and you might be able to return it using a SQL Expression or from within the Query/View/SP.

For instance select * from v$version will return a few rows of information about Oracle:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
CORE\t9.2.0.6.0\tProduction
TNS for Linux: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production

Please remember to include your database/connectivity information with your posts.

-k

 

[muffntuf]

Thanks Synapsevampire