Picture formats a string based on the supplied
formatting "mask" string. This function reformats a string value,
inserting literal characters supplied within the "mask" formatting string.
Picture is helpful for adding characters to an existing string, such as
parenthesis and hyphens, to string database telephone numbers without
punctuation.
Picture (s1, s2)
s1 - source string to format
s2 - string "mask" to base formatting on.
Any occurrence of an "x" character in the mask will substitute a single
character from the source string. Any character other than "x" will simply
be added to the output string.
Picture("8007733472", "Phone:
(xxx) xxx-xxxx")
Returns
"Phone: (800) 773-3472".
... you can see your
SQL Query
Crystal Reports provides a menu option to view what
is being sent to the database. Follow these steps to use this option.
1. Open or create a report based on a SQL database, ODBC data source,
or OLE DB data source (you can not see a SQL query for other types of
reports).
2. Choose Database | Show SQL Query from the pull-down menus. You may
be asked to log on to the database or respond to parameter prompts. Do so
if prompted.
3. The SQL query will appear in its own dialog box. If you need to
discuss the query with your database administrator you may copy and paste
the SQL query from this dialog box to another application.
Tips and
tricks came to The Repository from Crystal
Reports Professional Results , Ablaze Group consultants, and you,
our readers. You can win a copy of Crystal Reports Professional
Results or Crystal Reports: The Complete Reference and see YOUR
name here. How? Just submit your favorite Crystal tip, trick or technique.
If it's selected you'll see it and your name in the next release of The
Repository and we'll send you a copy of either Crystal Reports
Professional Results or Crystal Reports: The Complete
Reference.
Crystal Reports
Professional Results - fast lane to sophisticated
developing.
George Peck's Crystal Reports
Professional Results gets you up to speed on high-end methods.
Transform your reports from ordinary to outstanding. At less than $30US,
this little book guarantees big results.
Learn more.
Crystal Enterprise 9
Professional FREE
Get CE 9 Professional FREE -
you have until December 15th, 2003. Visit Crystal Decisions' web site for your free
evaluation copy of Crystal Enterprise 9 Professional (five-user license).
Install it, work with it. The Ablaze Group knows Crystal Enterprise and
we're Crystal Value Added Resellers. Call on us to help you get exactly
what you need and show you how to get the most out of your investment.
Call or email
for details on Crystal Enterprise 9 Professional.
Learn more.
Crystal Decisions
Discontinues Crystal Info.
Support on most versions of
Info ends December 31, 2003. That reliable workhorse, Crystal Info (formerly known as Seagate
Info), is being put to pasture. Crystal Decisions will not be supporting
most versions of Info. But, The Ablaze Group still knows Info, however,
and can provide continued support if you need it. Or, if you want to
finally move to Crystal Enterprise, we're ready to help you with the
migration. Please call or email
for details.
Learn more about the discontinuation of Crystal(Seagate)
Info. Scroll down
the product lifecycle table to Crystal Info.
Crystal Reports Boot Camp 2003: Mission
Accomplished.
They Came, They Learned, They
Conquered. Crystal
Reports Boot Camp 2003 (October 6th - 10th) at the Keystone Resort and
Conference Center. Following are excerpts from evaluation forms filled out
by attendees:
"Far exceeded my expectations. Instructors were extremely knowledgeable
and approachable". - Debi
"A unique opportunity to select classes that applied to you". - Dave
"It was wonderful...." - Paul
"George and Jen were GREAT!" - Anthony
"This was the best food for a conference". - Kevin
The
Ablaze Group Offers Customized Onsite Courses
Welcome to our newsletter!
