Claasic Report

Nehapr

i m doing report in classic in data item i have given requisition line and item table so i want to filter the ending date according to item so how can i get this ....

mohana_cse06

you should also tell us what you have tried..

Nehapr

ya i have tried in properties in data item link by no. from two tables,bt in item table date feild is not ther to link .i have given feilds from requisition line to display No.,Description,Qty,Location,Ending Date so all these feild should be sort by ending date so how can i get this report.......

mohana_cse06

Nehapr wrote:

so all these feild should be sort by ending date so how can i get this report.......

Nehapr wrote:

i m doing report in classic in data item i have given requisition line and item table so i want to filter the ending date according to item so how can i get this ....

You want to sort by ending date or you want filter Items by Ending date?

If you want to sort, set ending date in DataItemTableView keys..

If you want to filter item, then you should tell us with which field you want to filter?

Check whether it is Date Filter..

Nehapr

According to order ending date item should be filter(this report is relate to manufacturing inventory) so how can i do this report...

mohana_cse06

mohana_cse06 wrote:

[
If you want to filter item, then you should tell us with which field you want to filter?
Check whether it is Date Filter..

:-k

Nehapr

Item no. Feild should be filter

mohana_cse06

Item No. field should be filtered with Ending Date?

Please find out the exact requirement..

Nehapr

According to Ending date in Requisition Line table ,Item No. should be filter ,this is the requirement......

mohana_cse06

How can this be possible?

Can filter Item No. with date?

Item.SETRANGE("No.",010111D);

do you think you will get an item record here?

vijay_g

why don't you short requisition line with ending date?

Nehapr

ya even i tried ,so wat to do .It is not possible to achieve this report.....?

mohana_cse06

If your requirement is not clear, who can tell you whether this is possible or not?