Does anyone knows about matrix report??

bull

Hi all ,

I am new person in the forum(i just log in) and in NaVision to . I Dont know many things about the application and i have a problem with one report .
I want to create a matrix report and i cant do it .
The report will draw data from table value entry . I need to show for each item ,variant code, location code the total amount of Item Ledger Entry Quantity .

example :

item code_description_variant code_location1____location2_etc_totals
001______test item______________ 10________ 5____________ 15
___________________red__________5_________3_____________8
___________________black________5_________2_____________7

could anyone help me?
Thanks,
bull

bull

how can i generate excel file??
As i told earlier i am a begginer to Navision .

thanks..

bull

thanks for help

Arhontis

Hi bull...

You have a few options on doing what you need...
In most of them you need development skills which I don't know if you have access to them or have a developer in hand...

1) Export your data to excel and try to make a cross tab...

2) Create a report with fixed maximum number of columns (locations) because of the paper size is limited... by using a array text variable for the header and a decimal array variable for the item/vairant sum quantity... (like report 5600, or report 112)...

3) Make a custom cross-tab form in Nav (like the analysis by dimensions), but is alot of tricky to do if you are a novice.

Wellcome to mibuso...

Arhontis

I recommend you try the third solution of course, because is the most proper (IMHO)... You have online data, be able to filter with dates maybe or categories... and you don't use any paper... (reports)

Oops...

Have you checked the options on Item Card:
- Item->Item Statistics form (F9)? (show as columns=location)
- Item->Item by location?!?

bull

Thanks Arxonti for your help ,
I will try to make the steps that you just told me but i dont know if i can yet!!
I ll try it and we see..
thanks anyway
regards ,
bull

Arhontis

The 1,2,3 are not exactly steps, its different implementations...

Practicing and trying is the best way to learn...

Are you planning to be a consultant or developer? because this is surely a developer's work to make a cross-tab form like the analysis by dims...

bull

A developer ...
Yes i understand that they are not steps :oops: when i read it again , but i dont know if the third option is the best for me, because i want a report .
maybe i ll try the second option .
thanks for help,
regards,
bull

Miklos_Hollender

If you'd still choose option 3), I recommend a Save As on form 213 and modifing it - I always do that when I have to create a matrix form.