Skip to Content
0

Crystal Report details will not repeat.

Feb 22, 2017 at 11:24 PM

81

avatar image

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.

details-ink-li.jpg (913.2 kB)
parameter.png (34.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Taseeb Saeed Feb 23, 2017 at 07:36 AM
0

Hello,

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

Thanks,

Engr. Taseeb Saeed

Show 4 Share
10 |10000 characters needed characters left characters exceeded

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

0

Hello,

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

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

Thanks,

Engr. Taseeb Saeed

0

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.

0

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

0