ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Microsoft Related  >>  Crystal Reports
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions
 C Sharp interview questions  C Sharp Interview Questions
 ASP.NET interview questions  ASP.NET Interview Questions
 VB.NET interview questions  VB.NET Interview Questions
 COM+ interview questions  COM+ Interview Questions
 ADO.NET interview questions  ADO.NET Interview Questions
 IIS interview questions  IIS Interview Questions
 MTS interview questions  MTS Interview Questions
 Crystal Reports interview questions  Crystal Reports Interview Questions
 BizTalk interview questions  BizTalk Interview Questions
 Dot Net interview questions  Dot Net Interview Questions
 Exchange Server interview questions  Exchange Server Interview Questions
 SharePoint interview questions  SharePoint Interview Questions
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions
Question 
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 Submitted By :: Novice123
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 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
Answer
# 1		 
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 ?    3 Yes 3 No
Pankaj
 
  Re: 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
Answer
# 2		 
right click on the detail - from the menu select the 
section export check the "suppress blank Section".
 
Is This Answer Correct ?    2 Yes 0 No
Mk
 
 
 

 
 
 
Other Crystal Reports Interview Questions
 
  Question Asked @ Answers
 
How many sections are there in the report  4
Is it possible to join more than one universe in Busniess Objects BOE XI ? If its so Please explain how is that possible ? Thanks in advance for the people posting the answers Wipro2
Is there any feature like summing total in crystal report? Sonata9
How to pass stored Procedure Parameters to the report?  1
Are there any limitations in crystal reports?  14
Can we export data of reports into other format like in world doc etc?  5
Can we use Crystal report as a stand-alone application? Covansys4
What does it mean when we get the error message "Invalid report version" when try to open a Crystal Report?  3
How do you format your crystal reports so that on exporting to word doc or pdf it will not lose the orginal format Target3
Is there a way to export the report formulas, like totals to excel?  2
How to print two details fields at the bottom of the page  1
how to create crystal reports in .net CTS2
How do we connect to the database?  4
What are the advantages or disadvantages of using Crystal Reports in a Windows Forms application as opposed to say rolling our own reports as HTML and displaying them in the Internet Explorer control?  2
Reports can be optimized for web viewing using which of the following strategies: a. Using subreports instead of linking tables b. Avoiding maps c. Using the Page N of M special field to help users understand how many pages are in the report d. Saving reports as version 10 e. Avoiding reports with drill-down capabilities  1
How to refresh the crystal report from the application ? Satyam4
Can anyone help me with an answer to this question? Where is the image located, after you've placed it on the report?  2
I have a crystal report with a linked subreport as well. is there any way not to print the current record on the main report if no records are returned from the subreport? thanks you email - stanlte@yahoo.com  2
When looking at the join types in Crystal - what does it mean when you coose Enforce and Enforce To or Enforce From  2
Can we create report using more than one database? Target3
 
For more Crystal Reports Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com