Topic: Summary

Hello Friends..
How can we generate Summary of a Vehicle No....
Data stored in attached project from 1 dec 2018 to 31 dec 2018 with different vehicles...
How to make summary of every vehicle... Required Example Summary.xlsx file attached...

Post's attachments

Attachment icon KTSoft.zip 374.4 kb, 279 downloads since 2019-01-04 

Re: Summary

Or Summary Like This Example...

Post's attachments

Attachment icon Summary.xlsx 10.64 kb, 288 downloads since 2019-01-04 

3 (edited by derek 2019-01-05 00:51:21)

Re: Summary

Hi Raheel,
I think I'd probably use 'sql query' to show a summary for each vehicle in a separate tablegrid and then link the 2 tablegrids together so that when you select a specific vehicle, the tablegrid with the details automatically filters.
One problem though is to show the 3 different fuel types on the same row (because this is not how your data is structured).  So in my example, the summary is just by vehicle (to reflect your data structure). 
Please have a look at the attached example - hopefully it gives you the general idea.
Regards,
Derek

Post's attachments

Attachment icon KTSoft.zip 375.55 kb, 315 downloads since 2019-01-05 

Re: Summary

Thanks Derek... your query is very helpful... thanks again