Epicor 9 702A - BAQ - Total Sales value / Job Info/ Total Cost

<!-- #ygrps-yiv-817608736 _filtered #ygrps-yiv-817608736 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-817608736 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-817608736 {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #ygrps-yiv-817608736 {font-family:"Century Gothic"; panose-1:2 11 5 2 2 2 2 2 2 4;} _filtered #ygrps-yiv-817608736 {font-family:"Lucida Fax"; panose-1:2 6 6 2 5 5 5 2 2 4;} _filtered #ygrps-yiv-817608736 {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #ygrps-yiv-817608736 {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} #ygrps-yiv-817608736 #ygrps-yiv-817608736 p.ygrps-yiv-817608736MsoNormal, #ygrps-yiv-817608736 li.ygrps-yiv-817608736MsoNormal, #ygrps-yiv-817608736 div.ygrps-yiv-817608736MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman", "serif";} #ygrps-yiv-817608736 a:link, #ygrps-yiv-817608736 span.ygrps-yiv-817608736MsoHyperlink { color:blue; text-decoration:underline;} #ygrps-yiv-817608736 a:visited, #ygrps-yiv-817608736 span.ygrps-yiv-817608736MsoHyperlinkFollowed { color:purple; text-decoration:underline;} #ygrps-yiv-817608736 p {

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-817608736 code
{
font-family:“Courier New”;}
#ygrps-yiv-817608736 pre
{

margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:“Courier New”;}
#ygrps-yiv-817608736 tt
{
font-family:“Courier New”;}
#ygrps-yiv-817608736 span.ygrps-yiv-817608736cat
{}
#ygrps-yiv-817608736 span.ygrps-yiv-817608736ct
{}
#ygrps-yiv-817608736 span.ygrps-yiv-817608736HTMLPreformattedChar
{

font-family:Consolas;}
#ygrps-yiv-817608736 p.ygrps-yiv-817608736attach, #ygrps-yiv-817608736 li.ygrps-yiv-817608736attach, #ygrps-yiv-817608736 div.ygrps-yiv-817608736attach
{

margin-right:0in;

margin-left:0in;
font-size:9.0pt;
font-family:“Arial”, “sans-serif”;}
#ygrps-yiv-817608736 p.ygrps-yiv-817608736bold, #ygrps-yiv-817608736 li.ygrps-yiv-817608736bold, #ygrps-yiv-817608736 div.ygrps-yiv-817608736bold
{

margin-right:0in;

margin-left:0in;
font-size:10.0pt;
font-family:“Arial”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-817608736 p.ygrps-yiv-817608736green, #ygrps-yiv-817608736 li.ygrps-yiv-817608736green, #ygrps-yiv-817608736 div.ygrps-yiv-817608736green
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
color:#628C2A;}
#ygrps-yiv-817608736 p.ygrps-yiv-817608736replbq, #ygrps-yiv-817608736 li.ygrps-yiv-817608736replbq, #ygrps-yiv-817608736 div.ygrps-yiv-817608736replbq
{
margin:3.0pt;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-817608736 p.ygrps-yiv-817608736ad, #ygrps-yiv-817608736 li.ygrps-yiv-817608736ad, #ygrps-yiv-817608736 div.ygrps-yiv-817608736ad
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-817608736 p.ygrps-yiv-817608736underline, #ygrps-yiv-817608736 li.ygrps-yiv-817608736underline, #ygrps-yiv-817608736 div.ygrps-yiv-817608736underline
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-817608736 span.ygrps-yiv-817608736yshortcuts
{}
#ygrps-yiv-817608736 p.ygrps-yiv-817608736ad1, #ygrps-yiv-817608736 li.ygrps-yiv-817608736ad1, #ygrps-yiv-817608736 div.ygrps-yiv-817608736ad1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-817608736 p.ygrps-yiv-817608736ad2, #ygrps-yiv-817608736 li.ygrps-yiv-817608736ad2, #ygrps-yiv-817608736 div.ygrps-yiv-817608736ad2
{

margin-right:0in;
margin-bottom:7.5pt;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-817608736 p.ygrps-yiv-817608736underline1, #ygrps-yiv-817608736 li.ygrps-yiv-817608736underline1, #ygrps-yiv-817608736 div.ygrps-yiv-817608736underline1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
text-decoration:underline;}
#ygrps-yiv-817608736 span.ygrps-yiv-817608736yshortcuts1
{
font-family:“Verdana”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-817608736 span.ygrps-yiv-817608736yshortcuts2
{
font-family:“Verdana”, “sans-serif”;
font-weight:normal;}
#ygrps-yiv-817608736 span.ygrps-yiv-817608736EmailStyle36
{
font-family:“Calibri”, “sans-serif”;
color:#1F497D;}
#ygrps-yiv-817608736 .ygrps-yiv-817608736MsoChpDefault
{
font-size:10.0pt;}
_filtered #ygrps-yiv-817608736 {
margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-817608736 div.ygrps-yiv-817608736WordSection1
{}
#ygrps-yiv-817608736
_filtered #ygrps-yiv-817608736 {
}
_filtered #ygrps-yiv-817608736 {

font-family:Symbol;}
_filtered #ygrps-yiv-817608736 {

font-family:“Courier New”;
}
_filtered #ygrps-yiv-817608736 {

font-family:Wingdings;}
_filtered #ygrps-yiv-817608736 {

font-family:Wingdings;}
_filtered #ygrps-yiv-817608736 {

font-family:Wingdings;}
_filtered #ygrps-yiv-817608736 {

font-family:Wingdings;}
_filtered #ygrps-yiv-817608736 {

font-family:Wingdings;}
_filtered #ygrps-yiv-817608736 {

font-family:Wingdings;}
_filtered #ygrps-yiv-817608736 {

font-family:Wingdings;}
#ygrps-yiv-817608736 ol
{margin-bottom:0in;}
#ygrps-yiv-817608736 ul
{margin-bottom:0in;}
–>

Thank you, that does help, although won’t really give them what they want. We have tons of (awesome) reports in Access thru ODBC and they want many of those turned into dashboards in Epicor. But without the ability to save and re-access subqueries I am having a heck of a time reproducing (not to mention the “bug” that exists on multiple summary tables being a sever limitation also)… thanks for the feedback I sincerely appreciate it

 

 

Sarah Vareschi â–ª Systems Manager â–ª NyproMold â–ª 978-368-4718

<!-- #ygrps-yiv-1579545243 _filtered #ygrps-yiv-1579545243 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-1579545243 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-1579545243 {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #ygrps-yiv-1579545243 {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #ygrps-yiv-1579545243 {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} #ygrps-yiv-1579545243 #ygrps-yiv-1579545243 p.ygrps-yiv-1579545243MsoNormal, #ygrps-yiv-1579545243 li.ygrps-yiv-1579545243MsoNormal, #ygrps-yiv-1579545243 div.ygrps-yiv-1579545243MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman", "serif";} #ygrps-yiv-1579545243 a:link, #ygrps-yiv-1579545243 span.ygrps-yiv-1579545243MsoHyperlink { color:blue; text-decoration:underline;} #ygrps-yiv-1579545243 a:visited, #ygrps-yiv-1579545243 span.ygrps-yiv-1579545243MsoHyperlinkFollowed { color:purple; text-decoration:underline;} #ygrps-yiv-1579545243 p {

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1579545243 code
{
font-family:“Courier New”;}
#ygrps-yiv-1579545243 pre
{

margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:“Courier New”;}
#ygrps-yiv-1579545243 tt
{
font-family:“Courier New”;}
#ygrps-yiv-1579545243 span.ygrps-yiv-1579545243cat
{}
#ygrps-yiv-1579545243 span.ygrps-yiv-1579545243ct
{}
#ygrps-yiv-1579545243 span.ygrps-yiv-1579545243HTMLPreformattedChar
{

font-family:Consolas;}
#ygrps-yiv-1579545243 p.ygrps-yiv-1579545243attach, #ygrps-yiv-1579545243 li.ygrps-yiv-1579545243attach, #ygrps-yiv-1579545243 div.ygrps-yiv-1579545243attach
{

margin-right:0in;

margin-left:0in;
font-size:9.0pt;
font-family:“Arial”, “sans-serif”;}
#ygrps-yiv-1579545243 p.ygrps-yiv-1579545243bold, #ygrps-yiv-1579545243 li.ygrps-yiv-1579545243bold, #ygrps-yiv-1579545243 div.ygrps-yiv-1579545243bold
{

margin-right:0in;

margin-left:0in;
font-size:10.0pt;
font-family:“Arial”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-1579545243 p.ygrps-yiv-1579545243green, #ygrps-yiv-1579545243 li.ygrps-yiv-1579545243green, #ygrps-yiv-1579545243 div.ygrps-yiv-1579545243green
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
color:#628C2A;}
#ygrps-yiv-1579545243 p.ygrps-yiv-1579545243replbq, #ygrps-yiv-1579545243 li.ygrps-yiv-1579545243replbq, #ygrps-yiv-1579545243 div.ygrps-yiv-1579545243replbq
{
margin:3.0pt;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1579545243 p.ygrps-yiv-1579545243ad, #ygrps-yiv-1579545243 li.ygrps-yiv-1579545243ad, #ygrps-yiv-1579545243 div.ygrps-yiv-1579545243ad
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1579545243 p.ygrps-yiv-1579545243underline, #ygrps-yiv-1579545243 li.ygrps-yiv-1579545243underline, #ygrps-yiv-1579545243 div.ygrps-yiv-1579545243underline
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1579545243 span.ygrps-yiv-1579545243yshortcuts
{}
#ygrps-yiv-1579545243 p.ygrps-yiv-1579545243ad1, #ygrps-yiv-1579545243 li.ygrps-yiv-1579545243ad1, #ygrps-yiv-1579545243 div.ygrps-yiv-1579545243ad1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1579545243 p.ygrps-yiv-1579545243ad2, #ygrps-yiv-1579545243 li.ygrps-yiv-1579545243ad2, #ygrps-yiv-1579545243 div.ygrps-yiv-1579545243ad2
{

margin-right:0in;
margin-bottom:7.5pt;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1579545243 p.ygrps-yiv-1579545243underline1, #ygrps-yiv-1579545243 li.ygrps-yiv-1579545243underline1, #ygrps-yiv-1579545243 div.ygrps-yiv-1579545243underline1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
text-decoration:underline;}
#ygrps-yiv-1579545243 span.ygrps-yiv-1579545243yshortcuts1
{
font-family:“Verdana”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-1579545243 span.ygrps-yiv-1579545243yshortcuts2
{
font-family:“Verdana”, “sans-serif”;
font-weight:normal;}
#ygrps-yiv-1579545243 span.ygrps-yiv-1579545243EmailStyle36
{
font-family:“Calibri”, “sans-serif”;
color:#1F497D;}
#ygrps-yiv-1579545243 .ygrps-yiv-1579545243MsoChpDefault
{
font-size:10.0pt;}
_filtered #ygrps-yiv-1579545243 {
margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-1579545243 div.ygrps-yiv-1579545243WordSection1
{}
#ygrps-yiv-1579545243
_filtered #ygrps-yiv-1579545243 {
}
_filtered #ygrps-yiv-1579545243 {

font-family:Symbol;}
_filtered #ygrps-yiv-1579545243 {

font-family:“Courier New”;
}
_filtered #ygrps-yiv-1579545243 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1579545243 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1579545243 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1579545243 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1579545243 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1579545243 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1579545243 {

font-family:Wingdings;}
#ygrps-yiv-1579545243 ol
{margin-bottom:0in;}
#ygrps-yiv-1579545243 ul
{margin-bottom:0in;}
–>

Hi All - I have been asked to generate a dashboard showing the job information along with total job cost, estimated cost remaining (etc) and total sales value all in one dashboard. I am working in the BAQ and when I try to total up the Sales Value it is not returning anything. This requires 2 summary tables which I guess is the issue, it summarizes the first linked summary table JobProd but will not summarize the orderdtl table – it returns blank. I am just wondering if anyone has been asked to make a similar dashboard and has been successful. This is driving me crazy!

 

Any tips or advice would be greatly appreciated!

 

Thanks,

Sarah

From what I remember reading on the board, multiple linked summarized tables does not work on 702A.  I think that was it.

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, December 11, 2014 8:58 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9 702A - BAQ - Total Sales value / Job Info/ Total Cost

 

 

Hi All - I have been asked to generate a dashboard showing the job information along with total job cost, estimated cost remaining (etc) and total sales value all in one dashboard.  I am working in the BAQ and when I try to total up the Sales Value it is not returning anything.  This requires 2 summary tables which I guess is the issue, it summarizes the first linked summary table JobProd but will not summarize the orderdtl table – it returns blank.  I am just wondering if anyone has been asked to make a similar dashboard and has been successful.  This is driving me crazy!

 

Any tips or advice would be greatly appreciated!

 

Thanks,

Sarah

I would build 2 different queries, one for total job cost and one for sales value. Then you can show both queries in the dashboard. I build a lot of stuff like this (we are very heavily project and job based). I build 1 query with just a list of projects so the user can pick their project. Then publish the project ID.  I would then build the other 2 dashboards to filter off the project id selected and show the job costs and the sales stuff side by side or in different tabs. 

Hope this idea helps. 

-BObby
I tried it also, the same BAQ with multiple summarized table works on 702 (or newer, don't sure), but doesn't work on 701.
<!-- #ygrps-yiv-1792855673 _filtered #ygrps-yiv-1792855673 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-1792855673 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-1792855673 {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #ygrps-yiv-1792855673 {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #ygrps-yiv-1792855673 {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} #ygrps-yiv-1792855673 #ygrps-yiv-1792855673 p.ygrps-yiv-1792855673MsoNormal, #ygrps-yiv-1792855673 li.ygrps-yiv-1792855673MsoNormal, #ygrps-yiv-1792855673 div.ygrps-yiv-1792855673MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman", "serif";} #ygrps-yiv-1792855673 a:link, #ygrps-yiv-1792855673 span.ygrps-yiv-1792855673MsoHyperlink { color:blue; text-decoration:underline;} #ygrps-yiv-1792855673 a:visited, #ygrps-yiv-1792855673 span.ygrps-yiv-1792855673MsoHyperlinkFollowed { color:purple; text-decoration:underline;} #ygrps-yiv-1792855673 p {

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1792855673 code
{
font-family:“Courier New”;}
#ygrps-yiv-1792855673 pre
{

margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:“Courier New”;}
#ygrps-yiv-1792855673 tt
{
font-family:“Courier New”;}
#ygrps-yiv-1792855673 span.ygrps-yiv-1792855673cat
{}
#ygrps-yiv-1792855673 span.ygrps-yiv-1792855673ct
{}
#ygrps-yiv-1792855673 span.ygrps-yiv-1792855673HTMLPreformattedChar
{

font-family:Consolas;}
#ygrps-yiv-1792855673 p.ygrps-yiv-1792855673attach, #ygrps-yiv-1792855673 li.ygrps-yiv-1792855673attach, #ygrps-yiv-1792855673 div.ygrps-yiv-1792855673attach
{

margin-right:0in;

margin-left:0in;
font-size:9.0pt;
font-family:“Arial”, “sans-serif”;}
#ygrps-yiv-1792855673 p.ygrps-yiv-1792855673bold, #ygrps-yiv-1792855673 li.ygrps-yiv-1792855673bold, #ygrps-yiv-1792855673 div.ygrps-yiv-1792855673bold
{

margin-right:0in;

margin-left:0in;
font-size:10.0pt;
font-family:“Arial”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-1792855673 p.ygrps-yiv-1792855673green, #ygrps-yiv-1792855673 li.ygrps-yiv-1792855673green, #ygrps-yiv-1792855673 div.ygrps-yiv-1792855673green
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
color:#628C2A;}
#ygrps-yiv-1792855673 p.ygrps-yiv-1792855673replbq, #ygrps-yiv-1792855673 li.ygrps-yiv-1792855673replbq, #ygrps-yiv-1792855673 div.ygrps-yiv-1792855673replbq
{
margin:3.0pt;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1792855673 p.ygrps-yiv-1792855673ad, #ygrps-yiv-1792855673 li.ygrps-yiv-1792855673ad, #ygrps-yiv-1792855673 div.ygrps-yiv-1792855673ad
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1792855673 p.ygrps-yiv-1792855673underline, #ygrps-yiv-1792855673 li.ygrps-yiv-1792855673underline, #ygrps-yiv-1792855673 div.ygrps-yiv-1792855673underline
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1792855673 span.ygrps-yiv-1792855673yshortcuts
{}
#ygrps-yiv-1792855673 p.ygrps-yiv-1792855673ad1, #ygrps-yiv-1792855673 li.ygrps-yiv-1792855673ad1, #ygrps-yiv-1792855673 div.ygrps-yiv-1792855673ad1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1792855673 p.ygrps-yiv-1792855673ad2, #ygrps-yiv-1792855673 li.ygrps-yiv-1792855673ad2, #ygrps-yiv-1792855673 div.ygrps-yiv-1792855673ad2
{

margin-right:0in;
margin-bottom:7.5pt;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1792855673 p.ygrps-yiv-1792855673underline1, #ygrps-yiv-1792855673 li.ygrps-yiv-1792855673underline1, #ygrps-yiv-1792855673 div.ygrps-yiv-1792855673underline1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
text-decoration:underline;}
#ygrps-yiv-1792855673 span.ygrps-yiv-1792855673yshortcuts1
{
font-family:“Verdana”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-1792855673 span.ygrps-yiv-1792855673yshortcuts2
{
font-family:“Verdana”, “sans-serif”;
font-weight:normal;}
#ygrps-yiv-1792855673 span.ygrps-yiv-1792855673EmailStyle36
{
font-family:“Calibri”, “sans-serif”;
color:#1F497D;}
#ygrps-yiv-1792855673 .ygrps-yiv-1792855673MsoChpDefault
{
font-size:10.0pt;}
_filtered #ygrps-yiv-1792855673 {
margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-1792855673 div.ygrps-yiv-1792855673WordSection1
{}
#ygrps-yiv-1792855673
_filtered #ygrps-yiv-1792855673 {
}
_filtered #ygrps-yiv-1792855673 {

font-family:Symbol;}
_filtered #ygrps-yiv-1792855673 {

font-family:“Courier New”;
}
_filtered #ygrps-yiv-1792855673 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1792855673 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1792855673 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1792855673 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1792855673 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1792855673 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1792855673 {

font-family:Wingdings;}
#ygrps-yiv-1792855673 ol
{margin-bottom:0in;}
#ygrps-yiv-1792855673 ul
{margin-bottom:0in;}
–>

yclhk@… : Could you share how you got it to work? I am on 702a. I have jobhead joined to JobProd joined to Orderdtl. Both jobprod and orderdtl as summary tables with a calculated aggregate field on each. Only the jobprod field is displaying, the orderdtl aggregate field is coming up blank?Â