Solved

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

Posted on 2008-10-15
6
618 Views
Last Modified: 2008-10-15
how to group in a crystal report based on formula using vb.net
0
Comment
Question by:mseit
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 22720471
What do you mean?

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

mlmcc
0
 

Author Comment

by:mseit
ID: 22721164
Can you give code snippet for passing value for grouping.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 22722186
What kind of code?  What value are you passing?

What data do you have?

What are you trying to accomplish?

mlmcc
0
Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

 

Author Comment

by:mseit
ID: 22728092

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
 
LVL 100

Accepted Solution

by:
mlmcc earned 125 total points
ID: 22728221
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
 

Author Comment

by:mseit
ID: 22728273
Thanks.It is working.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question