Showing posts with label using. Show all posts
Showing posts with label using. Show all posts

Wednesday, December 22, 2010

How to create a Radar animation using Xcelsius?

Visit www.sapdiary.com

Monday, December 6, 2010

Crystal Reports: Using the Highlighting Expert

Have you ever used the Highlighting Expert in Crystal Reports? Chances are your response is no, and you are wondering what it is. The Highlighting Expert is a button on the Experts Toolbar. The button looks like this: .

The Highlighting Expert is also on the shortcut menu of the right-click. Once you choose this Expert, this dialog box opens:

Click on the New button in bottom left corner.On the right, choose the Operator for the criteria and the amount you want to highlight.Now you can change the color of the Font, the Background, and/or the Border.You can Add as many Highlights as you wish with various values, with the New button.You are able to see how it will look in the Sample area.You are able to change the Priority by selecting and using the little arrows to reorder.To remove a highlight, simply select on the left and click Remove.

Try it out, the Highlighting Expert is fast and easy to use!! It gives the “wow” to your report.

Happy Reporting!


View the original article here

Friday, November 26, 2010

Crystal Reports: Using the Highlighting Expert

Have you ever used the Highlighting Expert in Crystal Reports? Chances are your response is no, and you are wondering what it is. The Highlighting Expert is a button on the Experts Toolbar. The button looks like this: .

The Highlighting Expert is also on the shortcut menu of the right-click. Once you choose this Expert, this dialog box opens:

Click on the New button in bottom left corner.On the right, choose the Operator for the criteria and the amount you want to highlight.Now you can change the color of the Font, the Background, and/or the Border.You can Add as many Highlights as you wish with various values, with the New button.You are able to see how it will look in the Sample area.You are able to change the Priority by selecting and using the little arrows to reorder.To remove a highlight, simply select on the left and click Remove.

Try it out, the Highlighting Expert is fast and easy to use!! It gives the “wow” to your report.

Happy Reporting!


View the original article here

Cool Stuff: Film Reel Countdown and Radar Simulation using Xcelsius

Cool Stuff: Film Reel Countdown and Radar Simulation using Xcelsius – MyXcelsius.Com div.cute_profiles_sprite{top:275px;left:0px;}//#smooth_sldr{width:550px;height:180px;background-color:#7f6d57;border:2px solid #4f4131;}#smooth_sldr_items{padding:10px 12px 0px 12px;}#smooth_sliderc{width:526px;height:125px;}.smooth_slideri{width:526px;height:125px;}.sldr_title{font-family:Trebuchet MS, Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;font-style:normal;color:#ff991b;}#smooth_sldr_body h2{line-height:23px;font-family:Calibri, Arial, Helvetica, sans-serif;font-size:20px;font-weight:normal;font-style:normal;color:#f0f0f0;margin:10px 0 5px 0;}#smooth_sldr_body h2 a{color:#f0f0f0;}#smooth_sldr_body span{font-family:Verdana, Arial, Helvetica, sans-serif;font-size:12px;font-weight:normal;font-style:normal;color:#ffffff;}.smooth_slider_thumbnail{float:left;margin:10px 5px 0 0px;border:2px solid #4f4131;}#smooth_sldr_body p.more a{color:#f0f0f0;font-family:Verdana, Arial, Helvetica, sans-serif;font-size:12px;}#smooth_sliderc_nav li{border:1px solid #ffffff;font-size:12px;font-family:Verdana, Arial, Helvetica, sans-serif;}#smooth_sliderc_nav li a{color:#f0f0f0;}.sldrlink{padding-right:25px;}.sldrlink a{color:#ffffff;}MyXcelsius.ComVisual Data Analysis, Information Dashboards and Related Technologies

Skip to Content ?HomeShowcaseVideosVideos from SAPContactAuthorsArchivesCool Stuff: Film Reel Countdown and Radar Simulation using XcelsiusOct 21st, 2010
by Kalyan Verma. TweetShareEmailTweetShareEmail

Inspired by Joshua Tapley’s UFO tracker, I’ve tried my hand at creating this cool animation using Xcelsius. I will be posting the source code soon, however, I would like to hear from you all on your own “approach and take” on creating such an animation using out of box Xcelsius components.

If you enjoyed this post, make sure you subscribe to my RSS feed!No TweetBacks yet. (Be the first to Tweet this post)

Wednesday, November 24, 2010

How to create a Radar animation using Xcelsius?

How to create a Radar animation using Xcelsius? – MyXcelsius.Com div.cute_profiles_sprite{top:275px;left:0px;}//#smooth_sldr{width:550px;height:180px;background-color:#7f6d57;border:2px solid #4f4131;}#smooth_sldr_items{padding:10px 12px 0px 12px;}#smooth_sliderc{width:526px;height:125px;}.smooth_slideri{width:526px;height:125px;}.sldr_title{font-family:Trebuchet MS, Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;font-style:normal;color:#ff991b;}#smooth_sldr_body h2{line-height:23px;font-family:Calibri, Arial, Helvetica, sans-serif;font-size:20px;font-weight:normal;font-style:normal;color:#f0f0f0;margin:10px 0 5px 0;}#smooth_sldr_body h2 a{color:#f0f0f0;}#smooth_sldr_body span{font-family:Verdana, Arial, Helvetica, sans-serif;font-size:12px;font-weight:normal;font-style:normal;color:#ffffff;}.smooth_slider_thumbnail{float:left;margin:10px 5px 0 0px;border:2px solid #4f4131;}#smooth_sldr_body p.more a{color:#f0f0f0;font-family:Verdana, Arial, Helvetica, sans-serif;font-size:12px;}#smooth_sliderc_nav li{border:1px solid #ffffff;font-size:12px;font-family:Verdana, Arial, Helvetica, sans-serif;}#smooth_sliderc_nav li a{color:#f0f0f0;}.sldrlink{padding-right:25px;}.sldrlink a{color:#ffffff;}MyXcelsius.ComVisual Data Analysis, Information Dashboards and Related Technologies

Skip to Content ?HomeShowcaseVideosVideos from SAPContactAuthorsArchivesHow to create a Radar animation using Xcelsius?Nov 16th, 2010
by Joshua Tapley. TweetShareEmailTweetShareEmail

In designing a UFO Tracking dashboard for the Reportapalooza guest challenge, I decided that I needed to create a radar simulation. The math to get the radar to spin past zero wasn’t overly hard, but really through me for a loop at first (no pun intended)!

How to Create:
1. Setup play selector data

Cell A1: 0
Cell A2: =If(A1=100, 0, A1+1)

2. Insert play selector

Source: A2
Destination: A1

Xcelsius Tricks

3. Setup pie chart data

Section 1 – Scanner when spanning across zero
Section 2 – Blank space after scanner
Section 3 – Scanner Slice
Section 4 – Blank space before scanner

Xcelsius Trick

4. Insert pie chart
5. Pie chart options > Behaviors > Animations and Effects: Turn off data animation (or the scanner will spin backwards after hitting 100%)
6. Make data series 1 and 3 blue and make series 2 and 4 black
7. De-select the show lines option for the data series

Xcelsius Trick

8. Insert 2 ellipses over the pie chart to create inner rings
9. Spice it up. I used a dot that fades in when the scanner crosses that area (i.e. 60-70%). Kalyan used sequencing numbers to create a film reel countdown.

Source File

If you enjoyed this post, make sure you subscribe to my RSS feed!No TweetBacks yet. (Be the first to Tweet this post)

Cool Stuff: Film Reel Countdown and Radar Simulation using Xcelsius

Cool Stuff: Film Reel Countdown and Radar Simulation using Xcelsius – MyXcelsius.Com div.cute_profiles_sprite{top:275px;left:0px;}//#smooth_sldr{width:550px;height:180px;background-color:#7f6d57;border:2px solid #4f4131;}#smooth_sldr_items{padding:10px 12px 0px 12px;}#smooth_sliderc{width:526px;height:125px;}.smooth_slideri{width:526px;height:125px;}.sldr_title{font-family:Trebuchet MS, Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;font-style:normal;color:#ff991b;}#smooth_sldr_body h2{line-height:23px;font-family:Calibri, Arial, Helvetica, sans-serif;font-size:20px;font-weight:normal;font-style:normal;color:#f0f0f0;margin:10px 0 5px 0;}#smooth_sldr_body h2 a{color:#f0f0f0;}#smooth_sldr_body span{font-family:Verdana, Arial, Helvetica, sans-serif;font-size:12px;font-weight:normal;font-style:normal;color:#ffffff;}.smooth_slider_thumbnail{float:left;margin:10px 5px 0 0px;border:2px solid #4f4131;}#smooth_sldr_body p.more a{color:#f0f0f0;font-family:Verdana, Arial, Helvetica, sans-serif;font-size:12px;}#smooth_sliderc_nav li{border:1px solid #ffffff;font-size:12px;font-family:Verdana, Arial, Helvetica, sans-serif;}#smooth_sliderc_nav li a{color:#f0f0f0;}.sldrlink{padding-right:25px;}.sldrlink a{color:#ffffff;}MyXcelsius.ComVisual Data Analysis, Information Dashboards and Related Technologies

Skip to Content ?HomeShowcaseVideosVideos from SAPContactAuthorsArchivesCool Stuff: Film Reel Countdown and Radar Simulation using XcelsiusOct 21st, 2010
by Kalyan Verma. TweetShareEmailTweetShareEmail

Inspired by Joshua Tapley’s UFO tracker, I’ve tried my hand at creating this cool animation using Xcelsius. I will be posting the source code soon, however, I would like to hear from you all on your own “approach and take” on creating such an animation using out of box Xcelsius components.

If you enjoyed this post, make sure you subscribe to my RSS feed!No TweetBacks yet. (Be the first to Tweet this post)

Crystal Reports: Using the Highlighting Expert

Have you ever used the Highlighting Expert in Crystal Reports? Chances are your response is no, and you are wondering what it is. The Highlighting Expert is a button on the Experts Toolbar. The button looks like this: .

The Highlighting Expert is also on the shortcut menu of the right-click. Once you choose this Expert, this dialog box opens:

Click on the New button in bottom left corner.On the right, choose the Operator for the criteria and the amount you want to highlight.Now you can change the color of the Font, the Background, and/or the Border.You can Add as many Highlights as you wish with various values, with the New button.You are able to see how it will look in the Sample area.You are able to change the Priority by selecting and using the little arrows to reorder.To remove a highlight, simply select on the left and click Remove.

Try it out, the Highlighting Expert is fast and easy to use!! It gives the “wow” to your report.

Happy Reporting!


View the original article here

Wednesday, November 17, 2010

Cool Stuff: Film Reel Countdown and Radar Simulation using Xcelsius

Cool Stuff: Film Reel Countdown and Radar Simulation using Xcelsius – MyXcelsius.Com div.cute_profiles_sprite{top:275px;left:0px;}//#smooth_sldr{width:550px;height:180px;background-color:#7f6d57;border:2px solid #4f4131;}#smooth_sldr_items{padding:10px 12px 0px 12px;}#smooth_sliderc{width:526px;height:125px;}.smooth_slideri{width:526px;height:125px;}.sldr_title{font-family:Trebuchet MS, Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;font-style:normal;color:#ff991b;}#smooth_sldr_body h2{line-height:23px;font-family:Calibri, Arial, Helvetica, sans-serif;font-size:20px;font-weight:normal;font-style:normal;color:#f0f0f0;margin:10px 0 5px 0;}#smooth_sldr_body h2 a{color:#f0f0f0;}#smooth_sldr_body span{font-family:Verdana, Arial, Helvetica, sans-serif;font-size:12px;font-weight:normal;font-style:normal;color:#ffffff;}.smooth_slider_thumbnail{float:left;margin:10px 5px 0 0px;border:2px solid #4f4131;}#smooth_sldr_body p.more a{color:#f0f0f0;font-family:Verdana, Arial, Helvetica, sans-serif;font-size:12px;}#smooth_sliderc_nav li{border:1px solid #ffffff;font-size:12px;font-family:Verdana, Arial, Helvetica, sans-serif;}#smooth_sliderc_nav li a{color:#f0f0f0;}.sldrlink{padding-right:25px;}.sldrlink a{color:#ffffff;}MyXcelsius.ComVisual Data Analysis, Information Dashboards and Related Technologies

Skip to Content ?HomeShowcaseVideosVideos from SAPContactAuthorsArchivesCool Stuff: Film Reel Countdown and Radar Simulation using XcelsiusOct 21st, 2010
by Kalyan Verma. TweetShareEmailTweetShareEmail

Inspired by Joshua Tapley’s UFO tracker, I’ve tried my hand at creating this cool animation using Xcelsius. I will be posting the source code soon, however, I would like to hear from you all on your own “approach and take” on creating such an animation using out of box Xcelsius components.

If you enjoyed this post, make sure you subscribe to my RSS feed!No TweetBacks yet. (Be the first to Tweet this post)

How to create a Radar animation using Xcelsius?

How to create a Radar animation using Xcelsius? – MyXcelsius.Com div.cute_profiles_sprite{top:275px;left:0px;}//#smooth_sldr{width:550px;height:180px;background-color:#7f6d57;border:2px solid #4f4131;}#smooth_sldr_items{padding:10px 12px 0px 12px;}#smooth_sliderc{width:526px;height:125px;}.smooth_slideri{width:526px;height:125px;}.sldr_title{font-family:Trebuchet MS, Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;font-style:normal;color:#ff991b;}#smooth_sldr_body h2{line-height:23px;font-family:Calibri, Arial, Helvetica, sans-serif;font-size:20px;font-weight:normal;font-style:normal;color:#f0f0f0;margin:10px 0 5px 0;}#smooth_sldr_body h2 a{color:#f0f0f0;}#smooth_sldr_body span{font-family:Verdana, Arial, Helvetica, sans-serif;font-size:12px;font-weight:normal;font-style:normal;color:#ffffff;}.smooth_slider_thumbnail{float:left;margin:10px 5px 0 0px;border:2px solid #4f4131;}#smooth_sldr_body p.more a{color:#f0f0f0;font-family:Verdana, Arial, Helvetica, sans-serif;font-size:12px;}#smooth_sliderc_nav li{border:1px solid #ffffff;font-size:12px;font-family:Verdana, Arial, Helvetica, sans-serif;}#smooth_sliderc_nav li a{color:#f0f0f0;}.sldrlink{padding-right:25px;}.sldrlink a{color:#ffffff;}MyXcelsius.ComVisual Data Analysis, Information Dashboards and Related Technologies

Skip to Content ?HomeShowcaseVideosVideos from SAPContactAuthorsArchives
How to create a Radar animation using Xcelsius?Nov 16th, 2010
by Joshua Tapley. TweetShareEmailTweetShareEmail

In designing a UFO Tracking dashboard for the Reportapalooza guest challenge, I decided that I needed to create a radar simulation. The math to get the radar to spin past zero wasn’t overly hard, but really through me for a loop at first (no pun intended)!





How to Create:
1. Setup play selector data

Cell A1: 0
Cell A2: =If(A1=100, 0, A1+1)




2. Insert play selector

Source: A2
Destination: A1

Xcelsius Tricks


3. Setup pie chart data

Section 1 – Scanner when spanning across zero
Section 2 – Blank space after scanner
Section 3 – Scanner Slice
Section 4 – Blank space before scanner

Xcelsius Trick


4. Insert pie chart
5. Pie chart options > Behaviors > Animations and Effects: Turn off data animation (or the scanner will spin backwards after hitting 100%)
6. Make data series 1 and 3 blue and make series 2 and 4 black
7. De-select the show lines option for the data series

Xcelsius Trick


8. Insert 2 ellipses over the pie chart to create inner rings
9. Spice it up. I used a dot that fades in when the scanner crosses that area (i.e. 60-70%). Kalyan used sequencing numbers to create a film reel countdown.


Source File

If you enjoyed this post, make sure you subscribe to my RSS feed!No TweetBacks yet. (Be the first to Tweet this post)

Crystal Reports: Using the Highlighting Expert

Have you ever used the Highlighting Expert in Crystal Reports? Chances are your response is no, and you are wondering what it is. The Highlighting Expert is a button on the Experts Toolbar. The button looks like this: .

The Highlighting Expert is also on the shortcut menu of the right-click. Once you choose this Expert, this dialog box opens:

Click on the New button in bottom left corner.On the right, choose the Operator for the criteria and the amount you want to highlight.Now you can change the color of the Font, the Background, and/or the Border.You can Add as many Highlights as you wish with various values, with the New button.You are able to see how it will look in the Sample area.You are able to change the Priority by selecting and using the little arrows to reorder.To remove a highlight, simply select on the left and click Remove.

Try it out, the Highlighting Expert is fast and easy to use!! It gives the “wow” to your report.

Happy Reporting!


View the original article here

Monday, November 15, 2010

Cool Stuff: Film Reel Countdown and Radar Simulation using Xcelsius

Cool Stuff: Film Reel Countdown and Radar Simulation using Xcelsius – MyXcelsius.Com div.cute_profiles_sprite{top:275px;left:0px;}//#smooth_sldr{width:550px;height:180px;background-color:#7f6d57;border:2px solid #4f4131;}#smooth_sldr_items{padding:10px 12px 0px 12px;}#smooth_sliderc{width:526px;height:125px;}.smooth_slideri{width:526px;height:125px;}.sldr_title{font-family:Trebuchet MS, Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;font-style:normal;color:#ff991b;}#smooth_sldr_body h2{line-height:23px;font-family:Calibri, Arial, Helvetica, sans-serif;font-size:20px;font-weight:normal;font-style:normal;color:#f0f0f0;margin:10px 0 5px 0;}#smooth_sldr_body h2 a{color:#f0f0f0;}#smooth_sldr_body span{font-family:Verdana, Arial, Helvetica, sans-serif;font-size:12px;font-weight:normal;font-style:normal;color:#ffffff;}.smooth_slider_thumbnail{float:left;margin:10px 5px 0 0px;border:2px solid #4f4131;}#smooth_sldr_body p.more a{color:#f0f0f0;font-family:Verdana, Arial, Helvetica, sans-serif;font-size:12px;}#smooth_sliderc_nav li{border:1px solid #ffffff;font-size:12px;font-family:Verdana, Arial, Helvetica, sans-serif;}#smooth_sliderc_nav li a{color:#f0f0f0;}.sldrlink{padding-right:25px;}.sldrlink a{color:#ffffff;}MyXcelsius.ComVisual Data Analysis, Information Dashboards and Related Technologies

Skip to Content ?HomeShowcaseVideosVideos from SAPContactAuthorsArchivesCool Stuff: Film Reel Countdown and Radar Simulation using XcelsiusOct 21st, 2010
by Kalyan Verma. TweetShareEmailTweetShareEmail

Inspired by Joshua Tapley’s UFO tracker, I’ve tried my hand at creating this cool animation using Xcelsius. I will be posting the source code soon, however, I would like to hear from you all on your own “approach and take” on creating such an animation using out of box Xcelsius components.

If you enjoyed this post, make sure you subscribe to my RSS feed!No TweetBacks yet. (Be the first to Tweet this post)