Link to home
Start Free TrialLog in
Avatar of aqk139
aqk139

asked on

Selecting fields to display at runtime in Crystal Reports

I need to give user choice that which fields of table he want to display. The user will have a form (VB form)having field names with check boxes. All those check boxes that are checked sould come in report not others.

How to do that?
Avatar of pritam_dewan
pritam_dewan

This is very simple.Just Get the field name from the checked boxes.On completion of the selection by the user,form ur string for fetching records from the db.
An Exp:

Let say he wants the follwoing information from the Employee table.

Emp_name(checked),salary(checked),doj(not checked).....
Dim
Dim SqlString as String
SqlString="Select emp_name,salary from Employee"
....
Hope u understand how to proceed.
ASKER CERTIFIED SOLUTION
Avatar of jayvb
jayvb

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If this proposed answer has helped you, please accept it, grade it and close this question.  If it did not, reject it and add comments as to your progress and what else is needed.  If no action is taken here by next week, we'll need to decide this outcome.  Expert input always welcome as well.

Thanks,
Moondancer
Community Support Moderator @ Experts Exchange
I have rejected the proposed answer.

pritam_dewan,

Welcome to Experts Exchange!

It is common practice for Experts to post their responses to questions in the form of a Comment, rather than an Answer. The reasoning is straightforward; EE is a collaborative site. By proposing an Answer, you essentially lock others out of the collaborative process by making it more difficult for other Experts to see the question.

You should also only propose an Answer when you are absolutely certain that yours is the one-and-only, single solution to the problem, AND that your response does not paraphrase or restate someone else's suggestion, AND that your response is a complete and total solution.

There has been no activity in this question in quite some time, and it looks like it has been abandoned. As part of our ongoing mission to clean up the topic areas, a Moderator will finalize this question within the next seven (7) days. At that time, either I or one of the other Moderators will force/accept the comment of jayvb.

DO NOT ACCEPT THIS COMMENT AS AN ANSWER. If you have further comments on this question or the recommendation, please leave them here.

aqk139,

Some of these questions have been open for some time, and records indicate you logged in as recently as last week. Please resolve them appropriately as soon as possible. Continued disregard of your open questions will result in the force/acceptance of a comment as an answer; other actions affecting your account may also be taken. I will revisit these questions in approximately seven (7) days.

https://www.experts-exchange.com/jsp/qShow.jsp?ta=msaccess&qid=20202508
https://www.experts-exchange.com/jsp/qShow.jsp?ta=crystal&qid=20255526
https://www.experts-exchange.com/jsp/qShow.jsp?ta=oracle&qid=20167212
https://www.experts-exchange.com/jsp/qShow.jsp?ta=oracle&qid=20165928
https://www.experts-exchange.com/jsp/qShow.jsp?ta=oracle&qid=20141926
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20243322
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20207867
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20207526
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20191215
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20183720
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20180355
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20175537
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20175003

Thanks,

Netminder
Community Support Moderator
Experts Exchange
Admin notified of user neglect. Force/accepted by

Netminder
Community Support Moderator
Experts Exchange