Links between Tables

[Former Member]

Hi

I am using Crystal report2008. I have made links between OCRD(BP Record) and ORCT(incoming payment). I want to display BP data Opening balance as well as Incoming payment document total. It displays nothing.

Can anyone help me how to display both in a report?

By

Kalai

Edited by: D. Kalaiselvan on Sep 29, 2008 9:51 AM

[Former Member]

Did Not get clarified..

[Former Member]

Its better to 1st get all ur required data in a SQL Query and then from the Query u can design ur report.

Vasu Natari.

[Former Member]

Hi

Thanks for your reply.

Can provide me any samples how to design a report from a SQL query?

Thanks in Advance