If you have questions or if you want to share your opinion about Aware IM post your message on this forum
#50702 by cishpix
Thu Apr 11, 2019 2:11 pm
Hi everyone,
I have a query that display some data (depend date, example from 1 March 2019 - 31 March 2019) and the query is group by material name and I want to design a report that only display subtotal of every material name and grand total.

Is it possible in AwareIM report?


Thanks
#50704 by cishpix
Thu Apr 11, 2019 2:48 pm
tford wrote:Might be easiest to have a BO that maintains totals by Material Name via rules & easily display those totals on reports & queries.

Okay Tom, thanks for your respond.
I shall try follow your advice
#50713 by Jaymer
Thu Apr 11, 2019 10:38 pm
cishpix wrote:Hi everyone,
I have a query that display some data (depend date, example from 1 March 2019 - 31 March 2019) and the query is group by material name and I want to design a report that only display subtotal of every material name and grand total.

Is it possible in AwareIM report?


Thanks


Sure that HAS to be possible.
... or the report writer isn’t worth a crap.

You shouldn’t need to display a detail section. So you’re only going to show the group footer.
For testing, design it WITH the detail showing..once sub totals are verified, you can drop the detail band.
#50720 by cishpix
Fri Apr 12, 2019 10:18 am
kklosson wrote:setting the elements inside the details band to zero height

You're right, I have follow your advice and it works. Thanks for you

Jaymer wrote:You shouldn’t need to display a detail section. So you’re only going to show the group footer.

Thank you Jaymer, your idea have sort out my problem but the "grand total" position always near end of the page although I have set it in "Column footer" section and the subtotal only 3 item/records.

Do you have any idea how to set the grand total NOT near end of the page?
Thank you.
#50721 by Jaymer
Fri Apr 12, 2019 2:12 pm
you can see from the pics that this is achievable

but when you put your GRAND TOTALS in the column or page footer, they go to the bottom (as you said).

I have created a "ghost" section that doesn't really do anything except acts as a placeholder for GRAND TOTALS and it is "outside" the loop of each vendor. And has no grouping defined. This makes it display when the inner group (Vendor) is finished and thus the TOTALS appear in the proper place. (Mine was named "Section")

Since you have already created your group, you'll need to:
1) Click on Page Header band
2) Make a new Group, lets name it "Totals"
3) To be safe, click on Totals Header, then Make ANOTHER Material group. Now its "inside" Totals.
4) Copy/Paste the fields from existing Material Group to the new Material Group
5) Delete the OLD Material Group (From the Tree on the left.)
6) You'll need to redefine the group by property (In the SUM field) - I think it will throw an error if you try to save before doing this
7) Make sure you set the Totals Header and Detail Bands HEIGHTs TO ZERO (they are only set to 1 by dragging)

jaymer...
Attachments
Screen Shot 2019-04-12 at 10.11.13 AM.png
Screen Shot 2019-04-12 at 10.11.13 AM.png (47 KiB) Viewed 1485 times
Screen Shot 2019-04-12 at 10.09.58 AM.png
Screen Shot 2019-04-12 at 10.09.58 AM.png (62.93 KiB) Viewed 1485 times
#50723 by tford
Fri Apr 12, 2019 4:32 pm
By the way, I wasn't trying to imply this couldn't be done in the report writer. Just saying that in the apps I have written where users needed to see totals for a product / region / etc, I've found that users often needed a way to see those on the screen as well so the approach I described earlier set the stage for both screen use & report use.
#50726 by cishpix
Sat Apr 13, 2019 3:24 pm
Jaymer wrote:I have created a "ghost" section that doesn't really do anything except acts as a placeholder for GRAND TOTALS and it is "outside" the loop of each vendor.

Many thanks for you and really appreciate for your help. This is the second time you sort out my problem again.

I'm still have other question but still related with grand total.
Ex, a material stock (we call it is bolt) have 2 measurement unit, box and pcs. Usually use box but sometimes it can have both measurement units.
So.. when I use SUM in grand total for pcs measurement unit, there is no any number if the total is 0 (there is no problem when the total is not 0). Do you still have other trick to solve this case?

UPDATE
I have try use "Attach Condition" but the condition cannot allow a condition like I use in rule or process (like the below)
SUM Material.stock WHERE (Material.MeasurementUnit='pcs')<>0

Thanks and Regards.
#50727 by Jaymer
Sat Apr 13, 2019 5:00 pm
cishpix wrote:Ex, a material stock (we call it is bolt) have 2 measurement unit, box and pcs. Usually use box but sometimes it can have both measurement units.
So.. when I use SUM in grand total for pcs measurement unit, there is no any number if the total is 0 (there is no problem when the total is not 0). Do you still have other trick to solve this case?

UPDATE
I have try use "Attach Condition" but the condition cannot allow a condition like I use in rule or process (like the below)
SUM Material.stock WHERE (Material.MeasurementUnit='pcs')<>0

Thanks and Regards.


I'm very happy to help - but LOGIC is very precise - your English is not very precise.
So its hard for me to understand EXACTLY what you want.

Is it possible for each Material to contain quantity for BOTH
Bulk Unit Count
Individual Count ?

--> "there is no any number if the total is 0"
Does that mean this: If the total is 0, the field displays blank?
So the issue is that instead of a blank, you want it to print "0" ?
(if this, then isn't it just a Formatting issue so that is does not suppress the 0 )

In each Material subtotal group, are you trying to print 2 numbers? :
Subtotal Box: xxx Subtotal Pcs: yyy
#50732 by cishpix
Mon Apr 15, 2019 1:04 am
Jaymer wrote:your English is not very precise.
So its hard for me to understand EXACTLY what you want.

Sorry and thanks for you, I know I need more practice my English again.

Jaymer wrote:Does that mean this: If the total is 0, the field displays blank?
So the issue is that instead of a blank, you want it to print "0"
(if this, then isn't it just a Formatting issue so that is does not suppress the 0 ) ?

In each Material subtotal group, are you trying to print 2 numbers? :
Subtotal Box: xxx Subtotal Pcs: yyy

Yes, that's what I want when the field displays blank so I want it can print "0". Is it possible?

Who is online

Users browsing this forum: Google [Bot] and 25 guests