Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Creating Crystal Reports at Runtime
- Thread starter jbrowne
- Start date
Wow. It kind of begs the question why would you want to (perhaps have to) - but leaving that for now, what you can do is<br>
1) In Crystal, create a protoype report on a database<br>
2) Put a few formulas in it.<br>
3) Save it<br>
In VB (or some other language), you can change the database to anything you want, and change the contents of the formulas to anything you want, etc. Hence, you've got a generic report that can do simple things. Obviously, to get it to do more tricks, then your generic report will have to have groups (based on formulas that you can reset), and so on. The only trick is that all the "fields" on the report are formulas, so they can be changed. I would suggest you say to the person who wants this feature that it would take a lot of effort to get a result they would likely be only partly satisfied with. And because you wouldn't be able to save this report, every time you ran it, you would have to go through the same change process.<br>
<p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>
1) In Crystal, create a protoype report on a database<br>
2) Put a few formulas in it.<br>
3) Save it<br>
In VB (or some other language), you can change the database to anything you want, and change the contents of the formulas to anything you want, etc. Hence, you've got a generic report that can do simple things. Obviously, to get it to do more tricks, then your generic report will have to have groups (based on formulas that you can reset), and so on. The only trick is that all the "fields" on the report are formulas, so they can be changed. I would suggest you say to the person who wants this feature that it would take a lot of effort to get a result they would likely be only partly satisfied with. And because you wouldn't be able to save this report, every time you ran it, you would have to go through the same change process.<br>
<p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>
I'm with Malcolm,<br>
It's highly unlikely you will ever satisfy your clients needs and be aware these needs will almost certainly change.<br>
Why not get a copy of Crystal Analysis 7, do a database description and let your clients get on with it.<br>
<br>
BrianD
It's highly unlikely you will ever satisfy your clients needs and be aware these needs will almost certainly change.<br>
Why not get a copy of Crystal Analysis 7, do a database description and let your clients get on with it.<br>
<br>
BrianD
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question