Modifying SQL query after attaching to Crystal report

[PatelRam]

Hi,

I have existing crystal report which is based on crystal SQL Query (Query1.qry). The
Report is working fine. Because of some functionality change, I want to modify Query1.qry I have added one column in Query1.qry. I have opened my crystal report to add the same column but query doesn't show me the new column.

My question, is any way we can change Query once it is attach to Crystal report ?


Thanks,

Ram

 

[pgtek]

hi

go to your query designer and select that query.
do your modification there and then save it
next go to your report and there click on database then verified database

cheers

pgtek