I've been scratching my head as how to do this :)
I wish to create a series of rounded rectangles and put data from queries in them I then wish to link reports of this data.
This is where I've gotten to:
select 'dbr.title','Bank Balance';
select 'dbr.purehtml','<div class="rcorners1">';
select concat('Bank Balance\r\n£',sum(a.Tran_CB)/1000 ,'M') from hilmark.tblbank_trans a
join (select Acc_ID, max(Tran_Date) as maxdate from hilmark.tblbank_trans group by Acc_ID) dp
on a.Acc_ID = dp.Acc_ID
where a.Tran_Date = dp.maxdate;
I've also added the following to the userstyle.css file:
The result I'm getting is the rectangle OK and the data in the horizontally centred but not vertically and the data is in a white rectangle.
Hope you follow that.
Am I doing this totally wrong?