Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Reimporting crystal subreports after copy to a different folder

Posted on 2009-07-09
4
Medium Priority
?
610 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
  • 2
4 Comments
 
LVL 2

Accepted Solution

by:
vetaldj earned 1000 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 1000 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

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…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

783 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