Its so sad i have suffered for along time while there been a simple to follow tutorial like this. I wish you could share the SQL script I am in a exactly same situation and very stuck and am supposed to close a project already overdue. However many thanks for this tutorial

@ReportingGuru

Жыл бұрын

Thanks for the great feedback. Glad it helped. Unfortunately, the SQL is different for every database.

@petermaina7111

Жыл бұрын

@@ReportingGuru this one will work perfectly on my case

Do you have the Actual Database File ? Like the tables, and scripts used in all your demo on Balance sheet, Financial Statement etc?

@ReportingGuru

7 жыл бұрын

Sorry, we cannot share the actual database. Every database will have different tables they use for their accounting entries. Look for a Transaction table. Typically there is Transactions, TransactionType, and LedgerAccounts.

Hi, Can you share this query ..? I'm new in this.

@ReportingGuru

6 жыл бұрын

Hi, the query would be for a specific database, so you would have to write a query that works with the tables in your database.

if you want to show something create a project that can be dowloaded and one follows what you are doing. stop saying it will depend with the database for instance you could have created a sample database and leave it to us to know how to create the database. in short its like you didnt want to share your know;ledge but rather show it off

@ReportingGuru

6 жыл бұрын

This is a FREE video that shows the general concepts of how to create a balance sheet. We show the queries used to get the different sections of a balance sheet as well as how to line up the transactions in Crystal Reports. Everything follows accounting principals. Yes, we are showing off our expertise because we make our living by building reports for our clients. There are hundreds of ERPs out there that these concepts can be applied to. If you would like to pay us to create balance sheets for you, we are more than happy to do so.