Epicor 9 - Report Styles

Yahoo Archive
1

Better yet, after seeing Bill's Email..


SELECT distinct StyleNum,StyleDescription,CompanyList,RptDefID FROM ReportStyle where stylenum > 999 order by rptdefid


2

Is there an easy way to find out if a report style is actually in use or an option for a report?


Bill Turgeon
Director, Information Technology
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com

Please consider the environment before printing this email.
This e-mail and any attachments are for the sole use of the intended recipients and may be privileged or confidential. Any distribution, printing or other use by anyone else is prohibited. If you are not an intended recipient, please contact the sender immediately, and permanently delete this e-mail and attachments.

“Come visit Coto Technology at Sensors Expo Booth #138 in Long Beach, June 10-11, to see the RedRock RR100 and all of our other Switch, Sensor, and Relay Solutions!”
3

I can tell you this…

If it is marked Valid then they can choose it…if it is marked default then that is the option displayed first when printing.

If you want to know which is being used put the name of the style in the footer of the form.

 

Manasa

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 07, 2015 9:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9 - Report Styles

 

 

Is there an easy way to find out if a report style is actually in use or an option for a report?

 

Bill Turgeon

Director, Information Technology
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com

Please consider the environment before printing this email.
This e-mail and any attachments are for the sole use of the intended recipients and may be privileged or confidential. Any distribution, printing or other use by anyone else is prohibited. If you are not an intended recipient, please contact the sender immediately, and permanently delete this e-mail and attachments.


“Come visit Coto Technology at Sensors Expo Booth #138 in Long Beach, June 10-11, to see the RedRock RR100 and all of our other Switch, Sensor, and Relay Solutions!”

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.
4

I am trying to figure out which RDD’s and Report Styles I need to recreate for E10.

If they are not used, I don’t want to waste the effort.

I am looking for a way to see if the report style is available for a menu item without having to open every single report to see if it’s there.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 07, 2015 10:19 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Epicor 9 - Report Styles

 

 

I can tell you this…

If it is marked Valid then they can choose it…if it is marked default then that is the option displayed first when printing.

If you want to know which is being used put the name of the style in the footer of the form.

 

Manasa

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 07, 2015 9:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9 - Report Styles

 

 

Is there an easy way to find out if a report style is actually in use or an option for a report?

 

Bill Turgeon

Director, Information Technology
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com

Please consider the environment before printing this email.
This e-mail and any attachments are for the sole use of the intended recipients and may be privileged or confidential. Any distribution, printing or other use by anyone else is prohibited. If you are not an intended recipient, please contact the sender immediately, and permanently delete this e-mail and attachments.


“Come visit Coto Technology at Sensors Expo Booth #138 in Long Beach, June 10-11, to see the RedRock RR100 and all of our other Switch, Sensor, and Relay Solutions!”

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.


Bill Turgeon
Director, Information Technology
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com

Please consider the environment before printing this email.
This e-mail and any attachments are for the sole use of the intended recipients and may be privileged or confidential. Any distribution, printing or other use by anyone else is prohibited. If you are not an intended recipient, please contact the sender immediately, and permanently delete this e-mail and attachments.
5

Yep that completely went over my head…sorry I got nothing!

 

Mansaa

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 07, 2015 10:23 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Epicor 9 - Report Styles

 

 

I am trying to figure out which RDD’s and Report Styles I need to recreate for E10.

If they are not used, I don’t want to waste the effort.

I am looking for a way to see if the report style is available for a menu item without having to open every single report to see if it’s there.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 07, 2015 10:19 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Epicor 9 - Report Styles

 

 

I can tell you this…

If it is marked Valid then they can choose it…if it is marked default then that is the option displayed first when printing.

If you want to know which is being used put the name of the style in the footer of the form.

 

Manasa

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 07, 2015 9:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9 - Report Styles

 

 

Is there an easy way to find out if a report style is actually in use or an option for a report?

 

Bill Turgeon

Director, Information Technology
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com

Please consider the environment before printing this email.
This e-mail and any attachments are for the sole use of the intended recipients and may be privileged or confidential. Any distribution, printing or other use by anyone else is prohibited. If you are not an intended recipient, please contact the sender immediately, and permanently delete this e-mail and attachments.


“Come visit Coto Technology at Sensors Expo Booth #138 in Long Beach, June 10-11, to see the RedRock RR100 and all of our other Switch, Sensor, and Relay Solutions!”

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

 

Bill Turgeon

Director, Information Technology
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com

Please consider the environment before printing this email.
This e-mail and any attachments are for the sole use of the intended recipients and may be privileged or confidential. Any distribution, printing or other use by anyone else is prohibited. If you are not an intended recipient, please contact the sender immediately, and permanently delete this e-mail and attachments.

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.
6
I don't know of an easy way to see where, if anywhere, a report can be launched from, but I do know that reports can be launched from action menus or scripts, so even if you manually check every menu item you still won't have a definitive list of every report that can be run.



On Thursday, May 7, 2015 10:24 AM, "'Turgeon, Bill' Bill.Turgeon@... [vantage]" <vantage@yahoogroups.com> wrote:


  
<div id="ygrps-yiv-811562962yiv8458250091ygrp-text">
  
  
  <div>
I am trying to figure out which RDD’s and Report Styles I need to recreate for E10.
If they are not used, I don’t want to waste the effort.
I am looking for a way to see if the report style is available for a menu item without having to open every single report to see if it’s there.
 
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 07, 2015 10:19 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Epicor 9 - Report Styles
 
 
I can tell you this…
If it is marked Valid then they can choose it…if it is marked default then that is the option displayed first when printing.
If you want to know which is being used put the name of the style in the footer of the form.
 
Manasa
 
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 07, 2015 9:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9 - Report Styles
 
 
Is there an easy way to find out if a report style is actually in use or an option for a report?
 
Bill Turgeon
Director, Information Technology
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com

Please consider the environment before printing this email.
This e-mail and any attachments are for the sole use of the intended recipients and may be privileged or confidential. Any distribution, printing or other use by anyone else is prohibited. If you are not an intended recipient, please contact the sender immediately, and permanently delete this e-mail and attachments.

“Come visit Coto Technology at Sensors Expo Booth #138 in Long Beach, June 10-11, to see the RedRock RR100 and all of our other Switch, Sensor, and Relay Solutions!”
IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.
IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

Bill Turgeon
Director, Information Technology
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com

Please consider the environment before printing this email.
This e-mail and any attachments are for the sole use of the intended recipients and may be privileged or confidential. Any distribution, printing or other use by anyone else is prohibited. If you are not an intended recipient, please contact the sender immediately, and permanently delete this e-mail and attachments. 
</div>
 


<div class="ygrps-yiv-811562962yiv8458250091yqt3072947797" id="ygrps-yiv-811562962yiv8458250091yqt57383"><div style="height:0px;color:rgb(255, 255, 255);"></div></div>
#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091 -- #ygrps-yiv-811562962yiv8458250091ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-mkp #ygrps-yiv-811562962yiv8458250091hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-mkp #ygrps-yiv-811562962yiv8458250091ads {
margin-bottom:10px;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-mkp .ygrps-yiv-811562962yiv8458250091ad {
padding:0 0;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-mkp .ygrps-yiv-811562962yiv8458250091ad p {
margin:0;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-mkp .ygrps-yiv-811562962yiv8458250091ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-sponsor #ygrps-yiv-811562962yiv8458250091ygrp-lc {
font-family:Arial;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-sponsor #ygrps-yiv-811562962yiv8458250091ygrp-lc #ygrps-yiv-811562962yiv8458250091hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-sponsor #ygrps-yiv-811562962yiv8458250091ygrp-lc .ygrps-yiv-811562962yiv8458250091ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091activity span {
font-weight:700;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091activity span span {
color:#ff7900;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091activity span .ygrps-yiv-811562962yiv8458250091underline {
text-decoration:underline;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 .ygrps-yiv-811562962yiv8458250091attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 .ygrps-yiv-811562962yiv8458250091attach div a {
text-decoration:none;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 .ygrps-yiv-811562962yiv8458250091attach img {
border:none;padding-right:5px;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 .ygrps-yiv-811562962yiv8458250091attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 .ygrps-yiv-811562962yiv8458250091attach label a {
text-decoration:none;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 .ygrps-yiv-811562962yiv8458250091bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 .ygrps-yiv-811562962yiv8458250091bold a {
text-decoration:none;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 dd.ygrps-yiv-811562962yiv8458250091last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 dd.ygrps-yiv-811562962yiv8458250091last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 dd.ygrps-yiv-811562962yiv8458250091last p span.ygrps-yiv-811562962yiv8458250091yshortcuts {
margin-right:0;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 div.ygrps-yiv-811562962yiv8458250091attach-table div div a {
text-decoration:none;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 div.ygrps-yiv-811562962yiv8458250091attach-table {
width:400px;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 div.ygrps-yiv-811562962yiv8458250091file-title a, #ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 div.ygrps-yiv-811562962yiv8458250091file-title a:active, #ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 div.ygrps-yiv-811562962yiv8458250091file-title a:hover, #ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 div.ygrps-yiv-811562962yiv8458250091file-title a:visited {
text-decoration:none;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 div.ygrps-yiv-811562962yiv8458250091photo-title a, #ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 div.ygrps-yiv-811562962yiv8458250091photo-title a:active, #ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 div.ygrps-yiv-811562962yiv8458250091photo-title a:hover, #ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 div.ygrps-yiv-811562962yiv8458250091photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 div#ygrps-yiv-811562962yiv8458250091ygrp-mlmsg #ygrps-yiv-811562962yiv8458250091ygrp-msg p a span.ygrps-yiv-811562962yiv8458250091yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 .ygrps-yiv-811562962yiv8458250091green {
color:#628c2a;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 .ygrps-yiv-811562962yiv8458250091MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 o {
font-size:0;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091photos div {
float:left;width:72px;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091reco-category {
font-size:77%;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091reco-desc {
font-size:77%;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 .ygrps-yiv-811562962yiv8458250091replbq {
margin:4px;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-mlmsg select, #ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 input, #ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-mlmsg pre, #ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 code {
font:115% monospace;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-mlmsg #ygrps-yiv-811562962yiv8458250091logo {
padding-bottom:10px;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-msg p#ygrps-yiv-811562962yiv8458250091attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-reco #ygrps-yiv-811562962yiv8458250091reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-sponsor #ygrps-yiv-811562962yiv8458250091ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-sponsor #ygrps-yiv-811562962yiv8458250091ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-sponsor #ygrps-yiv-811562962yiv8458250091ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-text {
font-family:Georgia;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-text tt {
font-size:120%;}

#ygrps-yiv-811562962 #ygrps-yiv-811562962yiv8458250091 #ygrps-yiv-811562962yiv8458250091ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-811562962



7

This is why I was hoping there was a table somewhere holding this information.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 07, 2015 11:14 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] RE: Epicor 9 - Report Styles

 

 

I don't know of an easy way to see where, if anywhere, a report can be launched from, but I do know that reports can be launched from action menus or scripts, so even if you manually check every menu item you still won't have a definitive list of every report that can be run.

 

 

On Thursday, May 7, 2015 10:24 AM, "'Turgeon, Bill' Bill.Turgeon@... [vantage]" <vantage@yahoogroups.com> wrote:

 

 

I am trying to figure out which RDD’s and Report Styles I need to recreate for E10.

If they are not used, I don’t want to waste the effort.

I am looking for a way to see if the report style is available for a menu item without having to open every single report to see if it’s there.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 07, 2015 10:19 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Epicor 9 - Report Styles

 

 

I can tell you this…

If it is marked Valid then they can choose it…if it is marked default then that is the option displayed first when printing.

If you want to know which is being used put the name of the style in the footer of the form.

 

Manasa

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 07, 2015 9:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9 - Report Styles

 

 

Is there an easy way to find out if a report style is actually in use or an option for a report?

 

Bill Turgeon

Director, Information Technology
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com

Please consider the environment before printing this email.
This e-mail and any attachments are for the sole use of the intended recipients and may be privileged or confidential. Any distribution, printing or other use by anyone else is prohibited. If you are not an intended recipient, please contact the sender immediately, and permanently delete this e-mail and attachments.


“Come visit Coto Technology at Sensors Expo Booth #138 in Long Beach, June 10-11, to see the RedRock RR100 and all of our other Switch, Sensor, and Relay Solutions!”

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

 

Bill Turgeon

Director, Information Technology
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com

Please consider the environment before printing this email.
This e-mail and any attachments are for the sole use of the intended recipients and may be privileged or confidential. Any distribution, printing or other use by anyone else is prohibited. If you are not an intended recipient, please contact the sender immediately, and permanently delete this e-mail and attachments.

 


Bill Turgeon
Director, Information Technology
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com

Please consider the environment before printing this email.
This e-mail and any attachments are for the sole use of the intended recipients and may be privileged or confidential. Any distribution, printing or other use by anyone else is prohibited. If you are not an intended recipient, please contact the sender immediately, and permanently delete this e-mail and attachments.
8
The Report table lists the reports. The ReportStyle table lists the styles available for each report (link with report ID) and also lists the RDDs used for the style. The Report Type table lists the type of report the style is such as Crystal, SSRS, or base (link with RptTypeID). Filter out Epicor standard reports and you'll be left with your custom reports (ours have style numbers 1000+). This will also tell you which RDDs are being used. The only thing it won't tell you is if anyone is actually picking the style and using it!

Sue


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

I am trying to figure out which RDD’s and Report Styles I need to recreate for E10.

If they are not used, I don’t want to waste the effort.

I am looking for a way to see if the report style is available for a menu item without having to open every single report to see if it’s there.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 07, 2015 10:19 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Epicor 9 - Report Styles

 

 

I can tell you this…

If it is marked Valid then they can choose it…if it is marked default then that is the option displayed first when printing.

If you want to know which is being used put the name of the style in the footer of the form.

 

Manasa

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 07, 2015 9:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9 - Report Styles

 

 

Is there an easy way to find out if a report style is actually in use or an option for a report?

 

Bill Turgeon

Director, Information Technology
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com

Please consider the environment before printing this email.
This e-mail and any attachments are for the sole use of the intended recipients and may be privileged or confidential. Any distribution, printing or other use by anyone else is prohibited. If you are not an intended recipient, please contact the sender immediately, and permanently delete this e-mail and attachments.


“Come visit Coto Technology at Sensors Expo Booth #138 in Long Beach, June 10-11, to see the RedRock RR100 and all of our other Switch, Sensor, and Relay Solutions!”

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.


Bill Turgeon
Director, Information Technology
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com

Please consider the environment before printing this email.
This e-mail and any attachments are for the sole use of the intended recipients and may be privileged or confidential. Any distribution, printing or other use by anyone else is prohibited. If you are not an intended recipient, please contact the sender immediately, and permanently delete this e-mail and attachments.
9

These two quick scripts may help you get where you need to be. I tested against the POFORM in our DB. IF you come up with something better, shoot it back to us.

/****** Report Styles in Use ******/


/* CompanyList shows where it's active

        It will say 'none'

        or have a tilde-delimited list

        or be blank (for ALL companies)

*/


SELECT [ReportID]

,[StyleNum]

,[StyleDescription]

,[RptTypeID]

,[PrintProgram]

,[PrintProgramOptions]

,[RptDefID]

,[CompanyList]

,[ServerNum]

,[OutputLocation]

FROM [Epicor905].[dbo].[ReportStyle]

where stylenum > 999 and ReportID='poform'


/****** Default Report Style ******/

SELECT rds.[ReportID]

,rds.[Company]

,rds.[StyleNum] as DefaultStyleNum

,StyleDescription as DefaultReportStyle

FROM [Epicor905].[dbo].[ReportDefaultStyle] rds join [Epicor905].[dbo].[ReportStyle] rs

on rds.ReportID=rs.ReportID and rds.StyleNum=rs.StyleNum

where rds.ReportID = 'POFORM'


10

Excellent!  Just what I needed.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, May 08, 2015 8:10 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Epicor 9 - Report Styles

 

 

These two quick scripts may help you get where you need to be. I tested against the POFORM in our DB. IF you come up with something better, shoot it back to us.

/****** Report Styles in Use ******/

 

/* CompanyList shows where it's active

        It will say 'none'

        or have a tilde-delimited list

        or be blank (for ALL companies)

*/

 

SELECT [ReportID]

,[StyleNum]

,[StyleDescription]

,[RptTypeID]

,[PrintProgram]

,[PrintProgramOptions]

,[RptDefID]

,[CompanyList]

,[ServerNum]

,[OutputLocation]

FROM [Epicor905].[dbo].[ReportStyle]

where stylenum

> 999 and ReportID='poform'

 

/****** Default Report Style ******/

SELECT rds.[ReportID]

,rds.[Company]

,rds.[StyleNum] as DefaultStyleNum

,StyleDescription as DefaultReportStyle

FROM [Epicor905].[dbo].[ReportDefaultStyle] rds join [Epicor905].[dbo].[ReportStyle] rs

on rds.ReportID=rs.ReportID and rds.StyleNum=rs.StyleNum

where rds.ReportID = 'POFORM'

 


Bill Turgeon
Director, Information Technology
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com

Please consider the environment before printing this email.
This e-mail and any attachments are for the sole use of the intended recipients and may be privileged or confidential. Any distribution, printing or other use by anyone else is prohibited. If you are not an intended recipient, please contact the sender immediately, and permanently delete this e-mail and attachments.