xsd - Crystal Reports Header Subreport Data vanishes when new field is added to DataTable -

i apologize if example little vague; unfortunately, can't use same field names in example without giving away both company name , purpose of data.

given following:

a crystal report populated dataset , bound xsd schema file;

a .net 1.1 program populates dataset , binds report;

data tables foo , bar;

xsd schema:

----foo---- stuff (pk) things gunk  ----bar---- stuff (fk) details widget 

relationship: 1 foo can have 1 or more bars, inner join on stuff.

this report works. there's been request add new "code" field report indicate value tied contracts. there list of codes, , list of parts have specific codes. meant, on database side, adding table "widget" , "codeid" linking table, indicating code goes widget, , table "codeid" , "codedescr" hold codes , definitions. able add field modifying schema file add "codedescr" bar , populating simple query based on row's value in "widget". works.

the problem subreport makes header. uses same xsd file, if codedescr field added subreport makes body of report, values in header vanish. of these values literals (i.e. value of "stuff" identify item) , others formulae (such using value of gunk determine whether display string or numeric identifier). i've been banging head on desk 3 days trying figure out why stopped populating can fix it. help!

alright, think i've solved puzzle of variable names enough maybe start helping :)

can draw goal in excel make sure we're aiming in right direction?

to confirm, database, joining on colors:

some random thoughts aimed @ helping:

• shouldn't matter, constructing subreport in header well? or in details? typically try match them, though long suppressions correct shouldn't matter.

• right click on subreport (while on design tab), select "change subreport links" expected links there?

• after checking links, go subreport , check record select. changing links adds new line each link in here. logic correct? on note, can transpose parent report , subreport's record selects variables used in example @ here?

i'll come time allows, let know when have update.