Joined: 16 Mar 2010
Online Status: Offline
Posts: 23
Topic: Capture data an display in report footer Posted: 19 Nov 2010 at 10:25am
Is it possible to capture data about a specific record and display that information in the report footer.
Contract Type Amount
1899 Gas 2,000
9087 IRB 5,000
8003 IRB 8,000
Contract 9087 is non-binding.....the balance is 5,000
I want to capture the amount for Contract 9087 and display it in the footer of a report. How can I accomplish this. This seems so simple but when I tried to load a variable it didn't work. I am not sure what I am doing wrong.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 23 Nov 2010 at 8:35am
was the variable shared or global? local variables won't carry over.
Also, did you assign another value to the variable which set it to NULL or an empty string? Something like: if {table.field} = something then x else ""
would have this type of effect. Typically if I want a variable to display in the footer, I will have in the header variable := "", then in the detail, I will only assign or update the variable to a value, never to "".
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
