How to write a query for each row 1

[shadabrauf]

I am trying to write a Balance Sheet, My issue is I am trying to write seperate query for each row of this report.

I have 10 rows in the report like

ASSETS
=============

CASH & CASH EQUIVALENT <seperate sql query for this row>
NOTES RECEIVABLE <seperate sql query for this row>
TRADE RECEIVABLE <seperate sql query for this row>
----------------
-----------------
-----------------

Please let me know how to write multiple queries OR functions to solve this..Any solution

Shadab

 

[sarma71]

Create a sub-report for each of your rows and place them against each of the items you have on the left:
Cash & Cash Equivalent [subreport:cash-casheq]
Notes Receivable [subreport:notes receivable] etc.

 

[shadabrauf]

Thanks alot. It will solve my problem.

Since I am new in the report writer so just asking Is this is the only way to run a query for each row?

Shadab

 

[sarma71]

Maybe not. I guess it depends on what exactly you are trying to achieve. Since you said you wanted to write a query for each row, I suggested that route. You could as well write a stored procedure that returns all your data.
Good luck!