Hi All

I have one problem.My crystal report has diffrent database fields.It works fine.

But i want to change "detail section" when i select value from combo box.

means my last field of detail section is "jan from student table".when i select value as feb from combo box,i want feb values from database in "detail section"

Is it possible?
if possible,how can i do that?
pls if u have any code for reference,pls help me as early as possible.

Thanks
monika

HI there...

If I understand correctly, you just want to run a diferent query (or at least a diferent where clause), are you passing the parameters to crystal or just building the recordset on the program side and passing it (or datatable?, You don't specify any language).

Anyway, just add a where clause and show the data you need..

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Hi

Thanks for your kind help.But I have one problem.I am new in crystal report.I just want to know that how to run a different query.I pass the parameters as "year". when i pass "2006",it shows 2006 records.but i want to pass another parameter like month,when i pass "jan" as parameter at that time my detail section has to changed means if i pass "jan" at time my detail section was "tablename.jan" and when i pass "feb" at time my detail section has to "tablename.feb".

how can i do that?
if possible,pls reply as early as possible.
if u have any code,pls send me.

Thanks
monika

I don't know how your table is defined, but for sure crystal wants a specific parameter for a specific field. You didn't answer any of my prior question, so I still don't know how are you working with this, but another way to do this is to supply all parameters, or just pass the all the parameters you need (If I remember ok, you can make crystal to avoid parameters is there are blanks.)

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Hi,

I dont have the answer for this question, but I got it now. You got a job in Apr, so you ABORTED all the plans and carried on.