I use it to by clicking on a single formula from the tree, then, right-click ~ find results to find it's reference from other formulas within the report.
Principle to observer from pragmattic programming: DRY (don't repeat yourself).
Showing posts with label Crystal Reports. Show all posts
Showing posts with label Crystal Reports. Show all posts
2009-06-17
DRY and Find Results(alt+r in CR Formula Editor)
When using the Crystal Reports formula editor -- you can use alt+r to bring up a cross reference of the formula within the report.
I use it to by clicking on a single formula from the tree, then, right-click ~ find results to find it's reference from other formulas within the report.
Principle to observer from pragmattic programming: DRY (don't repeat yourself).
I use it to by clicking on a single formula from the tree, then, right-click ~ find results to find it's reference from other formulas within the report.
Principle to observer from pragmattic programming: DRY (don't repeat yourself).
2009-05-05
SVN Renaming files...
Update, do it in the repo browser, than update again. Give a generic comment like 'Naming...interim checkin'
2009-03-28
Un-WYSIWYG...
Sometimes moving from spec-to-tool "smartness" gets in the way. For example, when I have a source spec that contains text to be ubiquitously applied in target item -- I'll copy directly from spec then paste across a web page or report. However, not just text but also font type & size is replaced--the target document taking on the format from the source MS-Word spec. My workaround: use the windows 'run' command as a tiny scratch pad & remove the "smartness" in transit.
1. Highlight text from spec and press ctrl-c(see example from MS-Word)
2. Press the Windows-key on keyboard+R (to bring up run command)
3. Paste text on clipboard into the run box by pressing ctrl-v, then press shift+home to highlight all of this text, then press ctrl-c again to copy the text back to the clipbard (at this point it has been 'sanitized' of font info)
4. ...then paste into web page or report(see example report tool)
Example (from MS-Word) - step 1:
Example (to report tool) ...steps 2-4:
Final note: If my change spans multiple lines -- I'll use notepad vs. the windows-run box.
1. Highlight text from spec and press ctrl-c(see example from MS-Word)
2. Press the Windows-key on keyboard+R (to bring up run command)
3. Paste text on clipboard into the run box by pressing ctrl-v, then press shift+home to highlight all of this text, then press ctrl-c again to copy the text back to the clipbard (at this point it has been 'sanitized' of font info)
4. ...then paste into web page or report(see example report tool)
Example (from MS-Word) - step 1:
Example (to report tool) ...steps 2-4:
Final note: If my change spans multiple lines -- I'll use notepad vs. the windows-run box.
2009-01-10
Review of [crun] The Crystal Reports Underground News - Volume 2009.01
The "[crun] The Crystal Reports Underground News - Volume 2009.01" came out recently.
Items I thought Usefull:
Using AutoComplete in Crystal Reports formulas
Shared Variables from a suppressed subreport
Items I thought Usefull:
Using AutoComplete in Crystal Reports formulas
Shared Variables from a suppressed subreport
2008-02-11
Making Making them work 'Dynamic Cascading Prompts' (CR 11.n):
It appears the default total list of values is quite low (1,000):
You may want to :
...apply CR_LOV_FIX.reg to your PC/Server, then, restart.
-or- if that's not what you wanted to to you may want to...
...apply CR_LOV_backout.reg to your PC/Server, then, restart.
No warranties expressed or implied.
Referencing items:
How can you increase the number of values in a dynamic parameter list?
http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do?cmd=displayKC&docType=kc&externalId=c2017238&sliceId=&dialogID=5046450&stateId=1%200%205042477
How to add, modify, or delete registry subkeys and values by using a registration entries (.reg) file
http://support.microsoft.com/kb/310516
It appears the default total list of values is quite low (1,000):
You may want to :
...apply CR_LOV_FIX.reg to your PC/Server, then, restart.
-or- if that's not what you wanted to to you may want to...
...apply CR_LOV_backout.reg to your PC/Server, then, restart.
No warranties expressed or implied.
Referencing items:
How can you increase the number of values in a dynamic parameter list?
http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do?cmd=displayKC&docType=kc&externalId=c2017238&sliceId=&dialogID=5046450&stateId=1%200%205042477
How to add, modify, or delete registry subkeys and values by using a registration entries (.reg) file
http://support.microsoft.com/kb/310516
2008-01-24
Crystal Reports~'text' (a.k.a. 'memo')~set text interpretation
When using 'text' fields in MS-SQL Server -- I wasn't always seeing the values. When I format/text interpretation choose HTML -- then they show up!
Subscribe to:
Posts (Atom)
