Crystal reports of Vantage

Yahoo Archive
1
Did you go to the Report Data Definition and update the fields you see?
System Management > Company Maintenance > Report Data Maintenance
Search for JobTrav
Look under the Report table and Jobhead.
The field is excluded.
You will need to go to actions and duplicate report and then add the feild you want.
Once you do this and update crytal you will should see the field.  Just make sure you change the report definition in the report maintenace.
 
I  hope this helps.
On Wednesday, April 2, 2014 9:29 AM, Sanjay Kukreja <skukreja@...> wrote:
  
<div id="ygrps-yiv-1867121419yiv6074261423ygrp-text">
  
  
  <div>I am trying to add a field (number10 from table jobhead) in a crystal report that prints job travelor for us. When I open the crystal report, I DONT see number10 field in jobhead table &amp; we know for sure that number10 field does exist in table jobhead.


Further I try to run the file independently , it shows me a XML file name & asks for a class name…..



Attached is the file with screen shot 1 for the crystal reports in question and screen shot 2 is when I tried to run it from crystal directly & it shows me XML files.

Appreciate any help on this….



Sanjay K.








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

</div>
 


<div style="height:0px;color:rgb(255, 255, 255);"></div></div>
#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423 -- #ygrps-yiv-1867121419yiv6074261423ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-mkp #ygrps-yiv-1867121419yiv6074261423hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-mkp #ygrps-yiv-1867121419yiv6074261423ads {
margin-bottom:10px;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-mkp .ygrps-yiv-1867121419yiv6074261423ad {
padding:0 0;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-mkp .ygrps-yiv-1867121419yiv6074261423ad p {
margin:0;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-mkp .ygrps-yiv-1867121419yiv6074261423ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-sponsor #ygrps-yiv-1867121419yiv6074261423ygrp-lc {
font-family:Arial;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-sponsor #ygrps-yiv-1867121419yiv6074261423ygrp-lc #ygrps-yiv-1867121419yiv6074261423hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-sponsor #ygrps-yiv-1867121419yiv6074261423ygrp-lc .ygrps-yiv-1867121419yiv6074261423ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423activity span {
font-weight:700;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423activity span span {
color:#ff7900;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423activity span .ygrps-yiv-1867121419yiv6074261423underline {
text-decoration:underline;}

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

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 .ygrps-yiv-1867121419yiv6074261423attach div a {
text-decoration:none;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 .ygrps-yiv-1867121419yiv6074261423attach img {
border:none;padding-right:5px;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 .ygrps-yiv-1867121419yiv6074261423attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 .ygrps-yiv-1867121419yiv6074261423attach label a {
text-decoration:none;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 .ygrps-yiv-1867121419yiv6074261423bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 .ygrps-yiv-1867121419yiv6074261423bold a {
text-decoration:none;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 dd.ygrps-yiv-1867121419yiv6074261423last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 dd.ygrps-yiv-1867121419yiv6074261423last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 dd.ygrps-yiv-1867121419yiv6074261423last p span.ygrps-yiv-1867121419yiv6074261423yshortcuts {
margin-right:0;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 div.ygrps-yiv-1867121419yiv6074261423attach-table div div a {
text-decoration:none;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 div.ygrps-yiv-1867121419yiv6074261423attach-table {
width:400px;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 div.ygrps-yiv-1867121419yiv6074261423file-title a, #ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 div.ygrps-yiv-1867121419yiv6074261423file-title a:active, #ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 div.ygrps-yiv-1867121419yiv6074261423file-title a:hover, #ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 div.ygrps-yiv-1867121419yiv6074261423file-title a:visited {
text-decoration:none;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 div.ygrps-yiv-1867121419yiv6074261423photo-title a, #ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 div.ygrps-yiv-1867121419yiv6074261423photo-title a:active, #ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 div.ygrps-yiv-1867121419yiv6074261423photo-title a:hover, #ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 div.ygrps-yiv-1867121419yiv6074261423photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 div#ygrps-yiv-1867121419yiv6074261423ygrp-mlmsg #ygrps-yiv-1867121419yiv6074261423ygrp-msg p a span.ygrps-yiv-1867121419yiv6074261423yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 .ygrps-yiv-1867121419yiv6074261423green {
color:#628c2a;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 .ygrps-yiv-1867121419yiv6074261423MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 o {
font-size:0;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423photos div {
float:left;width:72px;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

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

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423reco-category {
font-size:77%;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423reco-desc {
font-size:77%;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 .ygrps-yiv-1867121419yiv6074261423replbq {
margin:4px;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-mlmsg select, #ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 input, #ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-mlmsg pre, #ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 code {
font:115% monospace;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-mlmsg #ygrps-yiv-1867121419yiv6074261423logo {
padding-bottom:10px;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-msg p#ygrps-yiv-1867121419yiv6074261423attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-reco #ygrps-yiv-1867121419yiv6074261423reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-sponsor #ygrps-yiv-1867121419yiv6074261423ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-sponsor #ygrps-yiv-1867121419yiv6074261423ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-sponsor #ygrps-yiv-1867121419yiv6074261423ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-text {
font-family:Georgia;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-text tt {
font-size:120%;}

#ygrps-yiv-1867121419 #ygrps-yiv-1867121419yiv6074261423 #ygrps-yiv-1867121419yiv6074261423ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-1867121419



2
I am trying to add a field (number10 from table jobhead) in a crystal report that prints job travelor for us. When I open the crystal report, I DONT see number10 field in jobhead table & we know for sure that number10 field does exist in table jobhead.

Further I try to run the file independently , it shows me a XML file name & asks for a class name…..



Attached is the file with screen shot 1 for the crystal reports in question and screen shot 2 is when I tried to run it from crystal directly & it shows me XML files.

Appreciate any help on this….



Sanjay K.









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