CODEWITHSUNDEEP
countcrystal-reportscumulative-sumsummarize
crystalnoob
crystalnoob

Reputation: 27

crystal reports count instance by group then sum

My subreport has groupings on Account ID then Invoice No. Within the Account ID I could have several Invoice No's.

For example:

Account 1234

What I want is count of invoices. Using the example I should get a count of 3. There are 3 unique invoice numbers under the account id. I have tried a running total, formulas and summary.

Upvotes: 0

Views: 691

Answers (1)

DBB
DBB

Reputation: 137

Using Distinct Keyword in sql query or linq You Can Solve This Problem.

var data = (from n in tbldemo select n).Distinct();

Now Set data to your crystal report data source. It will helps you.

Upvotes: 1

Related Questions