Visual Basic Crystal Reports - Changing x position of a field object conditionally

Author

Changing x position of a field object conditionally

Balz

2006-11-23, 8:07 am

Hello

As I read in the "User's Guide for Crystal Reports XI Release 2" there
is a possibility to change the x position of an object (all but line or
box object) dynamic. On page 276 they describe this way with the
following points:

1. Right-click the field that you want to move conditionally, and select
Size and Position.

2. Click the Conditional Formula button next to the X position value field.

3. In the Formula Workshop, enter your conditional X position formula
text. For example, to move orders that were shipped late to a second
column, enter formula text such as this:
If (Orders.Ship Date) < CDateTime (2004, 01, 01, 02, 10, 11) then 4320
Note: The number 4320 represents the new position that you want to
define as the second column. The position is measured in twips; there
are 1440 twips in an inch.

4. Click Save and close to return to your report.

5. Click OK to save your position setting.

My problem is that I want to format a field object (in a group) and
don't have the entry "Size and Position" in the context menu.

I use the Crystal Report Version that is included in the Visual Studio
2005 and always thought that this is "Crystal Reports XI Release 2".

Does anybody now anything about this missing menu point?

My second question is: Is there any way to change the size of the same
field object dynamic? I have to show the hierarchical structure of a
treeview and therefore need to indent the field and change it's size.
My meantime solution is to insert a ChrW(9) as many time as needed but
this looks quiet ugly because the Field has a colored background.

Any help would be great :).

Thanks and greetings from Switzerland.

Balz Trüb

spkelly@sbcglobal.net

2006-11-24, 7:03 pm

Maybe I am misreading... but the "moving part"... can't that be handled
by two details sections? This should allow you to set lines, and other
drawing objects at design time.

Create Details A where x is set at the standard position
Create Details B where x is set at 4320 twips.
Then set suppression of Details A when date < test.date
Set suppression Details B when date >=3D test.date...
align the columns however you need them... just a thought.

I use CR X in VB6 so I can't help you with the 2005 question.

Can't the groups represent your hierarchy?
The first group represents your "top level"
The second group represents the next "level", etc.

Then you can use the group headers to indent the "field".
If you need things on the same line with the details... use the Overlay
option in the Section Expert.

Good luck from America. I hope this worked.

Sean

Balz wrote:
> Hello
>
> As I read in the "User's Guide for Crystal Reports XI Release 2" there
> is a possibility to change the x position of an object (all but line or
> box object) dynamic. On page 276 they describe this way with the
> following points:
>
> 1. Right-click the field that you want to move conditionally, and select
> Size and Position.
>
> 2. Click the Conditional Formula button next to the X position value fiel=
d=2E
>
> 3. In the Formula Workshop, enter your conditional X position formula
> text. For example, to move orders that were shipped late to a second
> column, enter formula text such as this:
> If (Orders.Ship Date) < CDateTime (2004, 01, 01, 02, 10, 11) then 4320
> Note: The number 4320 represents the new position that you want to
> define as the second column. The position is measured in twips; there
> are 1440 twips in an inch.
>
> 4. Click Save and close to return to your report.
>
> 5. Click OK to save your position setting.
>
> My problem is that I want to format a field object (in a group) and
> don't have the entry "Size and Position" in the context menu.
>
> I use the Crystal Report Version that is included in the Visual Studio
> 2005 and always thought that this is "Crystal Reports XI Release 2".
>
> Does anybody now anything about this missing menu point?
>
> My second question is: Is there any way to change the size of the same
> field object dynamic? I have to show the hierarchical structure of a
> treeview and therefore need to indent the field and change it's size.
> My meantime solution is to insert a ChrW(9) as many time as needed but
> this looks quiet ugly because the Field has a colored background.
>
> Any help would be great :).
>=20
> Thanks and greetings from Switzerland.
>=20
> Balz Tr=FCb

Sponsored Links