Crystal Reports Questions And Answers

1⟩ How to print two details fields at the bottom of the page?

Add a new Details section to the report and place the two

fields in it and by selecting the format option for this

Details1 section you can find the option like Print at bottom

of the page

Is this answer helpful? 0 Yes | 0 No

Answer This Question

181 views

2⟩ 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?

Yes,there is a way.User may create a word document,embed

the required image as a picture object in it and then embed

this word document inturn into Crystal reports(as a linked

OLE object).

Any change in the word document would reflect in all he

reports using this word doc.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

186 views

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)?

This was to confuse you further.There are formula

fields,database fields,sql expression fields,paramter

fileds etc and nothing like expression fields.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

194 views

4⟩ 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?

I use window.open (javascript) to open my report in a new

window. What I prefer to do now is to export the report

right away and open it in portable document format.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

169 views

5⟩ Where is the image located, after youve placed it on the report?

1.actually it depends on the type of ole implementation u r

doing i.e. static , embedded or linked. (refer 3)

2. An OLE object is, a presentation of data that was

created in another application and that maintains a

relationship with the application that was used to create

it. A bitmap created in Paint, an Excel

spreadsheet, or a graph from MS Graph may all be OLE

objects if they are inserted in the receiving document as

OLE objects. If they are not inserted as OLE objects, they

retain no relationship with the original application.

3.

Static object

A static OLE object is a picture of an object that can be

displayed and

printed, but not edited in place. It does not have a

connection to a server

application. There are two kinds of static objects: static

bitmaps and static

metafiles.

• Embedded object

An embedded object contains a representation of the object,

as well as

information that defines the content. It does not have a

connection to the

original object in the server document. As a general rule,

use embedded

objects when you need to edit the object independently of

the original

server document.

• Linked object

A linked object contains a representation of the data and a

link to the file

where it originated. As a general rule, use linked objects

when the data in

the server document is changing and you want the object in

your report to

be updated when you open the report.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

165 views

6⟩ Reports can be optimized for web viewing using which of the following strategiesa. Using subreports instead of linking tablesb. Avoiding mapsc. Using the Page N of M special field to help users understand how many pages are in the reportd. Saving reports as version 10e. Avoiding reports with drill-down capabilities?

a), we can have on-demand sub report and load data as

per user selection instead of bring all the records every

time with table linking.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

189 views

7⟩ 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?

write the column of Byte array Type

And pass Tha byte data into this column

and drag the column to the crystal report.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

193 views

8⟩ When looking at the join types in Crystal - what does it mean when you coose Enforce and Enforce To or Enforce From?

Version 10 introduced the capability to enforce link created in report. Enforcing a link between two tables ensures that the report's respective SQL uses this link, regardless of whether fields are required from one or both the involved tables.

The default setting is unenforced links, meaning that Crystal Reports uses the link only if the report's respective SELECT statement requires it.

You can access the different enforcement option by right-clicking on a link and selecting the link Options menu item.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

212 views

9⟩ How to create crystal reports in .net?

Select new item add Crystareport.rpt.report page will be

generated.In asp page u need to add crystal report viewer

control.

In aspx page follow the below code.....

ReportDocument rpt=new ReportDocument()

....

.....

..Fill the type dataset with ur required data.

.......

.....

rpt.Load(server.mappath("crystareport name"))

rpt.SetDataSource(objds);

CRV10.ReportSource = rpt;

.................

.............

after that switch to crystal report form and add dataset to

the report using databse expert......

Is this answer helpful? 0 Yes | 0 No

Answer This Question

197 views

10⟩ 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?

yes, we can achieve that using shared variables as

mentioned already. however, should also make sure that the

subreport values should come to the primary report before

the section you have records on..

Is this answer helpful? 0 Yes | 0 No

Answer This Question

185 views

11⟩ Can we call or add subreport within subreport?

If you create report with subreport and save it. Create

another report and add the first report as an subreport.

If you try to create a subreport after it's inserted it's

dificult. I think the limit on all subreports is 256.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

182 views

12⟩ Where can we find the log file generated when we run a crystal report?

When the reports run, a log file is created and each

report's output will placed the specified output directory

with the output file name specified. If only a prefix is

specified, the output name will also have a date and time

stamp making it easy to archive reports for later viewing.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

169 views

13⟩ HOW TO USE 5 CRYSTAL REPORT OR SUBREPORT ON DIFFERENT CONDITIONS IN ONE VB PROGRAM?

different 5 condition is a=1,2,3,4,5

in button click

we write

if a=1 then

Dim report as new cr_1

cr_1.show

else

Dim report as new cr_2

cr_2.show

else

Dim report as new cr_3

cr_3.show

else

Dim report as new cr_4

cr_4.show

else

Dim report as new cr_5

cr_5.show

end

Is this answer helpful? 0 Yes | 0 No

Answer This Question

206 views

14⟩ Explain reporter footer contents are move depend the page footer values?

Yes we can change the value of report footer depending on

the page number contents.

Create a formula '@formula'

towords(pagenumber,0)

plcae it in RF which will show the last page number in

words.

suppose total number of page is 24 then 'Twenty Four'.

if total pages are 5 then 'Five'.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

215 views

15⟩ 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 wizardb) size the text object manuallyc) select the auto format option for the text objectd) select the can grow option for the text objecte) set the can grow option to the details section of the report

d) select the can grow option for the text object

Is this answer helpful? 0 Yes | 0 No

Answer This Question

182 views

16⟩ Why is Excel Report preferred over crystal reports?

As every Windows OS has Microsoft Excel reports and as it is simple, people are familiar with it.

It has formula field in it to do calculations.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

182 views

17⟩ 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 tworeports 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?

If I am not mistaken then this can be achieved by make

Student report as main report and your other report

familyreport as subreport of the main report opening in new

page.

For different page header of both report what you can do is

in main report dont put any thing in PageHeader or Footer

create a blank group in that create page header for main

report and in group footer create main report page footer

data and on group select option repeat on each page.

May be this will help to solve your problem if I have

understand what you are looking for.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

188 views

18⟩ How can we improve the performance of a crystal report? OR What all performance improvement techniques used in crystal reports? (particularly CR XI)?

There are multiple ways to do that...

1. Using Report bursting indexes.

2. and Sub reports degrade the performance, So avoid using

sub reports

Is this answer helpful? 0 Yes | 0 No

Answer This Question

175 views

19⟩ How to add Crystal Reports(Standalone) to my VB.NET project?

There are 2 versions of crystal reports available

1. standalone reports like Crystal Reports 10,XI,XI R2

2. Crystal Reports which comes with Visual Studio .Net like

Crystal Reports for Visual Studio-Embedded Reports

if want to add reports, then go to Add Existing Item (right

click on the project name in the solution explorer), browse

to the .rpt file and select it or Add New Item an select

Crystal Reports from the Templates.

if you want to display reports, you should use Crystal

Repors Viewer

coding:

private ReportDocument hierarchicalGroupingReport;

protected void Page_Init(object sender,eventargs e)

{

configurecrystalreports();

}

private void configurecrystalreports()

{

hierarchicalGroupingReport=new ReportDocument();

string reportPath=server.mappath("Hierarchical

Grouping.rpt");

hierarchicalGroupingReport.Load(reportPath);

CrystalReportViewer1.ReportSource=hierarchicalGroupingReport

;

}

Is this answer helpful? 0 Yes | 0 No

Answer This Question

177 views

20⟩ How many Sub Reports added in One MainReport?

The correct answer is,

At most you can add 255 sub reports in the main report. so

the total count is 256 reports are allowed for a standalone

report.

You can not add a sub report inside a sub report. This is

one of the important question as far as for interview point.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

164 views

Crystal Reports

Home Microsoft .Net Technologies Crystal Reports

22 Crystal Reports Questions And Answers

1⟩ How to print two details fields at the bottom of the page?

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)?

4⟩ 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?

5⟩ Where is the image located, after youve placed it on the report?

7⟩ 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?

8⟩ When looking at the join types in Crystal - what does it mean when you coose Enforce and Enforce To or Enforce From?

9⟩ How to create crystal reports in .net?

10⟩ 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?

11⟩ Can we call or add subreport within subreport?

12⟩ Where can we find the log file generated when we run a crystal report?

13⟩ HOW TO USE 5 CRYSTAL REPORT OR SUBREPORT ON DIFFERENT CONDITIONS IN ONE VB PROGRAM?

14⟩ Explain reporter footer contents are move depend the page footer values?

16⟩ Why is Excel Report preferred over crystal reports?

18⟩ How can we improve the performance of a crystal report? OR What all performance improvement techniques used in crystal reports? (particularly CR XI)?

19⟩ How to add Crystal Reports(Standalone) to my VB.NET project?

20⟩ How many Sub Reports added in One MainReport?

Quick Links:

Crystal Reports

Home Microsoft .Net Technologies Crystal Reports

22 Crystal Reports Questions And Answers

1⟩ How to print two details fields at the bottom of the page?

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)?

4⟩ 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?

5⟩ Where is the image located, after youve placed it on the report?

7⟩ 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?

8⟩ When looking at the join types in Crystal - what does it mean when you coose Enforce and Enforce To or Enforce From?

9⟩ How to create crystal reports in .net?

10⟩ 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?

11⟩ Can we call or add subreport within subreport?

12⟩ Where can we find the log file generated when we run a crystal report?

13⟩ HOW TO USE 5 CRYSTAL REPORT OR SUBREPORT ON DIFFERENT CONDITIONS IN ONE VB PROGRAM?

14⟩ Explain reporter footer contents are move depend the page footer values?

16⟩ Why is Excel Report preferred over crystal reports?

18⟩ How can we improve the performance of a crystal report? OR What all performance improvement techniques used in crystal reports? (particularly CR XI)?

19⟩ How to add Crystal Reports(Standalone) to my VB.NET project?

20⟩ How many Sub Reports added in One MainReport?

BE THE FIRST TO KNOW

Quick Links: