I have a report with many dozen running total fields that I need to edit to "Reset on change of group." Is there a way to modify all of these at once, or am I going to have to edit each one individually?
I have been considering playing with AutoIt and I would be interested in seeing the script you used.
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks
Do
send("{APPSKEY}")
sleep(1000)
Send("E")
sleep(1000)
Send("!p")
sleep(1000)
Send("{ENTER}")
sleep(1000)
Send("{DOWN}")
sleep(1000)
$count = $count + 1
Until $count > 200 ;;; fill in the number of RTs you need to edit.
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
So I basically run this script and then switch over to my already open Crystal Reports app by clicking on the first RT that I want to edit. The script automatically performs a "right-click," selects Edit, selects "On change of group" under the Reset section, sends an Enter command, and then moves down to the next RT where it performs the same steps again...until it reaches the end of the counter.
I'm sure there's a better way to do it, but having never used AutoIT before, I found this to be the quickest way for me.
It took me a while to get the meaning of !p, because I didn't know that there were 'Alt' options in the running totals dialogue. It appears that CR has decided to hide the 'Alt' key underlines for most dialogue windows, unless you hit the 'Alt' key. I now see that this same pattern is followed in most CR dialogues. Knowig that there are 'Alt' keys in these dialogues is great for someone likes me who hates to reach for a mouse when my hands are already on the keyboard.
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.