Can we create report using more than one database?
Answers were Sorted based on User's Feedback
Answer / rahul
Yes. We can create report using more than one database like
Oracle, Access. Create data source name for both the
databases. Select tables from them and create the report.
Only restriction is if you use two databases then you
cannot see the SQL generated by crystal reports.
|Is This Answer Correct ?||16 Yes||2 No|
Answer / arvind gupta
Yes. as well as with single database
|Is This Answer Correct ?||6 Yes||0 No|
Answer / vijay yadav
Yes we can use multiple database for create a report.
|Is This Answer Correct ?||6 Yes||2 No|
to ensure that all of the data from a field is displayed in a report text object you should do which of the following?? a) use the format wizard b) size the text object manually c) select the auto format option for the text object d) select the can grow option for the text object e) set the can grow option to the details section of the report
Suppose 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?
Suppose 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?
Can we export data of reports into other format like in world doc etc?
Are there any limitations in crystal reports?
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 to conditionally suppress a field based on whether a page number is odd or even?
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 open subreport in new ie window using hyperlink button. I used target=new; in the formula field. But it overrides the main window and show the report?
How to write a formula to change a font based upon data ?
what is the "refresh" button suppose to do on the crystal report viewer?
Can we use Crystal report as a stand-alone application?