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

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

Can we use our own SQL for creating a report?

5 Answers  


hi...to all i want to generate the two crystal reports one is employee and another is project. now i want to display the two reorts in a single crystal report viewer. i've tried using sub-reports but the page header is not avaliable in a sub reports.. so i want to display two separate crystalreports in a single viewer.. can anybody help me.. plz

1 Answers  


Can anyone help me with an answer to this question? Where is the image located, after you've placed it on the report?

2 Answers  


How the data expert of flash object(after inserting flash object_right click-data expert) is useful in crt?

0 Answers  


How to write a formula to change a font based upon data ?

2 Answers  






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  


How to "Print" in Crystal Reports while using ASP DOT NET Platform?

3 Answers  


How can we improve the performance of a crystal report? OR What all performance improvement techniques used in crystal reports? (particularly CR XI)

9 Answers   CSC, Jupiter, ERS,


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

2 Answers  


Is there any feature like summing total in crystal report?

11 Answers   HCL, Sonata,


Why is Excel Report preferred over crystal reports?

3 Answers   Atos Origin, Collabera, Lighthouse Technologies,


Can we export data of reports into other format like in world doc etc?

5 Answers  






Categories