Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: accessing the report form Post Reply Post New Topic
Author Message
shankar.nstl
Newbie
Newbie


Joined: 09 Sep 2011
Online Status: Offline
Posts: 8
Quote shankar.nstl Replybullet Topic: accessing the report form
    Posted: 15 Sep 2011 at 2:46am
I am using crystal reports 9. I connected the report form with my excel DATA. How can I connect the report from the USERFORM created with EXCEL VBA. Pls provide solution.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 20 Sep 2011 at 3:17am
I don't really know what you are saying, but if it isn't data, CR probally isn't going to see it.  CR doesn't read vba, it only reads data.
IP IP Logged
shankar.nstl
Newbie
Newbie


Joined: 09 Sep 2011
Online Status: Offline
Posts: 8
Quote shankar.nstl Replybullet Posted: 20 Sep 2011 at 3:56am
Thank you so much dear lockwelle

I mean I want to place a commandbutton on to my VBA excel userform and through that I want to open the designed CR ? How can it possible ?
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 20 Sep 2011 at 4:04am
I am not sure how one would go about that.
 
You would want to create a new instance of the Crystal report viewer, set the report source to the correct report and the datasource to the Excel, and any parameters to the correct values and then 'Show' the report viewer, at least those are the steps I believer one would need to complete to display a report in .Net... I would assume they would be similar in VBA, but I don't know if all of that is possible.
 
Sorry I can't be of more help.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.