hi,
i wan to retrieve the field (called pic_path)  from stored procedure (using Microsoft SQL Server 2000) and use this field to load the picture in the crystal report. and i find the difficulty to retrieve the field. is there anyone can help me?


____________________________
hai hai

Design a report using that stored Procedure and insert a field in the report

____________________________

Madhivanan

Failing to plan is Planning to fail

tq.
but how to load the picture in the crystal report by using the field from the stored procedure?


____________________________
hai hai

If you are reffering to how to display an image if you have stored path to image in database and not the image itself, then search in this section for answer, If I am not mistaken it si somewhere in the last topics.

[Edited by Goran on 10-05-2005 at 12:21 PM GMT]

____________________________
If you find the answer helpful, please mark this topic as solved.

do u mean by using the LOADPICTURE function? it is not supported in the crystal report...

____________________________
hai hai

The code IS for the crystal reports... Just search for the topic, I believe is has more than 1 10 posts in it,

____________________________
If you find the answer helpful, please mark this topic as solved.

this coding?

<<--
dim appl as craxdrt.application
dim rpt as craxdrt.report
dim withevents sect as craxdrt.section

' change section10 to name of the section where picture is displayed

private sub form_load()
    set appl=new craxdrt.applicaiton
    set rpt=appl.openreport(app.path & "\reportname.rpt")
    set sect=rpt.sections("Section10")
end sub


private sub sect_format(..............)
    with sect.reportobjects
        .item("picture1").setolelocation .item("fldPath").value
end sub

-->>

- this one i cant use in the crystal report but it did with the crystal report viewer


any other solutions?

____________________________
hai hai