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 / vijay yadav
Yes we can use multiple database for create a report.
| Is This Answer Correct ? | 6 Yes | 2 No |
Can we create report using more than one database?
3 Answers CSC, Seed Infotech, Target,
How many .rpt files are be there in a main report having 2 sub reports?
17 Answers Accenture, Cap Gemini, CTS,
Reports can be optimized for web viewing using which of the following strategies: a. Using subreports instead of linking tables b. Avoiding maps c. Using the Page N of M special field to help users understand how many pages are in the report d. Saving reports as version 10 e. Avoiding reports with drill-down capabilities
How to present data from Crystal Reports on to form?
hi.. i've one crystal report. i want the report header as "employee database". i dont want to right click->insert and goto text object and insert. i've one aspx page and aspx.cs page also. now i want the "employee database" header to be printed from .cs file. i dont want to pass by parameter also.. i.e is there any option in .cs file something like ReportDocument myreport = new ReportDocument(); myreport.Load(MapPath("~/" + "emp.rpt")); myReport.Reportheader="Employee database"; i hope u have understood this. only thing is from .cs file i want to print the header as employee database. i dont want by passing parameter also... please help....
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.
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..
Explain the various components in crystal reports?
Where is the image located, after youve placed it on the report?
HI all, I am developing reports using crystal reports in VS2005 in windows application. I have two crystalreports name called "studentReport" and "familyReport". I have a form with a button. If I click the button I need to show up the two reports in one report like page1, and page2. The page1 consists the "studentReport" and the page2 contains the "familyReport". The "familyReport" contains different header and footer. How to show up the two crystal reports in single crystalreportviewer?
Is there a size limit to creating a Crystal Report? If I run a statement report for all customers it will crash if there are too many customers. I can print all the statements if I select them in batches, but if trying to print all at once Crystal will crash after a few minutes.
How to pass stored Procedure Parameters to the report?
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)