Keht
May 2nd, 2006, 12:00 AM
Does anyone have a link or code sample that could assist me with the following question?
I have a crystal report designed in ASP. net. I can load the report and see all the data. I can use selection formulas to do some select data in the reports dataset I guess you would call it. What I want to do is programmatically change the original query to the mySql data base. Select * from table where field = x … and so on… I guess I could use the selection formula on a report but that is slow. I can query off one table with over a million records. I would like to make my selection before I get to the report. What do I need to do? Is this a ado thing? If so, can anyone guide me in the direction of where I can learn how to do this?
I have a crystal report designed in ASP. net. I can load the report and see all the data. I can use selection formulas to do some select data in the reports dataset I guess you would call it. What I want to do is programmatically change the original query to the mySql data base. Select * from table where field = x … and so on… I guess I could use the selection formula on a report but that is slow. I can query off one table with over a million records. I would like to make my selection before I get to the report. What do I need to do? Is this a ado thing? If so, can anyone guide me in the direction of where I can learn how to do this?