Solved

How to select fields to display in a report

Posted on 2011-03-23
13
205 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 100

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 100

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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

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 100

Expert Comment

by:mlmcc
ID: 35204183
What version of Crystal?

mlmcc
0
 

Author Comment

by:vcharles
ID: 35204191
version 2008
0
 
LVL 100

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 100

Accepted Solution

by:
mlmcc earned 500 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 100

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

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…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

772 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