on 08-02-2011 3:18 PM
NO MATTER WHAT COMPANY I PICK THE REPORT ONLY RETURNS DATA FROM THE COMPANY DB I USED TO CREATE THE REPORT
I defined the OLE/DB WITH SQL SERVER NATIVE CLIENT AS INSTRUCTED
I have 8 identical DBS WITH THE NEED TO RUN THE EXACT SAME REPORTS
I HAVE DESIGNED THE MOST SIMPLE REPORT FROM SCRATCH
a summary that gets all its data from A SINGLE SQL SERVER Stored Procedure
The SetDatabaseLogon method passes the username and password to the connection in the report with the corresponding server and database name, it does not change the database or server name.
You will want to look at [this sample |http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a0b05250-df37-2c10-2cba-a99b69e89ae8]on how to change the connection.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
A word of advice when trying to get help, don't constantly yell (all caps) in your posts/questions.
People tend to not want to assist when you do that.
Also, try checking out the rules of engagement [here|http://wiki.sdn.sap.com/wiki/display/HOME/RulesofEngagement] before posting. It covers posting words in all caps and various other issues when posting.
Good luck.
This is a TOY [period]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.