Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Database Post Reply Post New Topic
Author Message
stefanovitch
Newbie
Newbie


Joined: 11 Oct 2011
Location: Belgium
Online Status: Offline
Posts: 2
Quote stefanovitch Replybullet Topic: Database
     Posted: 11 Oct 2011 at 11:27am
Hello
 
Is it possible to make a database from a crystal report that renews hisself.
 
Because i want to make a report and for that i first made a report with a lot of selection to becom a value.
that value i want to use with other value's.
When i put everything in one reports its to big to work.
 
So i want to create a database from the first report and then use this in my second report.
IP IP Logged
Robotacha
Groupie
Groupie
Avatar

Joined: 11 Nov 2009
Location: United Kingdom
Online Status: Offline
Posts: 97
Quote Robotacha Replybullet Posted: 11 Oct 2011 at 11:45pm
You can export your first report as EXCEL DATA ONLY (providing your alignment of columns is OK)
 
Then, save this file on a network drive or Local drive.
 
you can then create a new connection within crystal reports, and instead of using a database as your datasource, use the ACESS/EXCEL option and use your excel file as your datasource.
 
Just make sure this file always stays in the same place and it will be fine.
 
You can also add rows into this file as you would a normal table.
 
 
Im guessing this is what you mean.
 
If not, and you want 1 report to be the source data for another report AT THE SAME TIME as running the reports (dynamic), then you need to look into subreports.
Regards,

Michael Jones
IP IP Logged
Robotacha
Groupie
Groupie
Avatar

Joined: 11 Nov 2009
Location: United Kingdom
Online Status: Offline
Posts: 97
Quote Robotacha Replybullet Posted: 11 Oct 2011 at 11:49pm
If you need the source data (first report) to change daily/weekly/monthly etc,
simply set up the first report, have it scheduled to be ran and dumped into an excel file in a folder on a drive, then do the same as above.
 
only problem with this is you will need to identify a way of automatically overwriting the file, so that the filename stays the same.
(the security promt of "Are you sure you want to overwrite this file" is the problem here)
 
 
 
Regards,

Michael Jones
IP IP Logged
stefanovitch
Newbie
Newbie


Joined: 11 Oct 2011
Location: Belgium
Online Status: Offline
Posts: 2
Quote stefanovitch Replybullet Posted: 12 Oct 2011 at 9:33am

That would be a good solution.

But i have to find a way to run the first report auto every night. so the values are as reliable as possible
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.