Hilal Al-Rajhi Hilal Al-Rajhi - 1 month ago 5
SQL Question

Add exsiting query to report

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

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.

Add Command

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