Last post Oct 18, 2010 01:04 PM by skvignesh
Oct 18, 2010 11:16 AM|manchako|LINK
Hi, so I'm looking to create a crystal report based on the choices in several dropdown boxes. For instance I have drop down boxes with client name, starting month, starting date, ending month, and ending date and I want crystal report based on an SQL query
SELECT * from TASKS WHERE Client name = [clientdropdownbox] AND MonthID > [startmonthdropdownbox] AND MonthID < [endmonthdropdownbox] AND date > [startdatedropdownbox] AND date < [endingdatesropdownbox];
What would be the easiest way to do this?
this is obviously just an example sql statement but just to give an idea of what I'm doing!
Oct 18, 2010 01:04 PM|skvignesh|LINK
May be this thread, where there was a lot of discussion on this topic be of help to you