Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to select fields to display in a report

Posted on 2011-03-23
13
Medium Priority
?
217 Views
Last Modified: 2012-05-11
Hello

I have a report with 10 data fields, I would like users to run a report and give them the option to include the data fileds they desire by checking their title on a check box. How do I include the fields on a report based on which checkbox is checked?

Thanks,

Victor
0
Comment
Question by:vcharles
  • 7
  • 6
13 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 35203824
There is no easy way to do that.

One way which leaves much whote space is to put all the fields on the report then using parameters suppress the ones not chosen.

Are all fields the same data type? For example all text ot numeric?

mlmcc
0
 

Author Comment

by:vcharles
ID: 35204060
Yes the are all text, datasource is an XML file. How would you suppress the fields and how would it impact the spacing between the fields? Would they automatically rearrange?

Thanks,

Victor
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35204113
No they would not rearrange.

If they are all text fields then you could use formulas for the report

How will you call the report?
Formulas can be changed from the application.

mlmcc
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 

Author Comment

by:vcharles
ID: 35204146
I'm using the following approach with VB.NET:

DonorXML1.RecordSelectionFormula = "{Donor.DonorName} like " & "'*" & TextBox1.Text & "*'" & ""
With DonorXML1
CrystalReportViewer1.ReportSource = DonorXML1
End With

Thanks,

V.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35204183
What version of Crystal?

mlmcc
0
 

Author Comment

by:vcharles
ID: 35204191
version 2008
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35204402
Is that the standalone or the version that comes with VS2008?

mlmcc
0
 

Author Comment

by:vcharles
ID: 35205705
It is the standalone version.
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 35212263
Try this idea

In the report create 10 formulas
They can simply be an empty string " "
Name the checkboxes as an array of checkboxes
Declare 2 integer variables
Index
FormulaIndex
Syntax for the application is approximate since I don't know .Net

In the application
DonorXML1.RecordSelectionFormula = "{Donor.DonorName} like " & "'*" & TextBox1.Text & "*'" & ""
FormulaIndex = 0
For Index = 0 to 9
    If CheckBox(Index) = CHCECKED then
          FormulaIndex  = FormulaIndex  + 1
          DonorXML1.Formulas(FormulaIndex 0.Text = CheckBox(Index).FieldName - Not Sure how you do this
    End if
With DonorXML1
CrystalReportViewer1.ReportSource = DonorXML1
End With

mlmcc
0
 

Author Comment

by:vcharles
ID: 35227124
Hi,

Main problem is I need to rearrage the columns when I remove certain columns, is that at all possible in Crystal Reports?

Thanks for the code.

Victor
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35227206
No.

However the code I provided uses the formulas from left to right assuming they are put on the report in that order.

mlmcc
0
 

Author Comment

by:vcharles
ID: 35227445
I will check to see if I can use this feature.

Thank you for the solution.

Victor
0
 

Author Closing Comment

by:vcharles
ID: 35227448
Thank You!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

783 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