Crystal Reports accessing the report form

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: accessing the report form

Author	Message
shankar.nstl Newbie Joined: 09 Sep 2011 Online Status: Offline Posts: 8	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 Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	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 Logged

shankar.nstl Newbie Joined: 09 Sep 2011 Online Status: Offline Posts: 8	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 Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	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 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.031 seconds.