how to group in a crystal report based on formula using vb.net

how to group in a crystal report based on formula using vb.net
mseitAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mlmccConnect With a Mentor Commented:
You can group on a formula but you will have to convert all fields to the same datatype most likely STRING or TEXT

If {?YourGroupParam} = 'DelveryDate' then
    CStr({DelveryDateField},'yyyy/mm/dd')
Else If {?YourGroupParam} = 'ItemCode' then
    {ItemCodeField}
Else etc

mlmcc
0
 
mlmccCommented:
What do you mean?

Crystal can only base groups on Crystal formulas or database fields not anything from VB.Net

mlmcc
0
 
mseitAuthor Commented:
Can you give code snippet for passing value for grouping.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
mlmccCommented:
What kind of code?  What value are you passing?

What data do you have?

What are you trying to accomplish?

mlmcc
0
 
mseitAuthor Commented:

Actually i want to pass a field name from vb.net to CR and grouping should be made based on it.
For Eg In case of SalesOrder Report, if i pass Deliverydate Or ItemCode grouping has to be done based on it.
0
 
mseitAuthor Commented:
Thanks.It is working.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.