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 31751
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 Anita5 7803
Give me a specific example of a time when you had to conform to a policy with which you did not agree.
How are user groups and infosets related?
Can you please help me calculate the pre tax profit for credit card for 2014 using the following Assumptions. Request you to list the steps used. Charges Late fee £12 per occurrence Over limit fee £10 per occurrence Cash fees 3% of cash withdrawal value Annual Fee £25 per account, per year Interchange 1% of transaction value KPIs Accounts overdue 10% per month Accounts over limit 15% per month Average APR 30% Balances revolving 90% of balance Average balance £900 at end of 2013 Expected growth in average balance (2014) 10% per annum Assumptions Open accounts 200,000 at 2013 year-end New accounts booked 5,000 per month Annual operating cost £50 per open account Cost of Acquisition £50 per account Provision rate 9% of total balances Annual cost of funds 4% by balance Charge off Unit charge-off rate in 2014 11% of accounts at 2013 year-end Unit charge-off rate in 2014 0% of accounts booked in 2014 Post charge-off recoveries 20% of balance Account Transactions Monthly turnover 5% of total month end balances Cash advances 20% of monthly turnover Additional Assumptions Please state any additional assumptions you have made to calculate your answer Thanks in advance,
State the difference between the expected value and mean value?
Explain in which level does the original movie resides? : adobe flex action script
How do you invoke a base member function from a derived class in which you have not overridden that function?
Is there any metal that does not contain iron?
Explain about Property-Map-DecisionTree method?
Define pattern markings?
Which plant fossil is the oldest among the others those found by archeologists?
Explain asset accounting? : fi- asset accounting
What is counta in excel?
which date sensex was a top positon n how much?
Is 9 a prime number?
what did u do in the sap sd project ?how did u maping your client business?plz i need help....