i m working on CR.NET. i have a problem where in i need to display the columns of dataset with >0 value in crystal report
if in my dataset
Car Type | Car rate AC | Car rate NonAC | Driver Alowance | Night Charge |......
Indica 10 8 250
0
Vista 8 7 250
0
Indigo 12 10 250
0
................................................................................................................
then
Required Result in Report
Car Type | Car rate AC | Car rate NonAC | Driver Alowance |......
Indica 10 8 250
Vista 8 7 250
Indigo 12 10 250
................................................................................
if in my dataset
Car Type | Car rate AC | Car rate NonAC | Driver Alowance | Night Charge |......
Indica 10 8 0
150
Vista 8 7 0
150
Indigo 12 10 0
150
......................................................................................................
then
Required Result in Report
Car Type | Car rate AC | Car rate NonAC | Night Charge |......
Indica 10 8 150
Vista 8 7 150
Indigo 12 10 150
...............................................................................
if in my dataset
Car Type | Car rate AC | Car rate NonAC | Driver Alowance | Night Charge |......
Indica 10 8 250
150
Vista 8 7 250
150
Indigo 12 10 250
150
......................................................................................................
then
Required Result in Report
Car Type | Car rate AC | Car rate NonAC | Driver Alowance | Night Charge |......
Indica 10 8 250
150
Vista 8 7 250
150
Indigo 12 10 250
150
......................................................................................................
plz send a solution
