Crystal Report details will not repeat.

[former_member264311]

Good Day Experts,

What should I do in my report I want the report will show not repeated details.

I have parameter warehouse if i will not put any warehouse will show the quantity of all item and quantity but not repeated. if i will select specific warehouse that's the case the item will repeat bec i selected specific warehouse.

Please see attached picture below for reference.

[Former Member]

Hello,

Add a group on warehouse and item name. Insert a summary for in hand stock.

Thanks,

Engr. Taseeb Saeed

[former_member264311]

Hi Engr. Saeed.

Thanks for the reply. My requirement is when i will leave as blank the warehouse parameter only all items will show not an item in different warehouses.

Thanks

[Former Member]

Hello,

Please add the following code into selection formula where you are filtering your data

{wareHouseField} = {?warehouseParameter} OR {?warehouseParameter} = ''

Thanks,

Engr. Taseeb Saeed

[former_member264311]

Hi Engr. Saeed.

This is my parameter.

({?Warehouse@ Select OWHS.WhsCode from owhs.WhsCode} = '' OR {Command.wAREHOUSE} = {?Warehouse@ Select OWHS.WhsCode from owhs.WhsCode}) . My only problem is when i will leave as blank the warehouse the output will show group by warehouse and what item has quantity on that warehouse. MY requirement is. when I leave as blank the warehouse parameter will show only all Item in item master data has a quantity. Like for example when i leave as blank the warehouse parameter I want to show like this below:

ItemCode,Quantity

ItemCodeA,200

ItemCodeB,200

ItemCodeC,300

When I select specific warehouse i like to show like this.

Group Warehouse (A)

ItemCode,Quantity

ItemCodeA,100

ItemCodeB,150

ItemCodeC,50

Group Warehouse (B)

ItemCode,Quantity

ItemCodeA,100

ItemCodeB,50

ItemCodeC,250

Thanks.

[Former Member]

Hello,

You can suppress the group section by following code

if {?Warehouse@ Select OWHS.WhsCode from owhs.WhsCode} = ''  then
true

this will suppress the group when you will give the parameter empty.

Thanks,

Engr. Taseeb Saeed