Crystal Reports Convert to PDF using store procedure as datasource

Report Design

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

Topic: Convert to PDF using store procedure as datasource

Post Reply

Post New Topic

Author	Message
aspfun Newbie Joined: 17 Jun 2010 Online Status: Offline Posts: 27	Topic: Convert to PDF using store procedure as datasource Posted: 12 Jul 2010 at 4:35am
	I used to use dataset as CR datasource and convert to PDF. It works fine. Now, I created a CR which datasource is a store procedure. How to convert it to PDF?
	IP Logged


Emir_W Senior Member Joined: 25 Apr 2010 Online Status: Offline Posts: 228	Posted: 12 Jul 2010 at 7:44pm
	it is same process. create new report using Stored Procedure (SP) and put any fields as you need. and convert it to PDF. done. if you using programming (.net, etc.) better attach the existing report into your project. and you can convert it to .rpt, .xls, .doc and .rtf. at least, it work for me. hope it help.
	Emir W
	IP Logged

aspfun Newbie Joined: 17 Jun 2010 Online Status: Offline Posts: 27	Posted: 14 Jul 2010 at 5:26am
	The question is how to change code below: From: crystalreport1.SetDataSource(myDataset) To: crystalreport1.SetDataSource(Store procedure)
	IP Logged

Emir_W Senior Member Joined: 25 Apr 2010 Online Status: Offline Posts: 228	Posted: 14 Jul 2010 at 9:47am
	ahaa.. this is the things that i'm not good enough. because i'm new also in programming. hope someone can help you further on this.
	Emir W
	IP Logged

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