Can we use our own SQL for creating a report?
Answers were Sorted based on User's Feedback
Answer / mlmcc
The Crystal Designer tool was dropped in Crystal 9.
Crystal replaced it with an option to build a Crystal
Command as the data source. You can build any valid SQL in
the command feature.
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / rahul
We can also make our own query using Crystal SQL Designer
tool provided by SQL. Here you can insert your SQL
statement as such. It will save this file as .qry . And
when you create a report instead of using Database button
use Crystal SQL Statement button.
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / vijay yadav
Yes we can use our SQL query, when developer select the
table or the procedure name for create the report so at the
place of them select Add Command and than a editor will
display so there you can add ur query.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / abhishek
Dear frnds,
I have one doubt...
am using sql server 2005..
in this i restored two databases..(A & B)
in the both dbs have same sql query's...
but the the result is different...result format is same...
EX in both EMPID,EMPNAME
a sp result 1 abhi
and
b sp result 2 ravi
in the crystal reports i want to show both results in one
report...
i dont know how to do this....
plz send how can i get the result in one report...
basg.004@gmail.com
Is This Answer Correct ? | 1 Yes | 0 No |
How do we format field?
How can we improve the performance of a crystal report?
How to write a formula to change a font based upon data ?
If we create reports in Crystal Reports using the UCAR Data Warehouse database, which tables should be used?
HOW TO USE 5 CRYSTAL REPORT OR SUBREPORT ON DIFFERENT CONDITIONS IN ONE VB PROGRAM
hi.. i've created a crystal report and one crystal report viewer in windows form. i've two form form1 and form2 in form2 i've kept one button called print. when i press this button it should print the document into .pdf format. without using the crystal report viewers print button.
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?
How to pass stored Procedure Parameters to the report?
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..
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
How many sub-reports can report can have?
How many .rpt files are be there in a main report having 2 sub reports?
17 Answers Accenture, Cap Gemini, CTS,