Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Report-wide Find and Replace on Formulas Post Reply Post New Topic
Author Message
blueridge
Newbie
Newbie


Joined: 21 Nov 2006
Online Status: Offline
Posts: 7
Quote blueridge Replybullet Topic: Report-wide Find and Replace on Formulas
    Posted: 22 Jan 2007 at 1:18pm
Is it possible to do a report-wide Find and Replace on the formulas? Or is there a better way to do this:
I've got a report with about 60 formulas referencing a particular query. I need to duplicate this report and have the formulas reference a different query but with all the same column names. I'd basically like to F&R "{query1;" with "{query2;" in all the formulas.
 
Thanks,
Dan
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 22 Jan 2007 at 3:26pm
Unfortunately, I don't know that Crystal Reports has this functionality. Maybe someone else done something similar and can help out?
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
CrystalVimal
Newbie
Newbie
Avatar

Joined: 23 Jan 2007
Location: India
Online Status: Offline
Posts: 5
Quote CrystalVimal Replybullet Posted: 23 Jan 2007 at 5:52am
Hi Dan,
Using 'Set Datasource location' may be one option if you are changing the table or stored procedure in the duplicated report.
Pls can you elaborate what the 'query1' and 'query2' are ?
IP IP Logged
blueridge
Newbie
Newbie


Joined: 21 Nov 2006
Online Status: Offline
Posts: 7
Quote blueridge Replybullet Posted: 23 Jan 2007 at 9:24am
query1 and query2 are both stored procedures coming from MS SQL Server that return the same number and names of columns, but the two reports have slightly different format and criteria.
 
I tried the "Set Datasource Location" command -- and it worked great! I never noticed it before.
 
A find-and-replace would sure be nice, though...
 
Thanks!
 


Edited by blueridge - 23 Jan 2007 at 9:25am
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.031 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.