Crystal Reports Subreport Preview

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

Topic: Subreport Preview
	<< Prev Page of 4

Author	Message
Dr4ke Senior Member Joined: 09 May 2014 Online Status: Offline Posts: 209	Posted: 22 Apr 2015 at 4:53am
	Unfortunately not - I do keep asking about adding one... No such luck so far.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 22 Apr 2015 at 5:52am
	I have to think about this one for a bit. Do you always have at least one value/row for the entire week? If not that whole 'row' (or group) would not exist.
	IP Logged

Dr4ke Senior Member Joined: 09 May 2014 Online Status: Offline Posts: 209	Posted: 22 Apr 2015 at 5:54am
	Again it's not a dead cert that there will be an entry for the entire week - we have had instances where it doesn't.... Another reason I was going to factor in an Excel sheet and 'outer join' it onto the date table/column.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 23 Apr 2015 at 4:10am
	this wiorks if you have data for each day-not sure how to fill in the missing days without a calendar table. I do not think that Excel will support an outer join as a datasource for (XI) Make 7 formula //MDforSunday if datepart("w",table.datefield)=1 then totext(datepart("d",table.field),0) //MDforMonday if datepart("w",table.datefield)=2 then totext(datepart("d",table.field),0) repeat for all 7 days make group summary for each one as the max value and palce in the correct weekday box at the group header level
	IP Logged

Dr4ke Senior Member Joined: 09 May 2014 Online Status: Offline Posts: 209	Posted: 24 Apr 2015 at 12:13am
	Thank you :-) I will give this a go.
	IP Logged

Dr4ke Senior Member Joined: 09 May 2014 Online Status: Offline Posts: 209	Posted: 05 May 2015 at 12:27am
	Hi DBlank, sorry for the delay I was pulled onto a different project. I am still going to look at this and obviously appreciate the help so far!
	IP Logged

<< Prev Page of 4

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.