how to set the crystal report data source location

gbilios · June 10th, 2006, 08:53 AM

I solved the problem. i included in my msi installer file the redistributable x86 merge module. the reports work fine.

stingrae · June 21st, 2006, 06:30 PM

Quote:

quote:
i included in my msi installer file the redistributable x86 merge module

Sorry, but can you please specify the file name? :)

cheers

dextergaisie · May 14th, 2007, 10:38 AM

HELLO,

HELLO I NEED HELP ON HOW TO SEARCH FOR NUMBER OF TIMES A PARTICULAR WORD IS WITHIN A DATA BASE TO HELP ME MAKE STATISTICS.

AGAIN I NEED YOUR HELP ON HOW TO USE THE MSCHART TO MAKE BAR GRAPH LINKING IT TO THE DATABASE CONTROL.

AND LASTLY AM USING THE DATABSE OCX AND I WANT TO HOW TO SEARCH FOR A PARTICULAR RECORD THAT WOULD LOAD INTO THE REST OF THE FIELDS THE REST OF THE DATA.HOPE YOU UNDERSTAND WHAT I MEAN.
I NEED YOUR HELP AND WOULD BE VERY GRATEFUL IF YOU COULD HELP ME OUT.

GreenDean · September 22nd, 2010, 05:16 PM

Quote:

Originally Posted by Raghavendra_Mudugal

Yes it can be.
IF I UNDERSTOOD YOU properly, (you are asking, if data to the report is comming
from one SQL SERVER and you need the same report but the data from the differnt
SQL SERVER without modifing the REPORT)

If yes then it can be done.

Use
ConnectionInfo();
TableLogOnInfo();
SetDatabaseLogon(DBUserName, DBUserPassword, DBServerName, DBName);

to change the data source location of the report.

DBUserName, DBUserPassword, DBServerName, DBName
all are entries in the web.congif file. change the value of the key
and you are done to get the data from the new location.

Hope this helps

With Regards,
Raghavendra Mudugal

I'm a very new CR user, trying to make a current report use the data from a different SQL database and not having much luck. If I were to use the entries you note above, where would I actually put them?