E9 to E10: Crystal Report Data Definitions

Yahoo Archive
1
I just ran into this situation this week.  I was lucky it was only one field.  Looking forward, I thought what would I do if I ran into this again.  One choice is the one shared to start over with the E10 RDD; probably the best idea if you did a good job of documenting your prior changes to the RDD.  However, I didn't do a good job.

My thought as to how to avoid this trial and error would be to screenshot the E10 RDD and compare to your customized RDD adding any additional fields.
2
Hello,

While we hope to move to SSRS as quickly as possible, we will need to use some crystal reports in E10 from the get go.

I am reviewing a report data definition that was originally a duplicate of OrderAck in E9 and so far I’ve come across two issues.

The first is: I just tried to do a print preview to see what would happen. I got an error “Task: Column 'Calc_CarrierDesc' does not belong to table OrderHed.”
I looked in E9 and this isn’t listed anywhere in the report data definition. I looked in E10 and it’s not there either.
I decided to add a calculated field to my report definition in E10 just to see what would happen.
Now the print preview failed with the same error but this time its “Calc_CarrierSCAC”. I suspect that as I continue, this will keep happening until I’ve addressed all these “missing” fields.
It looks like these field are in the E10 version of OrderAck, which is likely why it’s complaining.

Have others ran into this?
Do I just keep going or are others just rebuilding the report definition based on the new E10 versions?

The second issue is that I don’t seem to be able to select UD fields when working with Linked Tables. Have others seen this? If there a fix or work around?

Thanks all.




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

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

[cid:2b43a2.png@dd8f8240.4c8f7549]
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]
3
I've just started with a Copy of the "E10" RDD and the modified the report accordingly to accept it. Instead of the other way around.


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Fri, Apr 24, 2015 at 2:46 PM, Joe Rojas jrojas@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>Hello,


While we hope to move to SSRS as quickly as possible, we will need to use some crystal reports in E10 from the get go.

I am reviewing a report data definition that was originally a duplicate of OrderAck in E9 and so far I’ve come across two issues.

The first is: I just tried to do a print preview to see what would happen. I got an error “Task: Column 'Calc_CarrierDesc' does not belong to table OrderHed.”
I looked in E9 and this isn’t listed anywhere in the report data definition. I looked in E10 and it’s not there either.
I decided to add a calculated field to my report definition in E10 just to see what would happen.
Now the print preview failed with the same error but this time its “Calc_CarrierSCAC”. I suspect that as I continue, this will keep happening until I’ve addressed all these “missing” fields.
It looks like these field are in the E10 version of OrderAck, which is likely why it’s complaining.

Have others ran into this?
Do I just keep going or are others just rebuilding the report definition based on the new E10 versions?

The second issue is that I don’t seem to be able to select UD fields when working with Linked Tables. Have others seen this? If there a fix or work around?

Thanks all.




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

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

[cid:2b43a2.png@dd8f8240.4c8f7549]
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]

</div>
 


<div style="color:#fff;min-height:0;"></div>

4
I agree with Jose. Duplicate E10 RDD and add required tables and fields.

Regards,
Arul 

Sent from my iPhone

On 25 Apr 2015, at 5:06 am, Jose Gomez jose@... [vantage] <vantage@yahoogroups.com> wrote:

 

<div id="ygrps-yiv-537546521ygrp-text">
  
  
  <p></p><div dir="ltr"><div class="ygrps-yiv-537546521gmail_default" style="font-family:verdana, sans-serif;font-size:small;">I&#39;ve just started with a Copy of the &quot;E10&quot; RDD and the modified the report accordingly to accept it. Instead of the other way around.</div></div><div class="ygrps-yiv-537546521gmail_extra"><br clear="all"><div><div class="ygrps-yiv-537546521gmail_signature"><div dir="ltr"><div><font face="verdana, sans-serif"><br><font color="#333333"><b>Jose C Gomez</b></font></font></div><div><font color="#666666" face="verdana, sans-serif" size="1"><b>Software Engineer<br><br></b></font></div><div><font face="verdana, sans-serif"><font><font color="#666666"><b><br></b></font><font color="#FF6600" size="1">T: </font></font><font size="1"><span title="Call with Google Voice"><span title="Call with Google Voice">904.469.1524</span></span> mobile</font></font></div><div><font size="1" face="verdana, sans-serif"><font color="#FF6600">E:</font> <a rel="nofollow" target="_blank" href="mailto:jose@...">jose@...</a></font><font size="1" face="verdana, sans-serif"><br><a rel="nofollow" target="_blank" href="http://www.josecgomez.com"><font color="#FF6600">http://www.josecgomez.com</font></a><br><a rel="nofollow" target="_blank" href="http://www.linkedin.com/in/josecgomez" style="font-size:small;"><img src="https://ec.yimg.com/ec?url=http%3A%2F%2Fwww.josecgomez.com%2Fimages%2Flinkedin.png&t=1473006579&sig=012B8T21WXcsw0ZMWkV.zg--~C"></a>&nbsp;<a rel="nofollow" target="_blank" href="http://www.facebook.com/josegomez" style="font-size:small;"><img src="https://ec.yimg.com/ec?url=http%3A%2F%2Fwww.josecgomez.com%2Fimages%2Ffacebook.png&t=1473006579&sig=udc5ubk5g5KNI_k0clOhVg--~C"></a>&nbsp;</font><a rel="nofollow" target="_blank" href="http://www.google.com/profiles/jose.gomez"><img src="https://ec.yimg.com/ec?url=http%3A%2F%2Fwww.josecgomez.com%2Fimages%2Fgoogle.png&t=1473006579&sig=mEts5SufqeCjae8kLhOzbw--~C"></a>&nbsp;<a rel="nofollow" target="_blank" href="http://www.twitter.com/joc85"><img src="https://ec.yimg.com/ec?url=http%3A%2F%2Fwww.josecgomez.com%2Fimages%2Ftwitter.png&t=1473006579&sig=RarZmr2hdFwN70PufobXKQ--~C"></a>&nbsp;<a rel="nofollow" target="_blank" href="http://www.josecgomez.com/professional-resume/"><img src="https://ec.yimg.com/ec?url=http%3A%2F%2Fwww.josecgomez.com%2Fimages%2Fwp.png&t=1473006579&sig=dcVWr1JhcE6Davl3pS3DMQ--~C"></a>&nbsp;<span style="font-family:verdana, sans-serif;"><a rel="nofollow" target="_blank" href="http://www.josecgomez.com/feed/"><img src="https://ec.yimg.com/ec?url=http%3A%2F%2Fwww.josecgomez.com%2Fimages%2Frss.png&t=1473006579&sig=pdwU2_4kZKpfb6oT2scFNA--~C"></a>&nbsp;</span></div><div><span lang="LA" style="color:black;"><br><font face="Verdana, sans-serif" style="font-weight:bold;" size="1"><i>Quis custodiet

ipsos custodes?



On Fri, Apr 24, 2015 at 2:46 PM, Joe Rojas jrojas@… [vantage] <vantage@yahoogroups.com> wrote:

  
<div>
  
  
  <p>Hello,


While we hope to move to SSRS as quickly as possible, we will need to use some crystal reports in E10 from the get go.

I am reviewing a report data definition that was originally a duplicate of OrderAck in E9 and so far I’ve come across two issues.

The first is: I just tried to do a print preview to see what would happen. I got an error “Task: Column 'Calc_CarrierDesc' does not belong to table OrderHed.”
I looked in E9 and this isn’t listed anywhere in the report data definition. I looked in E10 and it’s not there either.
I decided to add a calculated field to my report definition in E10 just to see what would happen.
Now the print preview failed with the same error but this time its “Calc_CarrierSCAC”. I suspect that as I continue, this will keep happening until I’ve addressed all these “missing” fields.
It looks like these field are in the E10 version of OrderAck, which is likely why it’s complaining.

Have others ran into this?
Do I just keep going or are others just rebuilding the report definition based on the new E10 versions?

The second issue is that I don’t seem to be able to select UD fields when working with Linked Tables. Have others seen this? If there a fix or work around?

Thanks all.




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

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

[cid:2b43a2.png@dd8f8240.4c8f7549]
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]

</div>
 


<div style="color:#fff;min-height:0;"></div>


</div>