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.
Company Margin Exposure
AB 500 3
ABC 200 4
Answers were Sorted based on User's Feedback
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|
Answer / pankaj
This answer is for suppressing the Columns with Condition at
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|
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|
Answer / selvaraman
You can use underlay following section option from section
|Is This Answer Correct ?||3 Yes||3 No|
Answer / siva nomula
The better way is to filter data using sql query stage
|Is This Answer Correct ?||1 Yes||3 No|
Can we use our own SQL for creating a report?
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
Can anyone help me with an answer to this question? Where is the image located, after you've placed it on the report?
How the data expert of flash object(after inserting flash object_right click-data expert) is useful in crt?
How to write a formula to change a font based upon data ?
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?
How to "Print" in Crystal Reports while using ASP DOT NET Platform?
How can we improve the performance of a crystal report? OR What all performance improvement techniques used in crystal reports? (particularly CR XI)
Can we add any database field once we have chosen ?Close? button?
Is there any feature like summing total in crystal report?
Why is Excel Report preferred over crystal reports?
Can we export data of reports into other format like in world doc etc?