Avatar of rporter45
rporter45
 asked on

Redirect Crystal Report Data Mapping

I'm curious if anyone has "tricked" a Crystal report into believing that the data source is in a different location.  For example; my system where I would write the report is c:/data./file.mdb but on someone else's system their data is housed on f:/their_files/file.mdb - it's an odd question I know but we are having to respond to this scenario. 


Thoughts?

thanks in advance - 


CS




Crystal Reports

Avatar of undefined
Last Comment
Mike McCracken

8/22/2022 - Mon
Mike McCracken

How do you run the reports?

Crystal does not have a command line capability.

One way that seems to work is to run Crystal from a batch file and copy their data file to a known location

I works with Excel files but might no with Access.

Do the Access files have passwords?

Mike McCracken

This is the batch file I used

copy %1 C:\Reports\report.xls
"C:\Program Files (x86)\Business Objects\Crystal Reports 11.5\crw32.exe" C:\Reports\TestReport.rpt

Run it from the command screen
CRRUN C:\mydata\mydata.xls
rporter45

ASKER
Good morning -

The rpt and mdb files are on a hosted file location.

The software provider that is being used allowed the user to create the report and map the data source within the software which would allow for correct mapping.

Now, they have announces that they will no longer support this and allow users to do this.  So - I have to create the report on my local machine and transfer that report to the hosted environment and somehow have to identify the data source in the report so that we do not receive an error.  Change the data source location from my pc to the hosted site.  But, I cannot map to that hosted site.  

There aren't any passwords on the mdb files -
Your comments are appreciated - It gives me some new ideas.
Thanks - CS
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ASKER CERTIFIED SOLUTION
Mike McCracken

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question