Thanks everyone - your help is very appreciated, and, while I still cannot display the information I am after, I think our investigation has uncovered problems that are preventing me from getting to the information in question, and it is now up to our DBA to find the answers.
Again, thanks for...
It IS NOT a permissions issue - I can perform the query in QA using the same username and password I use to log on to the DB with Crystal.
Any other ideas? Is there some simple syntax I can place in the SQL expression that will return information (so I can test to see if ANYTHING will work)...
Thanks for the suggestion - I have one (hopefully) final question. Should @@SERVERNAME be the only thing entered into the SQL expression? I have tried this, and it does not display any information in the report when it is printed or displayed on screen (although it does not give me an error -...
Does anyone have any idea of the best way to AUTOMATICALLY have the name of the SQL server(s) that are providing data to a Crystal Report appear in the report footer of a report? I am using 8.5, and I cannot for the life of me find a Crystal or Basic Syntax statement that will accomplish this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.