Hi there,
I want to create report like this:
02-Feb-2017 03-Feb-2017 04-Feb-2017 –> Column Replicator
SO-001 SO-002 SO-004
SO-008 SO-003 SO-007
SO-009 SO-011
SO-010 SO-012
SO-013
SO-014
So in each Date, the report will show Sales Order Number which has the same Order Date.
Any idea how to create the report?
Thanks & Regards,
Olwin
Date
Votes
14 comments
-
Jet Reports Historic Posts Hi there,
I want to create report like this:
02-Feb-2017 03-Feb-2017 04-Feb-2017 –> Column Replicator
SO-001 SO-002 SO-004
SO-008 SO-003 SO-007
SO-009 SO-011
SO-010 SO-012
SO-013
SO-014
For each date, report will show Sales Order No. that have the same "Order Date".
Any idea how to do this?
Thanks & Regards,
Olwin -
Jet Reports Historic Posts Hello.
From your description, I assume you are using Dynamics NAV.
Perhaps something like this?
Resulting in output like this?
This example intentionally hides the columns that have no order numbers. -
Jet Reports Historic Posts Hello,
This is exactly what i want :D .
Just want to make sure these 2 things, is it correct that:
1. The syntax in A2 "Hide+?" is to determine that "Hide" function will be decided in Row 2.
2. If i want to prepare report that will show so many SO number included in each date, i just need to put large number in "End Number" (NP Integer Function) as buffer.
Thanks & Regards,
Olwin -
Jet Reports Historic Posts Hi
In case if we need to get the value of the each orders as well, how could we do that. Please help and suggest the same. -
Jet Reports Historic Posts Hello -
In answer to Olwin's questions:
1) Yes, that method is referred to as "Conditional Hiding". More information can be found in the online knowledgebase: https://jetsupport.jetreports.com/hc/en-us/articles/218953738
2) I'm not sure what you are asking for.
Ravi:
To accomplish that, I would change the report in this way:
This would result in a report that looks like this:
Likewise, I could put the "No.", and the "Amount" into separate columns - I would then adjust the NL(Columns) function to "Columns=3".
I hope that helps. -
Jet Reports Historic Posts Hello
Thank you very much for the quick help
Impressive formula, you are an expert
Some how the amount is not getting it's giving me the error saying record key is corrupted, please find enclosed the error and file in design mode, please help
Warm regards
Ravi - Hong Kong -
Jet Reports Historic Posts Hello Ravi -
You'll notice that my function in cell C5 does not return a specified field:=NL(B5,"36 Sales Header",,"19 Order Date",C$4)
(note the double commas after the table name)
This forces the NL() function to return a "Record Key" - into which we can then use the NF() function return specific field values.
This is the technique you would want to use in order to return both the "No." field and the "Amount" field. -
Jet Reports Historic Posts Hi,
Thanks for your answer.
Regarding my second question, is it correct that "NP(Integers,1,20)" means that max SO number on each date is 20?
BR,
Olwin -
Jet Reports Historic Posts Hello Olwin -
I picked 20 as the maximum number of records that would be present for any specific date. You would want to adjust that to represent the expected maximum for your data. -
Jet Reports Historic Posts Thank you Very much HP,
-
Jet Reports Historic Posts Dear HP
Thanks for your help for the orders listing
Please find enclosed the file where I could get the order no. Amount and Customer Name,
I understand each order can have multiple lines for the products, please help me to link the sales line table and get me the first product in the order, most orders are single product only , only a few orders with multiple products, even in such case just first product showing it's fine. -
Jet Reports Historic Posts Hello Ravi -
Something like this? -
Jet Reports Historic Posts Thank you so much, it's a great help indeed
One last thing, I need to hide the lines where for all the dates orders are blank -
Jet Reports Historic Posts Perfect, Thank you
Please sign in to leave a comment.