borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder

AndreaVB | Forum | News | Downloads | Register | Help | Member List | Statistics | Search | PM | Profile

Print This Topic
Previous Topic (AutoNumber In DataReport???)Next Topic (Execute more than 1 SQL command) New Topic New Poll Post Reply
AndreaVB Forum : Reporting tools : Crystal Reports...Please POST i need the answer sooner than next week...please please...
Poster Message
nick2k4000
Level: Big Cheese

Registered: 29-09-2003
Posts: 20

icon Crystal Reports...Please POST i need the answer sooner than next week...please please...


Crystal Reports 8.5

i'm using CR 8.5 as my report generator...the problem is i cant seem to change the pictures on my crystal report...
now, i need it to be able to load different profiles of my clients which includes scanned pictures...i want the pictures not to remain constant...i want it variable like...please do reply please...i needed it...


ive tried this - > picture1.setolelocation "c:\image1.jpg"

it returned an error -> permission denied!!
ive also tried loading it as a picture like loadpicture("c:\image1.jpg") and it still made the same error...


please please... i need this real bad...please do reply please?



                          

29-10-2003 at 10:12 AM
View Profile Send Email to User Show All Posts | Quote Reply
nick2k4000
Level: Big Cheese

Registered: 29-09-2003
Posts: 20
icon Re: Crystal Reports...Please POST i need the answer sooner than next week...please please...

since no one has replied to my problem...i solved it my self....
not bad for hours of work...hehehe

-------------------------------------------
i first created a field for storing the path of my images in my database....then i opened my crystal report form and inserted the field to the crystal report....i then insert an OLE picture or just a plain picture....i arranged the field so that it will be at the back of my picture and it will not show during printing....

Code.....
in the section were my field and my picture is placed...i included the following

Private Sub Section8_Format(ByVal pFormattingInfo As Object)
Dim sa As StdPicture
Set sa = LoadPicture(App.Path & "\" & Trim(Field16.Value) & ".jpg")
Set Picture1.FormattedPicture = sa
End Sub

''''note....you dont need to follow my section8 since you can put your objects in any part of the crystal report...

hope this works.....

01-11-2003 at 03:24 AM
View Profile Send Email to User Show All Posts | Quote Reply
gisenberg
Level: Guest

icon Re: Crystal Reports...Please POST i need the answer sooner than next week...please please...

I have CR9 standalone and VB.NET

I have stored a filepath in an Access DB and I am trying to use the StdPicture, but when I try to use the DIM sa AS, I do not get StdPicture as an option.  What do I need to do to get this option to show up in VB.NET?

Code.....
in the section were my field and my picture is placed...i included the following

Private Sub Section8_Format(ByVal pFormattingInfo As Object)
Dim sa As StdPicture
Set sa = LoadPicture(App.Path & "\" & Trim(Field16.Value) & ".jpg")
Set Picture1.FormattedPicture = sa
End Sub

26-07-2004 at 05:11 PM
| Quote Reply
nick2k4000
Level: Big Cheese

Registered: 29-09-2003
Posts: 20
icon Re: Crystal Reports...Please POST i need the answer sooner than next week...please please...

quote:
gisenberg wrote:
I have CR9 standalone and VB.NET

I have stored a filepath in an Access DB and I am trying to use the StdPicture, but when I try to use the DIM sa AS, I do not get StdPicture as an option.  What do I need to do to get this option to show up in VB.NET?

Code.....
in the section were my field and my picture is placed...i included the following

Private Sub Section8_Format(ByVal pFormattingInfo As Object)
Dim sa As StdPicture
Set sa = LoadPicture(App.Path & "\" & Trim(Field16.Value) & ".jpg")
Set Picture1.FormattedPicture = sa
End Sub




how about you remove the "as stdpicture" ...  it'll be a variant or any form of variable... let VB decide how it should take form ok?  i havent tried it so it may be wrong...
28-07-2004 at 04:50 AM
View Profile Send Email to User Show All Posts | Quote Reply
nick2k4000
Level: Big Cheese

Registered: 29-09-2003
Posts: 20
icon Re: Crystal Reports...Please POST i need the answer sooner than next week...please please...

hey i got your problem now...this is probably the solution...

--->>> open this menu -> project> references then check if the "OLE Automation" is selected okay? try it because when i removed the option the stdpicture did not appear...its kinda really difficult to find because it contains lists of references...so be patient...if you cant find it...then click browse and locate the file "stdole2.tlb"  okay? it should now appear...

28-07-2004 at 05:01 AM
View Profile Send Email to User Show All Posts | Quote Reply
gisenberg
Level: Guest

icon Re: Crystal Reports...Please POST i need the answer sooner than next week...please please...

Is this for VB.NET or VB6....I could not find anything in VB.NET for 'OLE Automation'

30-07-2004 at 05:11 AM
| Quote Reply
jani_jignesh2001@yahoo.co
Level: Guest

icon Re: Crystal Reports...Please POST i need the answer sooner than next week...please please...

Dear,

         Everything seems to be correct. But can anybody please tell me how can i add these all code in to crystal reports because i am unable to find any event for section format. I am using VB.NET and i am not able to find a solution how to add event handler for section_format.

Please guide me.

Thanks.

20-08-2004 at 05:34 AM
| Quote Reply
nick2k4000
Level: Big Cheese

Registered: 29-09-2003
Posts: 20
icon Re: Crystal Reports...Please POST i need the answer sooner than next week...please please...

quote:
jani_jignesh2001@yahoo.co wrote:
Dear,

         Everything seems to be correct. But can anybody please tell me how can i add these all code in to crystal reports because i am unable to find any event for section format. I am using VB.NET and i am not able to find a solution how to add event handler for section_format.

Please guide me.

Thanks.

try including stdole2.tlb to the list of your references. I hope it works...(nevah tried using .net!!!)
17-12-2004 at 03:45 PM
View Profile Send Email to User Show All Posts | Quote Reply
AndreaVB Forum : Reporting tools : Crystal Reports...Please POST i need the answer sooner than next week...please please...
Previous Topic (AutoNumber In DataReport???)Next Topic (Execute more than 1 SQL command) New Topic New Poll Post Reply
Surf To:


Not Logged In? Username: Password: Lost your password?
Partners: Download Actual Software | Free Software Download
borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder