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.

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.

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.

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

Answer / arvind gupta

Yes, Using Crystal SQL writer

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

3 Answers  

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

2 Answers  

Is it possible to export crystal report with linked subreports in one excel sheet?If yes,then how?

4 Answers   IBM,

What are the advantages or disadvantages of using Crystal Reports in a Windows Forms application as opposed to say rolling our own reports as HTML and displaying them in the Internet Explorer control?

2 Answers  

How to pass stored Procedure Parameters to the report?

2 Answers  

Can we create report using more than one database?

3 Answers   CSC, Seed Infotech, Target,

how should i highlight a particular column in a report in actuate e designer report? It should be done dynamically while creating report Thanks in advance!!!!!!!!!!

0 Answers  

How many types of reports can be generated in crystal reports?

7 Answers   Finite Infotech, Precision Techconet, VMware, winfoware,

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,

What are the sections that we have in Crystal reports?

11 Answers  

Can we use our own SQL for creating a report?

5 Answers  

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 uncertainty 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 the reports at run time?

0 Answers