Dear All,

My Situation now is, i am using visual studio.NET 2005 to develop the application and crystal reports. I create system views to add in tables needed and use selection formula to filter out the data needed.

(a) How can i use two views for the same report?

(b) SELECT ( SELECT SUM(table_field) FROM table_A  **ps1**  ) AS Sum_A,
( SELECT SUM(table_field) FROM table_B  **ps2**) AS Sum_B
FROM table_A **ps3**

How can i insert a "WHERE" into the sql when there is a DateTimePicker for the user the select date. The "WHERE" is unable to place into **ps1** and **ps2**

How can i achieve this ?
SELECT ( SELECT SUM(table_field) FROM table_A  where date=DateTimePicker.value ) AS Sum_A,
( SELECT SUM(table_field) FROM table_B  where date=DateTimePicker.value ) AS Sum_B
FROM table_A where date=DateTimePicker.value

Wish to achieve it in the Record Selection Formula.

Thank you,
Regards,
Yuri.

Thank you for your reply Hilfy, really appreciate it ..