Hi
I am using CR 10 and I am working on a Balance sheet, This report is a one page report and It has 20 Columns, For each column I have written a Command (seperate query). Now my issue is I want when I will run this report It should as a Parameter "As of Date" default would be current date, And...
I need to write following query in a report. How to write
This report has only one column and I need to show data based on following query.
select sum(balanceYtd) from temp where temp.accountno >='1000' and temp.accountNo <='2000';
Can some one let me know How do i write this query in crystal...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.