I have a report done on VB where user select number of different options of information he wants to see and he gets a report on HTML. But if he wants to print it he has on that page link to Printer friendly version(which is in Crystal). I need to be able to send this to Crystal as where clause in SQL in run time.
For example:
User select information for Bob Smith, only close cases, o in Dev, high priority...etc. In this case Sql where clause looks like:
where name = "Bob Smeth" and
status = " Close" and
priority = "High".....
So, instead of sending number of different parameters I want to be able to send dynamicly changed where clause. Is it possible??
For example:
User select information for Bob Smith, only close cases, o in Dev, high priority...etc. In this case Sql where clause looks like:
where name = "Bob Smeth" and
status = " Close" and
priority = "High".....
So, instead of sending number of different parameters I want to be able to send dynamicly changed where clause. Is it possible??