Crystal Reports Incude Groups where data is null

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions

Topic: Incude Groups where data is null
	<< Prev Page of 2

Author	Message
Dr4ke Senior Member Joined: 09 May 2014 Online Status: Offline Posts: 209	Posted: 01 Oct 2014 at 11:50pm
	I suppose you could get this to work, with multiple 'groups', by using multiple subreports with the groups limited to 2 per subreport.... is there a better way!?
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	Posted: 03 Oct 2014 at 5:16am
	how about a simple command that just returns something that is in all the records...something easily queried and group 1 and group 2 values. Then use this as the 'master' table to link to the rest of the values (outer joins...so nulls are allowed). Lastly, do a test for if the value is null...and display or suppress your message appropriately. Personally, I would like a view/stored proc, but that not being available, this seems like the next best idea. I am assuming that you are joining straight to the tables in the database, so the command doesn't need any parameters... On the flip side, if it is only 8 tables, the sql can't be that difficult to create the entire query... just some thoughts.
	IP Logged

Dr4ke Senior Member Joined: 09 May 2014 Online Status: Offline Posts: 209	Posted: 03 Oct 2014 at 5:56am
	Thanks Lockwelle, things to ponder :-)
	IP Logged

<< Prev Page of 2

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.