classic report Sorting issue

Chowdary

Hi,

Report Structure

dataitem1 <Production Order>
dataitem2 -<Item> //indented

This report shows production orders information.

I need to sort data based on Due Date on production order and also, need to filter report for Customers. I'm trying to use Customer No. field on the Item for Customer filter. With the above structure, report is sorting by Due Date, but not filtering for customers as it's not at production order level. How to manage to filter report for customers?

Thank You for reading

Best Regards
Chowdary

Chinmoy

.

Chinmoy

How will you sort a report (for that matter anything on earth) on a field which is not present in your query? This looks like a typo from your side. You can sort records in a query only with the fields which is there in the tables or can be joined from some other tables. Am I getting something wrong here?

Chn

kriki

[Topic moved from 'General Chat' forum to 'NAV/Navision Classic Client' forum]

vaprog

I did not quite get the structure of your data (where the field you have to filter resides), but anyway, have a look at Filter by item in return order report of invoiced purchase for an idea how to do.
You do not necessarily have to add a dataitem to do it, a record variable and one ore more fields on the request option form might do.

Chowdary

Chinmoy wrote:

How will you sort a report (for that matter anything on earth) on a field which is not present in your query? This looks like a typo from your side. You can sort records in a query only with the fields which is there in the tables or can be joined from some other tables. Am I getting something wrong here?

Chn

Hi Chinmoy,

Thank for the response and I know there is no way, just trying to see anyone has different idea like you said joins.

Chowdary

vaprog wrote:

I did not quite get the structure of your data (where the field you have to filter resides), but anyway, have a look at Filter by item in return order report of invoiced purchase for an idea how to do.
You do not necessarily have to add a dataitem to do it, a record variable and one ore more fields on the request option form might do.

The field is Customer No. and which is in Item table.

I can't add variable on the request form and filter Prod. Orders, because Pord. Orders doesn't have Customer No. field.

Thank You, I will get back to you on your link. Thanks again

omyvadiya

Have you tried changing the key (DataItemTableView) to due date, for sorting.