Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends
In my QV document I have loaded data relating to vehicle parts and it is displayed in a table box as shown below.
I want the records in Table box to be printed as labels (to be affixed on the part) as shown above. I think this has to be arranged a text box and then print. However I am not aware of how to do it. I seek your help to fulfill my requirement please.
Accepted Solutions
In load script, add in a rowno() for ranking purpose, example:
Raw:
load * inline [
Field1,Field2,Field3
1,A,A1
2,A,A1
3,A,A2
4,B,B1
5,B,B1
6,C,C1
];
Data:
load *, if(RowNo()=1,1,if(peek(Field2)=Field2 and peek(Field3)=Field3,0,2)) as Rank2
Resident Raw;
drop table Raw;
NoConcatenate
TempData:
load * ,if(RowNo()=1,1,peek(Rank)+1) as Rank
Resident Data
where Rank2 <>0;
drop table Data;
EXIT Script;
Then at front end, insert a textbox and try this:
='Field1: '&only({<Rank={1}>}Field1)& chr(10)&'Field2: '&only({<Rank={1}>}Field2)& chr(10)&'Field3: '&only({<Rank={1}>}Field3)&chr(10)
You should get:
Insert a new textbox Replace Rank =1 to Rank =2 to get the second textbox:
='Field1: '&only({<Rank={2}>}Field1)& chr(10)&'Field2: '&only({<Rank={2}>}Field2)& chr(10)&'Field3: '&only({<Rank={2}>}Field3)&chr(10)
Continue with Rank =3 and Rank =4 and you will get:
.png "Former Employee"){kind=icon}
