Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to Display each day of the month
- Thread starter Sahubba
- Start date
Are you able to get tables / datasets added to the database? If you got a table of DATE set up, this could be linked to the activity using LEFT OUTER and you'd still get a slot when there was no activity. (But note that any selection on the second table must do an IsNull test first, otherwise you'll not get the dates with no records, null value for the second record.)
f you can't add a table, you'll be stuck with creating a 'Mock Crosstab'. Crosstabs are fine if you don't mind the absence of rows or columns with no data, but you said you wanted empty slots to show.
A 'Mock Crosstab' is something that looks like a Crosstab, but in fact you define each column yourself, normally as a running total. This would need to go in the report footer, because running totals count as the reports 'run' and they will not be complete until then. Crystal should have included an example along with the Crosstabs.
You can save a little time by doing a paste to a dummy report, changing the name and then pasting back. In Crystal 11.5, you can also duplicate formula fields using the Field Explorer.
It always helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.
![[yinyang]](/data/assets/smilies/yinyang.gif "[yinyang] [yinyang]")
Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP
f you can't add a table, you'll be stuck with creating a 'Mock Crosstab'. Crosstabs are fine if you don't mind the absence of rows or columns with no data, but you said you wanted empty slots to show.
A 'Mock Crosstab' is something that looks like a Crosstab, but in fact you define each column yourself, normally as a running total. This would need to go in the report footer, because running totals count as the reports 'run' and they will not be complete until then. Crystal should have included an example along with the Crosstabs.
You can save a little time by doing a paste to a dummy report, changing the name and then pasting back. In Crystal 11.5, you can also duplicate formula fields using the Field Explorer.
It always helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.
Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP - Thread starter
- #3
- Thread starter
- #5
Lb,
I can't use excel.
What I need to do is count how many days a prov is on a treatment team. Example
Mike Lamt
From 3/1/11 to 3/3/11
3/1/11 5
3/2/11 4
3/3/11 2
So if that prov was assigned to a patient on 2/28/11 to 3/2/11
then that patient would be counted for 2 days.
On top of that there will be some days that there will be 0.
I hope I explained it well.
Thanks
I can't use excel.
What I need to do is count how many days a prov is on a treatment team. Example
Mike Lamt
From 3/1/11 to 3/3/11
3/1/11 5
3/2/11 4
3/3/11 2
So if that prov was assigned to a patient on 2/28/11 to 3/2/11
then that patient would be counted for 2 days.
On top of that there will be some days that there will be 0.
I hope I explained it well.
Thanks
- Thread starter
- #7
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question