Solved

change data source in Crystal Reports

Posted on 2015-01-14
7
273 Views
Last Modified: 2015-01-15
I'm new to using Crystal Reports so I'm sort of feeling my way through the product.  I had an old report that I needed to tie into a separate data source.  I copied the crystal report definition and changed the data source on the copy to my new database by clicking on the old source and the new source and selecting Update.  The name of the original source table did not change but the properties of the source reflects my new source location.  I included a screenshot of what I changed.

The new report opens fine manually and shows data from my new data source but I'm using a 3rd party application called Logicity to schedule the report to run each day, convert to PDF and save to a network file location.   When Logicity tries to open the report, it makes reference to the original data source name and can't find it so issues the error - also in the screen shot.

My question is:  Am I changing my data source correctly?  Is there a better way to change the data source on this report?  I'm guessing the 3rd party app is confused because my source name still says VMI_WC_PRIO when my actual source is V_WC_PRIO_RWOforPURCH_JF.  

Doc1.pdf
thanks
0
Comment
Question by:valmatic
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 40549681
I think you have to select the database name in both places then update.

mlmcc
0
 
LVL 18

Assisted Solution

by:vasto
vasto earned 250 total points
ID: 40549755
I agree. As far as I know Logicity supports one datasource per report and will use the one on top of your table.
If you update the database instead of the table you will have one datasource  ( the correct one) and Logicity will be able to use it. If you update the table datasource there will be 2 report datasource, one on the database level pointing to the old database and one on the table level pointing to the new database. Logicity will use the first one.
0
 
LVL 7

Author Comment

by:valmatic
ID: 40550098
Thanks for the responses.  My screenshot just shows the results of what I did.  I actually tried to update at the table level by selecting the table in the top pane and the table (view) i wanted to change it to in the bottom pane and that left me with the mixed bag I have.  The problem is that both the old table and my new view exist in the same database.  Is there a way to make the report read the new view.  The original is a table and the view I'm trying to replace it with both have identical fields.  The view just has some exclusions built in.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 100

Accepted Solution

by:
mlmcc earned 250 total points
ID: 40550151
It did seem to update it at the table level.

Did you reschedule the report after making the change?
Some schedulers read the report in and continue to use the "old" version information like database name and tables until it is rescheduled.

mlmcc
0
 
LVL 18

Expert Comment

by:vasto
ID: 40550248
Can you upload the report ?
0
 
LVL 7

Author Comment

by:valmatic
ID: 40551433
mlmcc, your thought to reschedule made me try something on a hunch.  
Originally, I copied an existing rrd file and then opened with Logicity and made the changes I wanted to the copy.  Turns out Logicity doesn't like this.  I recreated the Logicity file from scratch and now it executes fine.  Somethign to keep in mind...

thanks for the help, both of you.  :)
0
 
LVL 7

Author Closing Comment

by:valmatic
ID: 40551439
splitting the points...  thanks
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question