I had a crystal report assigment that requires me to work with MaxDB.

And i keep getting this error:

invalid authorization specification;-4008 POS(1) unknown user name/password combination

the fix is to capitalise the password. Or if that doesn’t work, capitalise the username as well.

Order by cant be used in subquery

To create a dynamic grouping in crystal report:

1. you’ll need to create a formula to determine the groups
2. Add the formula to the group expert

But if you find the formula that you’ve created doesn’t show in the group expert, just add

When you try to access the stored procedure that you created from Database Expert in Crystal Report, you’ll discover that your stored procedure doesn’t appear in the list. In order to make it appear you must grant Crystal Report the permission to execute.