Add exsiting query to report

Question

My report calculates the stock of inks in my stores. I built a SQL statement in VB.NET and got the correct results. How can I display these results in my Crystal Report? Or design a report such that same results will be retrieved?

I tried to use SQL Expression builder but failed.

Answer 1

In Database Manager choose Add Command and then type your SQL Statement there.

Answer 2

Usually you will link Data Tables to your report using Database Expert. Do the same in Database Expert, select the Database and you can see Add Command. Select that and click the > button. You will get a Window, write your SQL Query there and press OK.

After finishing this you can see Command in Database Fields which contains all your records got from the SQL Query as result.