Report Calculated Fields


(system) #1

Its my understanding that you have to own SDK to see the calc fields.

www.practicaltek.com

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of tom.sederquist@...
Sent: Tuesday, November 05, 2013 6:05 PM
To: vantage@yahoogroups.com
Subject: RE: RE: [Vantage] RE: Report Calculated Fields

 

 

Is there any way to view the formula for the calculated field without the developer program?  I would like to know which fields are being brought into the formula so that I can determine where the data is being pulled from.



---In vantage@yahoogroups.com, <cathy@...> wrote:

What is the name of the field you are trying to change?     If it is a calculated report field (like Calc_PartDescription) you can’t change it in the Report Data Definition without some developer program.

 

Find the database field that you need and replace the report calculated field on the report.  It might be excluded from the table – so you  might have to add it Report Table > Excluded Fields.

 

I not sure if you will need a formula.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of smyers@...
Sent: Tuesday, November 05, 2013 10:19 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Report Calculated Fields

 

 

Thanks for your suggestion, but this does not solve my problem.  The report is not a BAQ report, but a duplicate of a standard report data definition (BOMListing), with just a few tweaks compared to the standard report.

 

Thanks,

 

Steven



---In vantage@yahoogroups.com, <pjw@...> wrote:

If it’s from a BAQ make sure it’s also formatted for more than 30 characters.

 

Patrick Winter

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of smyers@...
Sent: Monday, November 04, 2013 04:44
To: vantage@yahoogroups.com
Subject: [Vantage] Report Calculated Fields

 

 

Does anyone know how to see changes made to a report calculated field actually in effect on a crystal report? 

 

I have changed the format of a character field from x30 to x500 but it still shows x30 in the report.  This is for a description field which must be shown in full.

 

Epicor 9.05.702

 

Thanks,

 

Steven


(system) #2

Does anyone know how to see changes made to a report calculated field actually in effect on a crystal report? 

 

I have changed the format of a character field from x30 to x500 but it still shows x30 in the report.  This is for a description field which must be shown in full.

 

Epicor 9.05.702

 

Thanks,

 

Steven


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

margin-right:0in;

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

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

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

margin-right:0in;

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

margin-right:0in;

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

margin-right:0in;

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

margin-right:0in;

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

margin-right:0in;

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

margin-right:0in;

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

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

margin-right:0in;

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

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

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

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

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

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

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

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

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

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

If it’s from a BAQ make sure it’s also formatted for more than 30 characters.

 

Patrick Winter

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of smyers@…
Sent: Monday, November 04, 2013 04:44
To: vantage@yahoogroups.com
Subject: [Vantage] Report Calculated Fields

 

 

Does anyone know how to see changes made to a report calculated field actually in effect on a crystal report? 

 

I have changed the format of a character field from x30 to x500 but it still shows x30 in the report.  This is for a description field which must be shown in full.

 

Epicor 9.05.702

 

Thanks,

 

Steven


(system) #4

Thanks for your suggestion, but this does not solve my problem.  The report is not a BAQ report, but a duplicate of a standard report data definition (BOMListing), with just a few tweaks compared to the standard report.

 

Thanks,

 

Steven



---In vantage@yahoogroups.com, <pjw@...> wrote:

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

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

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

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

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

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

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

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

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

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

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

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

font-family:Symbol;}
#ygrps-yiv-1821681160 filtered #ygrps-yiv-1821681160ygrps-yiv-1403877452 {

font-family:“Courier New”;}
#ygrps-yiv-1821681160 filtered #ygrps-yiv-1821681160ygrps-yiv-1403877452 {

font-family:Wingdings;}
#ygrps-yiv-1821681160 filtered #ygrps-yiv-1821681160ygrps-yiv-1403877452 {

font-family:Wingdings;}
#ygrps-yiv-1821681160 filtered #ygrps-yiv-1821681160ygrps-yiv-1403877452 {

font-family:Wingdings;}
#ygrps-yiv-1821681160 filtered #ygrps-yiv-1821681160ygrps-yiv-1403877452 {

font-family:Wingdings;}
#ygrps-yiv-1821681160 filtered #ygrps-yiv-1821681160ygrps-yiv-1403877452 {

font-family:Wingdings;}
#ygrps-yiv-1821681160 filtered #ygrps-yiv-1821681160ygrps-yiv-1403877452 {

font-family:Wingdings;}
#ygrps-yiv-1821681160 filtered #ygrps-yiv-1821681160ygrps-yiv-1403877452 {

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

If it’s from a BAQ make sure it’s also formatted for more than 30 characters.

 

Patrick Winter

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of smyers@…
Sent: Monday, November 04, 2013 04:44
To: vantage@yahoogroups.com
Subject: [Vantage] Report Calculated Fields

 

 

Does anyone know how to see changes made to a report calculated field actually in effect on a crystal report? 

 

I have changed the format of a character field from x30 to x500 but it still shows x30 in the report.  This is for a description field which must be shown in full.

 

Epicor 9.05.702

 

Thanks,

 

Steven



(system) #5

Have you tried opening the XML file in a test viewer and looking at the raw values?

My guess is that the RDD does not include that many characters.

If so, I don't think you'll be out of luck.



---In vantage@yahoogroups.com, <smyers@...> wrote:

Thanks for your suggestion, but this does not solve my problem.  The report is not a BAQ report, but a duplicate of a standard report data definition (BOMListing), with just a few tweaks compared to the standard report.

 

Thanks,

 

Steven



---In vantage@yahoogroups.com, <pjw@...> wrote:

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

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

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

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

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

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

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

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

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

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

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

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

font-family:Symbol;}
#ygrps-yiv-1408173774 #ygrps-yiv-1408173774ygrps-yiv-2103621787 filtered #ygrps-yiv-1408173774ygrps-yiv-2103621787ygrps-yiv-1403877452 {

font-family:“Courier New”;}
#ygrps-yiv-1408173774 #ygrps-yiv-1408173774ygrps-yiv-2103621787 filtered #ygrps-yiv-1408173774ygrps-yiv-2103621787ygrps-yiv-1403877452 {

font-family:Wingdings;}
#ygrps-yiv-1408173774 #ygrps-yiv-1408173774ygrps-yiv-2103621787 filtered #ygrps-yiv-1408173774ygrps-yiv-2103621787ygrps-yiv-1403877452 {

font-family:Wingdings;}
#ygrps-yiv-1408173774 #ygrps-yiv-1408173774ygrps-yiv-2103621787 filtered #ygrps-yiv-1408173774ygrps-yiv-2103621787ygrps-yiv-1403877452 {

font-family:Wingdings;}
#ygrps-yiv-1408173774 #ygrps-yiv-1408173774ygrps-yiv-2103621787 filtered #ygrps-yiv-1408173774ygrps-yiv-2103621787ygrps-yiv-1403877452 {

font-family:Wingdings;}
#ygrps-yiv-1408173774 #ygrps-yiv-1408173774ygrps-yiv-2103621787 filtered #ygrps-yiv-1408173774ygrps-yiv-2103621787ygrps-yiv-1403877452 {

font-family:Wingdings;}
#ygrps-yiv-1408173774 #ygrps-yiv-1408173774ygrps-yiv-2103621787 filtered #ygrps-yiv-1408173774ygrps-yiv-2103621787ygrps-yiv-1403877452 {

font-family:Wingdings;}
#ygrps-yiv-1408173774 #ygrps-yiv-1408173774ygrps-yiv-2103621787 filtered #ygrps-yiv-1408173774ygrps-yiv-2103621787ygrps-yiv-1403877452 {

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

If it’s from a BAQ make sure it’s also formatted for more than 30 characters.

 

Patrick Winter

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of smyers@…
Sent: Monday, November 04, 2013 04:44
To: vantage@yahoogroups.com
Subject: [Vantage] Report Calculated Fields

 

 

Does anyone know how to see changes made to a report calculated field actually in effect on a crystal report? 

 

I have changed the format of a character field from x30 to x500 but it still shows x30 in the report.  This is for a description field which must be shown in full.

 

Epicor 9.05.702

 

Thanks,

 

Steven




(system) #6

What is the name of the field you are trying to change?    If it is a calculated report field (like Calc_PartDescription) you can’t change it in the Report Data Definition without some developer program.

 

Find the database field that you need and replace the report calculated field on the report. It might be excluded from the table – so you might have to add it Report Table > Excluded Fields.

 

I not sure if you will need a formula.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of smyers@...
Sent: Tuesday, November 05, 2013 10:19 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Report Calculated Fields

 

 

Thanks for your suggestion, but this does not solve my problem.  The report is not a BAQ report, but a duplicate of a standard report data definition (BOMListing), with just a few tweaks compared to the standard report.

 

Thanks,

 

Steven



---In vantage@yahoogroups.com, <pjw@...> wrote:

If it’s from a BAQ make sure it’s also formatted for more than 30 characters.

 

Patrick Winter

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of smyers@...
Sent: Monday, November 04, 2013 04:44
To: vantage@yahoogroups.com
Subject: [Vantage] Report Calculated Fields

 

 

Does anyone know how to see changes made to a report calculated field actually in effect on a crystal report? 

 

I have changed the format of a character field from x30 to x500 but it still shows x30 in the report.  This is for a description field which must be shown in full.

 

Epicor 9.05.702

 

Thanks,

 

Steven


(system) #7

Is there any way to view the formula for the calculated field without the developer program?  I would like to know which fields are being brought into the formula so that I can determine where the data is being pulled from.



---In vantage@yahoogroups.com, <cathy@...> wrote:

What is the name of the field you are trying to change?     If it is a calculated report field (like Calc_PartDescription) you can’t change it in the Report Data Definition without some developer program.

 

Find the database field that you need and replace the report calculated field on the report.  It might be excluded from the table – so you  might have to add it Report Table > Excluded Fields.

 

I not sure if you will need a formula.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of smyers@...
Sent: Tuesday, November 05, 2013 10:19 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Report Calculated Fields

 

 

Thanks for your suggestion, but this does not solve my problem.  The report is not a BAQ report, but a duplicate of a standard report data definition (BOMListing), with just a few tweaks compared to the standard report.

 

Thanks,

 

Steven



---In vantage@yahoogroups.com, <pjw@...> wrote:

If it’s from a BAQ make sure it’s also formatted for more than 30 characters.

 

Patrick Winter

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of smyers@...
Sent: Monday, November 04, 2013 04:44
To: vantage@yahoogroups.com
Subject: [Vantage] Report Calculated Fields

 

 

Does anyone know how to see changes made to a report calculated field actually in effect on a crystal report? 

 

I have changed the format of a character field from x30 to x500 but it still shows x30 in the report.  This is for a description field which must be shown in full.

 

Epicor 9.05.702

 

Thanks,

 

Steven