Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Subreport Preview Post Reply Post New Topic
<< Prev Page  of 4 Next >>
Author Message
Dr4ke
Senior Member
Senior Member


Joined: 09 May 2014
Online Status: Offline
Posts: 209
Quote Dr4ke Replybullet Posted: 20 Apr 2015 at 6:10am
Thank you :-) I'll have a play around with this and let you know!
IP IP Logged
Dr4ke
Senior Member
Senior Member


Joined: 09 May 2014
Online Status: Offline
Posts: 209
Quote Dr4ke Replybullet Posted: 21 Apr 2015 at 12:20am
Hey!

I have this working but unfortunately it only shows one 'Sunday' box for the month. Is it possible to have one box/count per 'Sunday'? I.e., for April, it would show 4 Sundays; 5, 12, 19, 26 and ideally it would show those numbers in the box also...

Thanks in advance :)
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 21 Apr 2015 at 1:54am
so you are doing a full month calendar?
I assume you are allwoing a user to choose the month or it is dynamic in some fashion?
Is the number shown a total for a specific day of the month?
When a user clicks on the calendar are they drilling into that calendar day?
 
Can you write a stored proc as your data source?
IP IP Logged
Dr4ke
Senior Member
Senior Member


Joined: 09 May 2014
Online Status: Offline
Posts: 209
Quote Dr4ke Replybullet Posted: 21 Apr 2015 at 1:59am
Yes that's right, sorry I obviously didn't explain that properly!

It is dynamic in the sense that it is 'the current month' showing a Month-To-Date figure.

Yes it's a total for a specific day in the month.

That is the plan; they click on one of the 'days' and they see all the entries for that day.

I've never figured stored proc's out to be honest...?
IP IP Logged
Dr4ke
Senior Member
Senior Member


Joined: 09 May 2014
Online Status: Offline
Posts: 209
Quote Dr4ke Replybullet Posted: 21 Apr 2015 at 2:11am
Sorry I've just done some research and Stored Proc's are not what I thought they were (I was thinking of SQL Expressions).

I've never looked at Stored Proc's.... Help :-)
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 21 Apr 2015 at 2:15am
thinking about this
i think the real issue is that your looking at a full month of data and the first of each month may be any weekday. Therefore your sums, which would be based on day of the month need to slide between boxes and then roll up from there.
Correct?
IP IP Logged
Dr4ke
Senior Member
Senior Member


Joined: 09 May 2014
Online Status: Offline
Posts: 209
Quote Dr4ke Replybullet Posted: 21 Apr 2015 at 2:17am
Yes, if I've understood correctly, that is right
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 21 Apr 2015 at 3:05am
I think this might work
you will need to group by the week of the year so add a formula field to get that value
//weekofyear
datepart("ww",table.datefield)
group on this formula field
move your week day boxes into the group header
change your summary displays to use the group condition in the sum
each of your seven sub reports will need to alter the link to pass the group value (of the week of the year, the date range and the weekday)
get your month calendar set first and alter your months to make sure this is dynamically doing what you need it to for any of the months.
 
IP IP Logged
Dr4ke
Senior Member
Senior Member


Joined: 09 May 2014
Online Status: Offline
Posts: 209
Quote Dr4ke Replybullet Posted: 21 Apr 2015 at 5:00am
I'll give this a go :-) thank you!
IP IP Logged
Dr4ke
Senior Member
Senior Member


Joined: 09 May 2014
Online Status: Offline
Posts: 209
Quote Dr4ke Replybullet Posted: 21 Apr 2015 at 6:08am
Any chance you could help me out a little with the subreport links? So I have created one box with a Subreport (Sunday) and grouped on the Weeknumber... I have four boxes (result!).

I now know I need to parse something into the Subreport so that it only displays what the group number is.... I've got myself a little muddled and can't quite figure it out.
IP IP Logged
<< Prev Page  of 4 Next >>
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.