Crystal Reports pass query to crystal

Writing Code
Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Writing Code

Topic: pass query to crystal

Author	Message
amirsarb Newbie Joined: 24 Feb 2008 Location: Iran Online Status: Offline Posts: 1	Topic: pass query to crystal Posted: 24 Feb 2008 at 1:33pm
	hi all My application, written in VB.NET 2005 , uses reports designed in CR XI. I need to pass query from my application to crystal report and generate report. (in my program, user can select that which fields, need to report. so i need to pass my query and crystal report generate it dynamically) thanks
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3701	Posted: 26 Feb 2008 at 12:36pm
	The property that you need to look for/set is CommandText. This allows you to set the SQL query that the report runs. I suggest setting up a report template that already has a "dummy" command in it. You can then access that command by name to set the SQL rather than having to create a new one on the fly. -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

Neena Newbie Joined: 13 Feb 2008 Location: India Online Status: Offline Posts: 7	Posted: 28 Feb 2008 at 1:33am
	Hi Is it possible to desing CR in VS.net 2005 at runtime. Then pls help me also. I'm too stuck with the designing at runtime. Neena
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3701	Posted: 28 Feb 2008 at 5:57am
	Yes, but it's not easy. If you do a search here there are posts in the forums that explain how to do this. -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	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.