Solved

change data source in Crystal Reports

Posted on 2015-01-14
7
272 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
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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

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…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

791 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