Category wise report in single page

Question

1.00/5 (1 vote)

See more:

I have a table like below image
Table — ImgBB[^]

I wank to create a report like following image

Report — ImgBB[^]

How can i create report like above image?

What I have tried:

I have created three formula field for filter Banana, Potato and Corn. Formula code is here:

if {Table1.Purpose}='Banana' then {Table1.LoanAmount} else 0

if {Table1.Purpose}='Potato' then {Table1.LoanAmount} else 0

if {Table1.Purpose}='Corn' then {Table1.LoanAmount} else 0

I also created three formula field to sum Banana, Potato, Corn. Formula name is SBanana, SPotato, SCorn

sum({@Banana}), sum({@Potato}), sum({@Corn})

Posted 24-May-20 0:55am

Member 14784320

Updated 26-May-20 6:00am

RickZeeland

v2

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Suresh_Vishwakarma · Answer 1 · 2020-05-26T06:02:00

Hi Rick,

May be getting result from sql queries can help you. Please try these:

select Purpose, SUM(LoanAmount)as Total from yourtable group by Purpose

select LoanStatus, SUM(LoanAmount)as Total from yourtable group by LoanStatus

select RecoveredBy, SUM(LoanAmount)as Total from yourtable group by RecoveredBy

Category wise report in single page

1 solution

Solution 1

Add your solution here

Preview 0

Category wise report in single page

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us