Solved

Can a Field Grow Horizontally?

Posted on 2006-10-29
4
1,991 Views
Last Modified: 2008-02-01
I am writing a Crystal Report using the VS.NET 2005 embedded version, trying to make a field that can grow horizontally. I have a numeric % value for each record, and want to display visually the value in horizontal bar chart fashion. I want to have a blank text field with red background, and set the width of the field using a formula based on the % value. Or, create an invisible string of X's whose length is the % value, and allow the field to grow wider. Is either of these methods possible?
0
Comment
Question by:alfer
  • 2
  • 2
4 Comments
 
LVL 42

Expert Comment

by:frodoman
ID: 17833434
No, Crystal will only grow fields vertically, not horizontally.  This is because a report itself can grow vertically by adding pages but cannot grow horizontally.

Why not just use a chart to display the data?  Otherwise, you can accomplish this using a vertical approach instead but not horizontal.

frodoman
0
 
LVL 7

Accepted Solution

by:
ast2550 earned 125 total points
ID: 17834653
I can imagine that you could trick it up to work, but it isn't very pretty or configurable.

If you have finite choices for variations of bar length (say 0-10), then you could create 10 text objects, for example, with a background color to show each a portion of the line.  So, if you wanted to show 3, then you'd make the first three text objects visible by your criteria(each of which are only 1/10 of the total space)
[ ][ ][ ] for 3/10
So, the suppress formula for the the other seven bars would make them not visable.
0
 
LVL 42

Expert Comment

by:frodoman
ID: 17834677
Interesting idea - that might work as long as you can come up with a finite limit.

frodoman
0
 
LVL 7

Expert Comment

by:ast2550
ID: 17858242
Any update?
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now