Conditionally movr a field

[ajayz90]

Can i conditional;ly move a field in crystal?

Ie whenever a passed parameter is 'staff' the sftaff column moves to the right to overwrite a sessions colum which has been suppressed.I want to move it conditionally whenever a parameter like staff is passed about 10 cms to the right.

Ajay

 

[craigber]

It would be easier to suppress the Staff column and conditionnally control which field and heading gets printed in the sessions column. You can easily write a formula that will do this.

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"

 

[synapsevampire]

You have options here, either write 2 formulas which conditionally change based on the parm:

if {?parm} = "staff" then
{table.staff}
else
""

Then for the sessions formula:

if {?parm} = "staff" then
{table.sseesions}
else
{table.staff}

Or select insert section below on whatever section it is, and lay the fields out how you want for the other option, then conditionally suppress the sections based on the parm.

-k

 

[synapsevampire]

Sorry, been a day riddled with typos:

For the staff formula:

if {?parm} <> &quot;staff&quot; then

else
&quot;&quot;

Then for the sessions formula:

if {?parm} = &quot;staff&quot; then
{table.staff}
else
{table.sessions}

-k