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
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
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 |
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
expert
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / siva nomula
Hi,
The better way is to filter data using sql query stage
| Is This Answer Correct ? | 1 Yes | 3 No |
where is the "save data with report" option?
Where is the image located, after youve placed it on the report?
How to write a formula to change a font based upon data ?
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
How can we improve the performance of a crystal report?
Explain basic steps required to display a simple report in crystal?
how can we convert crystal dictionary dc5 file to another datasource format like mdb or xml schema
Kindly Help for this Below Scenario, I am going to implement Power BI into our internal software. I’m familiar with the fact that each user can pay $9.99 a month to build and view reports but what I need to know is how can we embed Power BI into our application so that any users that log into our application can see the reports without the monthly fee. I’ve researched enough that it can be done. What I am not familiar with is how to do it or the pricing of embedding it into an application. I think they do pricing on how many renders you do or something. Would you be able to look into how we could embed it into our software and the cost?
Is it possible to export crystal report with linked subreports in one excel sheet?If yes,then how?
Can anyone help me with an answer to this question? Where is the image located, after you've placed it on the report?
How to "Print" in Crystal Reports while using ASP DOT NET Platform?
I had an Interview yesterday for a Crystal Reports Developer position. Some of these I have not done in my reporting experience and I had just a half day's notice for the interview, hence no prep time :-( 1) Is there a way to be able to change an image(company logo) dynamically in a report? Example if you have 100 reports, and with the market uncertainity if you anticipate that the company logo might change, how can you change the image just in one place and have this reflected in all teh reports at run time? 2) What is a SQL expression? 3) What are field expressions and what are the diff types? (I looked this up in the internet and never found anything with regards to types of field expressions) The interviewer really got me confused as I felt he was not clearly setting forth his questions but it could be that I was unable to understand his wording of the questions. I expect a big zero from his feedback but I am hoping this is an experience for future interviews that I face in crystal reports when I do get some more lined up. Thanks in advance! Anita New Jersey, USA.
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)