Monday, September 11, 2006

Sept 2006 Articles

1. Adding Color to your Crystal Reports

One of the more requested features in Crystal Reports is color. The user wants to create conditional formulas in the report and show it in different colors. The easiest way to do this is to add conditional formulas in the Detail section. To do this, go to Insert>Section> Make sure you’re on the Details section then choose the Color tab. Mark the Background Color field then open Formula Editor. Once in Formula Editor is open you can create formula for you color, example shown below:

If {SOP10200.XTNDPRCE} > 1000 then RED else NOCOLOR

2. Using SQL Stored Procedures in Crystal Reports

This is a common question from the community. Yes, it is possible to use SQL Stored Procedures in Crystal Reports. To do this go to File>Options then go to the Database tab and mark Stored Procedures. Try to add a new table and you’ll see in your current database connection that both Tables and Stored Procedures would be available.

23 comments:

Anonymous said...

MESSAGE

Anonymous said...

MESSAGE

Anonymous said...

Appreciating the dedication you put into your site and
in depth information you provide. It's great to come across a blog every once in a while that isn't the same
old rehashed information. Fantastic read!
I've bookmarked your site and I'm adding your RSS feeds to my Google account.


Here is my page - wordpress handbuch pdf
Also see my web site - wordpress help chat

Anonymous said...

I am regular visitor, how are you everybody? This article posted at this web page
is in fact pleasant.

Feel free to surf to my web blog ... atkin diät

Anonymous said...

Thanks for sharing your thoughts on paleo de. Regards

my weblog; sonnencreme gefährlich

Anonymous said...

naturally like your web-site but you have to check the spelling on quite a few of
your posts. Many of them are rife with spelling problems and
I to find it very troublesome to inform the reality however I will certainly come back again.


Here is my web-site - Vermögensberatung in Mainz

Anonymous said...

It's great that you are getting ideas from this article as well as from our dialogue made at this time.

Also visit my page :: wordpress grundkurs

Anonymous said...

Hi there, just wanted to tell you, I enjoyed this article.
It was inspiring. Keep on posting!

Here is my homepage ... einführung wordpress deutsch

Anonymous said...

Fantastic website you have here but I was wondering if you knew of any community forums that cover the same topics
talked about here? I'd really love to be a part of community where I can get feed-back from other knowledgeable individuals that share the same interest. If you have any recommendations, please let me know. Thanks a lot!

Here is my web page - erfolgreich schnell abnehmen

Anonymous said...

Wonderful site. Lots of helpful info here.

I am sending it to several pals ans also sharing in delicious.
And naturally, thanks for your effort!

My webpage :: kostenlose rezepte ohne gluten
my website - glutenfreie Ernährung

Anonymous said...

Hi there! This blog post couldn't be written much better! Looking at this article reminds me of my previous roommate! He continually kept talking about this. I'll send this post to him.
Pretty sure he'll have a very good read. Many thanks for sharing!

My website - altersvorsorge immobilien

Anonymous said...

If some one needs expert view on the topic of running a
blog after that i recommend him/her to pay a visit this blog, Keep up the fastidious work.



My web-site: wordpress handbuch
Also see my site :: wordpress themes business

Anonymous said...

My partner and I stumbled over here by a different web page and thought
I might check things out. I like what I see so i am just following you.

Look forward to finding out about your web page
yet again.

Feel free to visit my homepage ... miracle noodle

Anonymous said...

If you're in a job that requires you to work with your hands, it's a good
idea to remove your diamond wedding ring while working.
Sources: Amanda Greene, "With this ring, I thee shed. And this is what is being done by using Promise Rings.

Here is my site - web site

Anonymous said...

are usually mens tungsten rings plain looking gold
rings with a shiny finish or more recently, platinum or white gold type rings.

1 solution to reveal to if a cameo is molded is to glimpse to get a roundness in
the detail and also a lack of sharp and precise strains.
Silver rings are something of a craze among the couples because
they are relatively cheaper than other metals.

Have a look at my web blog :: promise ring 30 degrees everywhere

Anonymous said...

Clearly he must already have been a person of means with connections in high
places since the King of England is supposed to have intervened and secured his
release. They will provide the best possible ideas and solutions to all of your queries and questions.
Sterling silver promise rings are also available for couples on a budget, and they still look amazing as
a true symbol of your love.

Have a look at my page: web page

Anonymous said...

The advantage to using this rather than a
normal soap to wash see your face is it is unlikely to aggravate the acne or your skin layer.
The best time to utilize this resource is a night, just before being to
sleep. After you rub your face by utilizing a towel, take care and insure which it is tenderly.
The worst portion of all is this scarring may bother you
for more than a couple of weeks.

Feel free to surf to my webpage; tretinoin 0.05 acne

Anonymous said...

The much larger the pearl, the rarer they are really
and the much more high priced. Sources: Amanda Greene, "With this ring, I thee shed. Some of those good reasons involve: loved ones beliefs, individual beliefs, desire to avoid the hazards of STDs and pregnancy.

my page; promise rings under $50.00

Anonymous said...

It is typically helpful to set your video camera in stain
focus mode. Other forms of Christian jewelry can serve as alternatives to the a ring.
Big and chunky beaded necklaces are still the emphasis
of this summer time.

Here is my page :: promise rings ben bridge

Anonymous said...

You will need to work out for only 30 minutes at a time and you can do it several
times during the day but don't over do the routines. Essentially, when the body's
metabolism is enhanced, the body is able to utilize stored fat cells for energy.
It is required for an individual if the site is gaining
popularity at a fast rate. If ever there was an app that was made
for our time, it is Gas - Buddy.

Also visit my page: best fat burning foods

Anonymous said...

It allows both parities involved, who are not ready to make a real commitment, to make a lesser commitment.

Two colleges exist at the exact same time: organic earth
tone beads and colorful and exciting tone beads.
Promise rings can be a wonderful gift for your partner.

Check out my webpage promise rings tiffany evans

Anonymous said...

Also take into account the type of ring you are looking for.
You must start shopping for your rings at least two to three months before the D day.
For engraving ideas for birthstone and pre engagement promise rings, you
could start with what prompted the giving of engraved promise rings.


Feel free to visit my website promise rings 14k white gold

Anonymous said...

Promise rings are very powerful symbols of respect, love, and friendship.
Being in a relationship, a girl is always curious when it comes to her
future with her significant other. After
the removal of the pornographic application known as "Hottest Girls" (designed by
app developer Allen Leung) for the increasingly popular Apple i - Phone, it seems the multinational consumer electronics giant is seeking to clear its
name of any connection to sexually explicit material.

My web blog promise rings 10k white gold

e-Commerce discount types

In the world of retail today every retailer is trying to find ways and be creative to attract online customers. To attract your attention an...