E10: Report Data Definitions - Field Exclusions

You can download it here.
https://onedrive.live.com/redir?resid=315FB7C2F4ED7D99!1405&authkey=!AOYlSdgl4Zl-G48&ithint=file%2cbpm

As someone pointed out, you just need to change the connection string so that it points to your SQL server.





Joe Rojas | Director of Information Technology | Mats Inc.
dir: (781) 573-0291 | cell: (781) 408-9278 | fax: (781) 232-5191

addr: 179 Campanelli Parkway | Stoughton | MA | 2072
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:13d691.png@86042e0d.4280d732]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 04, 2015 4:13 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E10: Report Data Definitions - Field Exclusions



Do you mind sharing the BPM to auto add all fields? Having to add each field you want to exclude is a pain in E10. I rather they'd kept how fields are added/excluded the way that was done in E9.



Thanks



[Non-text portions of this message have been removed]
Hello,

So at first, I had assumed that you had to add all the fields you want excluded from a report table and do not add, or remove, the fields that you do want to be included.

Even though I did see the two fields, ExcludeColumn and ExcludeLabel, I did think much more about it.
I came across a base RDD that had all fields lists and used the ExcludeColumn checkbox to control output.

This approach, when combined with the BPM I created to auto add all fields, seems to make more sense.

So, my question is. Does anyone know if there is a preferred method?
Do I use the ExcludeColumn to control output or is it better to remove the columns you want to include?
Does it really matter?




Joe Rojas | Director of Information Technology | Mats Inc.
dir: (781) 573-0291 | cell: (781) 408-9278 | fax: (781) 232-5191

addr: 179 Campanelli Parkway | Stoughton | MA | 2072
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:28aae7.png@dd8beba4.47a96b31]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.




[Non-text portions of this message have been removed]
Looks like I might have just answered my own question.
I tried using the ExcludeColumn approach to specify which field to INCLUDE but these fields did not show in the drop down when defining a relationship.
I had to delete these fields from the exclusion list before they would show.





Joe Rojas | Director of Information Technology | Mats Inc.
dir: (781) 573-0291 | cell: (781) 408-9278 | fax: (781) 232-5191

addr: 179 Campanelli Parkway | Stoughton | MA | 2072
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:cc361c.png@112510b8.4ba11b22]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 04, 2015 12:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E10: Report Data Definitions - Field Exclusions



Hello,

So at first, I had assumed that you had to add all the fields you want excluded from a report table and do not add, or remove, the fields that you do want to be included.

Even though I did see the two fields, ExcludeColumn and ExcludeLabel, I did think much more about it.
I came across a base RDD that had all fields lists and used the ExcludeColumn checkbox to control output.

This approach, when combined with the BPM I created to auto add all fields, seems to make more sense.

So, my question is. Does anyone know if there is a preferred method?
Do I use the ExcludeColumn to control output or is it better to remove the columns you want to include?
Does it really matter?




Joe Rojas | Director of Information Technology | Mats Inc.
dir: (781) 573-0291 | cell: (781) 408-9278 | fax: (781) 232-5191

addr: 179 Campanelli Parkway | Stoughton | MA | 2072
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:28aae7.png@dd8beba4.47a96b31]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]

Do you mind sharing the BPM to auto add all fields?  Having to add each field you want to exclude is a pain in E10.  I rather they'd kept how fields are added/excluded the way that was done in E9.


Thanks