Solved

Reimporting crystal subreports after copy to a different folder

Posted on 2009-07-09
4
589 Views
Last Modified: 2012-05-07
I have an environment where we are developing reports for our WM software and we have Test, Train and Production systems.  When we develop a report it is done in the test environment.  After approval we copy to the train environment and then change all the data sources to point to the train environment.  Once approved, then we do the same to get it into the Production environment.  This works great for all the main reports.  The problem comes with the subreports.  Since crystal embeds the subreport into the main report, when i copy it to the next environment and then try to reimport the subreport it will look to the test environment for the subreport and then the data source is wrong.  How do I modify the main report so it can find the subreport in the new environment?  I have found if I delete a subreport from the test location and then reimport it in the main report it will have me search for the subreport as it does not find it because it does not exist after getting deleted.  This is not a very good way to do this so I am looking for a better way.  Please let me know how others handle this type of scenario.
0
Comment
Question by:Jeff Geiselman
[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
  • 2
4 Comments
 
LVL 2

Accepted Solution

by:
vetaldj earned 250 total points
ID: 24814163
Why do you need to reimport them? You can update datasorces for subreports from main report in same way as you do for main report. Did you try this way?
And, based on what you wrote - if you need to make change, looks like you need to go each step anyway...
0
 
LVL 1

Author Comment

by:Jeff Geiselman
ID: 24814229
The reason is that I want the subreport file to reflect the correct data source and I don't really want to have to make the change in more than one place.  Also a subreport could change without the main report getting changed.  At this point then I need to reimport the subreport and it would be better to do that than to have to relink everything to the different environments just to get the subreport updated.
0
 
LVL 101

Assisted Solution

by:mlmcc
mlmcc earned 250 total points
ID: 24814544
You really can't get around the issue of when you change the report and having to reimport it.


I am assuming the enironments are separate and you can't see the subreport from Test in the Train environment.

Do you have the environments setup so the directory structures are the same?

You may be able to get around this by having the subreport in the same directory as the main report.  Thus it may be able to find it when you need to reimort it.

At the very least you will always have to change the data source for the subreport and the main report.

mlmcc
0
 
LVL 1

Author Closing Comment

by:Jeff Geiselman
ID: 31609228
This is what I thought all along, but I was hoping for a different answer.  Thanks for the input.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

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. …
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…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

636 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