1. Categories >> Software >> Microsoft Related >> Crystal Reports
  2. Suggest New Category

One more interview question

If I have the data where some columns have multiple values
in a given row of data returned from the database. The
stored procedure returns data as it is that is blanks
values and non blank values.

However, I need to suppress the blank values not by showing
0 values but by shifting the cells up. Is there a way
using a formula to shift the blank cell one row up based on
a selection critieria?

In the example below, I want to get rid of the blank values
under Exposure column without replacing with 0.
example:

Company Margin Exposure
AB 500 3

10
7

8

ABC 200 4
2
5

10

Thanks
Anita

Question Posted / novice123

Answers were Sorted based on User's Feedback



One more interview question If I have the data where some columns have multiple values in a giv..

Answer / mk

right click on the detail - from the menu select the
section export check the "suppress blank Section".

Is This Answer Correct ?    16 Yes 4 No

One more interview question If I have the data where some columns have multiple values in a giv..

Answer / pankaj

This answer is for suppressing the Columns with Condition at
runtime

Just right click on the Columns that you want to suppress
and write the function for suppressing the columns if
parameter value is 0 then True(i.e Suppress)

Is This Answer Correct ?    10 Yes 7 No

One more interview question If I have the data where some columns have multiple values in a giv..

Answer / jayanta

Enable Suppress Blank Section from Section Expert for detail
section. Column wise formula we will provide when we will
suppress repeated column values or like this. In this
scenario we consider Enable Suppress Blank Section.

Is This Answer Correct ?    5 Yes 2 No

One more interview question If I have the data where some columns have multiple values in a giv..

Answer / selvaraman

You can use underlay following section option from section
expert

Is This Answer Correct ?    3 Yes 3 No

One more interview question If I have the data where some columns have multiple values in a giv..

Answer / siva nomula

Hi,
The better way is to filter data using sql query stage

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Crystal Reports Interview Questions

I am not able to see any image on Crystal Report at Run time. So how can I load any image which is saved in local disk so that it can be viewed at Runtime in Crystal reports?

5 Answers  

Can we add any database field once we have chosen ?Close? button?

2 Answers  

When looking at the join types in Crystal - what does it mean when you coose Enforce and Enforce To or Enforce From

3 Answers  

Is there a way to export the report formulas, like totals to excel?

3 Answers  

How to open subreport in New IE window using hyperlink button. I used target=new; in the formula field. But it overrides the main window and show the report. Can anybody answer this please....... Regards Vimal.

1 Answers   GRV India, Patni,




Explain reporter footer contents are move depend the page footer values?

0 Answers  

How many .rpt files are be there in a main report having 2 sub reports?

17 Answers   Accenture, Cap Gemini, CTS,

Explain basic steps required to display a simple report in crystal?

0 Answers  

How many types of reports can be generated in crystal reports?

7 Answers   Finite Infotech, Precision Techconet, VMware, winfoware,

Is there a size limit to creating a Crystal Report? If I run a statement report for all customers it will crash if there are too many customers. I can print all the statements if I select them in batches, but if trying to print all at once Crystal will crash after a few minutes.

0 Answers  

How can we improve the performance of a crystal report?

0 Answers  

Where can we find the log file generated when we run a crystal report?

0 Answers  

For more Crystal Reports Interview Questions Click Here
Categories