Saturday, February 25, 2012

pass filter to cristal report

hi,

I'm using Borland's C++ Builder and InfoPower Components,
i need to passa the result of an execution of a filter dialog to a Cristal report,

better, i want to print, the dataset of a grid, based on a filter,
the fields displayed are the same ... just the filter change

how can i do this, at run time ??

thank's in advance

need awnser as fast as you can, urgent!!!Hi ,
I am trying for VB you try it out to ur code.

Use

CrystalReportViewerSL.SelectionFormula = Your Filter condition
Before preview the report.

eg.

Dim StrStoreValue As String

StrStoreValue = "STORE1"

CrystalReportViewerSL.SelectionFormula = = "{STOCK_LEDGER.STORE_CODE} = '" & StrStoreValue & "'"

It woll give the filtered output.

Thanks
Vilas|||i solve it other way

i can convert the result of the query in a string tha i just

(the string needs to be in crystal syntax ... )


CrpeReports->Selection->Formula->Clear();
CrpeReports->Selection->Formula->SetText(filtro.c_str());


as it is the only formula i need ... it works well ...

but thanks anyway

No comments:

Post a Comment