Can we create report using more than one database?

Answers were Sorted based on User's Feedback



Can we create report using more than one database?..

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

Can we create report using more than one database?..

Answer / arvind gupta

Yes. as well as with single database

Is This Answer Correct ?    6 Yes 0 No

Can we create report using more than one database?..

Answer / vijay yadav

Yes we can use multiple database for create a report.

Is This Answer Correct ?    6 Yes 2 No

Post New Answer

More Crystal Reports Interview Questions

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

3 Answers  


How to print two details fields at the bottom of the page

5 Answers  


If we create reports in Crystal Reports using the UCAR Data Warehouse database, which tables should be used?

0 Answers   IBM,


hi ... i've created one crystal report in windows form and one crystalreportviewer .. the following is my code.. in form1.cs file try { ExportOptions CrExportOptions; DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions(); PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions(); CrDiskFileDestinationOptions.DiskFileName = "c:\\csharp.net- informations.pdf"; CrExportOptions = cryRpt.ExportOptions; { CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions; CrExportOptions.FormatOptions = CrFormatTypeOptions; } cryRpt.Export(); } the above code is saving the file into pdf into specified path.. but i dont want to save a file i should get direct print preview and have a option to print .. As we do in web application using crystal report viewer clicking print and report will be opened in pdf.. and the click print.. i want the same function as we do in web application... i'm writing code in c#.net hope the above explaination will be understood clearly..

0 Answers  


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?

0 Answers   Cognizant,






Is there a way to export the report formulas, like totals to excel?

3 Answers  


How can i normalize a Crystal Report..??

0 Answers   HCL,


Explain the various components in crystal reports?

0 Answers  


What are the sections that we have in Crystal reports?

11 Answers  


Can we use Crystal report as a stand-alone application?

4 Answers   Covansys,


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 Answers   Barclays,


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. Can anybody answer this please....... Regards Vimal.

1 Answers   GRV India, Patni,


Categories