Solved

change data source in Crystal Reports

Posted on 2015-01-14
7
264 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
  • 3
  • 2
  • 2
7 Comments
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
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
Comment Utility
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
Comment Utility
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 100

Accepted Solution

by:
mlmcc earned 250 total points
Comment Utility
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
Comment Utility
Can you upload the report ?
0
 
LVL 7

Author Comment

by:valmatic
Comment Utility
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
Comment Utility
splitting the points...  thanks
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

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…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

743 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now