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.
5 37878One 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
5 12350Post New Barclays Crystal Reports Interview Questions
Mention the name of the directory where it is necessary to locate the proxy file to use a web service?
How do you isolate the various bioactive ingredients from a plant extract?
Default distribution channel we have only one distribution channel in our company. Can we default it in the transaction field that needs distribution channel data? How can we configure that?
Is hive similar to sql?
Describe the difference between p-type and n-type semiconductor materials.
What is postgresql jdbc driver?
Define functions of SparkCore?
we are using order related billing and billing get generated automaticaly in overnight run.As my q is user has cancel the biliiing document after creating that one.but after cancelation no cancel accounting document get generated.so sales order remain closed and no billing document get generate in overnight run.but when user has created the Credit memo order with respect to cancel billing document the respective sales order get open and billing document get generate in overnight run.so can you please tell me hwo the system come to knoe after rasing the credit meno order that billing document has cancled and sales order has open so the billing document will be craete.please help me regarding thsi query.
What is transformation ratio what it describes?
query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp
What do you mean by ss table and explain how it is different from the other original tables?
What is object and interface in SAP terms?
what is the difference between JSF and Struts?
How can we work with error tags?
What are contextual backlinks?