CODEWITHSUNDEEP
c#winformscrystal-reports
mepk
mepk

Reputation: 187

Generating Crystal Report by month?

I have a mComboBox which have the list of the month names. and i have a sql table

InstallmentTable
    ID
    CurrentMonth
    Installment
    Commission

I want to generate crystal report where CurrentMonth = mComboBoxSelectedMonth I'm beginner in crystal reports kindly guide me how can i do it?

Upvotes: 1

Views: 949

Answers (2)

Stash_Man
Stash_Man

Reputation: 69

Use the selection formula in your report....

{dailysummary2.date} >= cdate(year(currentdate),(Month ({?startdate})),1)

and

{dailysummary2.date} < dateserial(year(currentdate),(Month ({?startdate}))+1,1)

Upvotes: 1

Asif
Asif

Reputation: 2677

There can be two ways to do this thing

1) Firstly you have to filter the data table with respect combo value at front end and reassign the filtered data table to crystal report by using SetDataSource() function.

2) Secondly you can do by filtering the record at database end as per your combo value and then re assign new data table to crystal.

There is no direct way of filtering the records at crystal report level.

Upvotes: 4

Related Questions