Hi
I have report 1() and subreport 2.
e.g report one has farms as a field,subreport2 has cat ,cow,chicken that belong to a farm in report 1.
I need to display this data in report 1 as:
farm1 & cat
& cow
& chicken.
I managed to get both farm1(as a field) and (cat ,cow,chicken) Farmanimals: from subreports
problem is how do i put this field and subreport together to look like example above. i tried concatinating in formula using:
1.
farm1 & ' & ' & Farmanimals //& is this e.g & cow
Prblem is that Farmanimals does not return a list of all three Farmanimals.
2.
i tried to take farm1 as a text field, add '&' in subreport Farmanimals ,and them place this close to each other. getting (overlapping or too apart)
problem is that the size of field farm1 is not fixed.
3.
in formula i tried to concatenate Farm1 and a declared Farmanimals field using the command for the subreport,this shows to be working but it only returns farm1 & cat:below was done for different formulas smalteneously.
shared stringVar tt;
stringVar tt:={Command_1.Farmanimals} ;
{Command.farm1} &' & '& stringVar tt
\\tt is displayes as just one Farmanimals
please help,results should be :
farm1 & cat
& cow
& chicken.
Edited by mooza - 21 Mar 2012 at 5:49am
IP Logged
