Issue in Crystal Report

[Former Member]

Hi Experts,

I want to hide the column in report if it has no value.Only it has to dispaly if it has a value.

Note: I want this to be work in details part.

For Eg : In details part if the item has discount then it has to display else it does'nt. The discount column has to hide.

[Former Member]

Hi Harshal and Jaydeep,

As i said earlier i want to invisible the discount column from the details part if the value is zero. I can only empty space but i can't able to remove column from there.

So give me the best solution if possible???

[Former Member]

Hi Amith,

I think particular column cannot be hide.

Thanks,

Harshal

[julie_jamieson2]

You will need to also hide the header text, and may need to work with the lines or borders as well, depending on the visual result you want

[Former Member]

Hi,

Would you please explain in detail?

[Former Member]

Hi Amith,

For hiding that column you have to set that formula for Header text and also for right side line border and after applying that formula which you put in that field you will hide the whole discount column when discount will null.

Thanks,

Jaydeep

[Former Member]

Hi Amith,

You can either change discount percent field as Isnull(discpercent,0) as 'DiscPer' in your sql query and set formula as suppress if Command.DiscPer =0 or you can also use formula as cstr(Command.DiscPrcnt)=''. and then just save and close.

Try this thing.I hope this might be give you correct solution.Let me know your feedback.

Thanks,

Jaydeep

[Former Member]

Hi Amith,

Status ?

Thanks,

Harshal

[kothandaraman_nagarajan]

Hi,

Please try this,

{Command.DiscPrcnt} = ' '

Thanks

[KennedyT21]

In crystal report Right Click on the filed , choose format field , select the Number Tab and Set zero Value as - or empty space...

Rgds

[Former Member]

Hi Amith,

Right click on Discount field

choose Format Field and

then select Common tab

and then Select Suppress and choose formula Icon [x-2]

and write this command as {Command.Discount] IS Null and then

save and close.

Let me know the feedback after doing this.

Thanks,

Harshal

[Former Member]

Hi Harshal,

This Error i am getting.

[Former Member]

Hi Amith,

Try with this

{Command.DiscPrcnt}='' or {Command.DiscPrcnt}='0'

Thanks,

Harshal

[Former Member]

Hi Harshal,

The whole column has to be hide.

Is it possible?

[Former Member]

Hi Amith,

Click on Detail Section

Then select Section Expert

Select Suppress (No Drill Down) and click on formula tab (X-2)

and write this command as {Command.DiscPrcnt}='' or {Command.DiscPrcnt}='0'

and Save and close

Thanks,

Harshal

[Former Member]

Hi Harshal,

I am getting error like 'Add number here' and whole row is supressing, i dont want that.

It has to supress only Discount column.

[Former Member]

Hi Amith,

Then you need to do that suppress formula which I mention in my first reply to all the fields in your report.

This should work.

Thanks,

Harshal

[julie_jamieson2]

You will need to add the same suppression formula the the header as well if you want the whole column to disappear.

There will still be white space where it was though