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

This answer is for suppressing the Columns with Condition at
runtime

Just right click on the Columns that you want to suppress
and write the function for suppressing the columns if
parameter value is 0 then True(i.e Suppress)

right click on the detail - from the menu select the 
section export check the "suppress blank Section".

SQL Expression is one Feature in Crystal report,by SQL 
commands we pull the data from data base server to crystal 
report. 

Advantage:it's reduce the load on the server. bz we are not 
loading all the table into Crystal reports, just we are 
loading what we want using SQL.

Answer 1:
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.

Answer 2:
The following article would explain about this:
https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.s
ap.km.cm.docs/oss_notes_boj/sdn_oss_boj_erq/sap
(bD1lbiZjPTAwMQ==)/bc/bsp/spn/scn_bosap/notes%
7B6163636573733d36393736354636443646363436353344333933393338
323636393736354637333631373036453646373436353733354636453735
364436323635373233443330333033303331333233313337333833373331
%7D.do

Answer 3:
This was to confuse you further.There are formula 
fields,database fields,sql expression fields,paramter 
fileds etc and nothing like expression fields.

One feature is there in crystal report xi.First To insert 
an image we are doing Insert->click Picture -> we select a 
picture from a directory that you have access to and click 
on open and insert the picture where in report header 
section.
To make the above object dynamic we can follow below steps:
1.Right-click the static OLE object that you inserted, and 
choose Format
Graphic from the shortcut menu.
2. In the Format Editor, click the Picture tab, and then 
click the Conditional
Formula button adjacent to the Graphic Location label.
3. In the Formula Workshop, create the path
For example, if your path is stored in a database field, 
add that field to the
formula.
4. Click Save and close to return to the Format Editor.
5. Click OK to return to your report.
6. Click Refresh to update the reference link

when the ole object is placed inside the report, report 
converts it into static object i.e it creates the copy of 
the original object .If any modifications are done to the 
object in the report only the object present in the reports 
get affected.

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.


i think this should help u .

Ans-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.

You may have used Link Image at design time (while 
inseerting OLE object) therefore report requires it on 
machine on whihc report will be run. One can solve this 
problem by embeding image in report rather than linking it 
(by unchecking Link opetion while selecting image).

try { 
        // here i have define a simple datatable inwhich 
image will recide 
        DataTable dt = new DataTable(); 
        // object of data row 
        DataRow drow; 
        // add the column in table to store the image of 
Byte array type 
        dt.Columns.Add("Image", System.Type.GetType
("System.Byte[]")); 
        drow = dt.NewRow; 
        // define the filestream object to read the image 
        FileStream fs; 
        // define te binary reader to read the bytes of 
image 
        BinaryReader br; 
        // check the existance of image 
        if (File.Exists
(AppDomain.CurrentDomain.BaseDirectory + "10157.Jpg")) { 
            // open image in file stream 
            fs = new FileStream
(AppDomain.CurrentDomain.BaseDirectory + "10157.Jpg", 
FileMode.Open); 
        } 
        else { 
            // if phot does not exist show the nophoto.jpg 
file 
            fs = new FileStream
(AppDomain.CurrentDomain.BaseDirectory + "NoPhoto.jpg", 
FileMode.Open); 
        } 
        // initialise the binary reader from file 
streamobject 
        br = new BinaryReader(fs); 
        // define the byte array of filelength 
        byte[] imgbyte = new byte[fs.Length + 1]; 
        // read the bytes from the binary reader 
        imgbyte = br.ReadBytes(Convert.ToInt32
((fs.Length))); 
        drow(0) = imgbyte; 
        // add the image in bytearray 
        dt.Rows.Add(drow); 
        // add row into the datatable 
        br.Close(); 
        // close the binary reader 
        fs.Close(); 
        // close the file stream 
        CrystalReport1 rptobj = new CrystalReport1(); 
        // object of crystal report 
        rptobj.SetDataSource(dt); 
        // set the datasource of crystalreport object 
        CrystalReportViewer1.ReportSource = rptobj; 
        //set the report source 
    } 
    catch (Exception ex) { 
        // error handling 
        Interaction.MsgBox("Missing 10157.jpg or 
nophoto.jpg in application folder"); 
    }

write the column of Byte array Type
And pass Tha byte data into this column 
and drag the column to the crystal report.

If you are working with version 11 , then drag and drop an 
ole object rt click on format graphic --> go to picture tab
--> Graphic Location -->enter your path in the formula.

if you choose enforce to for a  join type table a and table 
b and you select only fields from table a even then table b 
is included.

if you choose enforce from for a join type from tableA and 
table B and you select only fields from table B still the 
table A is included.

can u give me any example and answered clearly

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......

Firstly Create report. Then use crystal report viewer that 
will be docked or normal view in any form.

U have to create object of created report and form that 
contain report viewer.

dim crp_MyReport= new crp_ReportTest
Dim frm_Viewer=new frm_ViewerTest
If u want to pass parameter
dim parameter system.crystaldecision.shared.parameter
dim parameters system.crystaldecision.shared.parameters
dim parameters=crp_myreport.parameters
for each parameter in parameters
  select .parameterfieldname
       case "parametername1"
          .currentvalue.addvalue(value)
   end case
next
frm_viewer.crv_viewer.refresh()
frm_viewer.crv_viewer.reportsource=crp_Myreport
frm_viewer.show()

YOU HAVE TO USE SHARED VARIABE AND PASS THAT VARIABLE TO 
YOUR PRIMARY REPORT, THERE YOU HAVE TO USE THE CONDITION.

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..

Subreport is a report added to the main report and is not 
possible to add or call another subreport with  subreport.

sub report is a report just like main report.we can add as
many subreports(256 only) into main report but within one
subreport we can not add or call another 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.

No. We can not call or add another subreport within a
subreport. If you do the same you wiil find some unexpected
output or errors.

No.It is not possible to nest subreports.Crystal reports
(XI) does not support subreports within subreports.

It is not possible in crystal,
its possible with ssrs

Its not possible to add subreport within subreport.If we 
trying to do that under insert ->subreport option was 
disabled.

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.

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

report footer and page footer are different. they wont
change normally. if we want to change them then we have to
write formulas for them

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'.