Report Problem's

  • Thread starter Thread starter luimms
  • Start date Start date
L

luimms

Hi everyone,

I'am still experiencing some dificulties with my report's.

I still need them to Look as a Calendar.

What i did was, i crated a Query that filter's the month's and Year's upon
incertion, meaning the user will manually incert the desiered Year and Month.
All working fine.

But now, i don't know how to use it to create a Calendar type Report.
I've Check the exemple in: http://www.access.hookom.net/Samples.htm., but iam
lost in the sort's and grouping's.

The thing is, i dont have a complex DB, it's actually very simple... i just
need the damned thing to look as a Calendar!

The only field's i have on the table are:
Week
Date
Hour
Appointment
Obs

And i just need to display, Hour and Appointment in the subReport with the
corresponding Date in the Main Report. And, again, the "look" of a Calendar.

Iam really stuck in this. Don't know how or were to start.

I need help.
 
The srptCalendar should be bound to your table with all your scheduled
appointments. The main report (rptCalendar) should be bound to a record
source with only one record/date per week.

Do you want all appointments for a week together or are there going to be
separate calendar pages for separate schedules?

What type of values are you storing in the Week field?
 
Well, its more simple, i think...

The "week" field is almoust just for show, since the boss incists in having
it. Besides that... useless...

The report's are suposed to be montly. Displaying a "Short" version, with
only "Hour" and Appointment" filed's. The "OBS" field is used to describe the
info of the appointment, and will be used only in the DB.

What i need is, day1...day31 of each month displayed in a calendar type
report.

And besides, if i get this to work, weekly report's should be more simple.
Then the "Week" field will come to use.

There aren't, soposedly, going to be many appointment's per day, what my boss
whant's is the Calendar type report's... (lady's... they are stuburn ;D)

The only thing iam really stuck on the damn report... i have really no idea
how can i desing a report like this.

TY again

Duane said:
The srptCalendar should be bound to your table with all your scheduled
appointments. The main report (rptCalendar) should be bound to a record
source with only one record/date per week.

Do you want all appointments for a week together or are there going to be
separate calendar pages for separate schedules?

What type of values are you storing in the Week field?
Hi everyone,
Click to expand...
[quoted text clipped - 26 lines]
I need help.
Click to expand...
Click to expand...
 
Did you modify the srptCalendar to display your appointment records?
If you have at least one appointment for each week, set the Record Source of
the main report to:

SELECT DateAdd("d",-Weekday([Date]),[Date])+1 AS WeekOf
FROM tblAppointments
GROUP BY DateAdd("d",-Weekday([Date]),[Date])+1;

Then set the Link Master property of the subreport control on the main
report to:
Link Master Fields... txtDay1
Link Child Fields......[Date]
Set the Sorting and Grouping to only
WeekOf Ascending
This should remove the Doctor header section.

--
Duane Hookom
Microsoft Access MVP


luimms via AccessMonster.com said:
Well, its more simple, i think...

The "week" field is almoust just for show, since the boss incists in having
it. Besides that... useless...

The report's are suposed to be montly. Displaying a "Short" version, with
only "Hour" and Appointment" filed's. The "OBS" field is used to describe the
info of the appointment, and will be used only in the DB.

What i need is, day1...day31 of each month displayed in a calendar type
report.

And besides, if i get this to work, weekly report's should be more simple.
Then the "Week" field will come to use.

There aren't, soposedly, going to be many appointment's per day, what my boss
whant's is the Calendar type report's... (lady's... they are stuburn ;D)

The only thing iam really stuck on the damn report... i have really no idea
how can i desing a report like this.

TY again

Duane said:
The srptCalendar should be bound to your table with all your scheduled
appointments. The main report (rptCalendar) should be bound to a record
source with only one record/date per week.

Do you want all appointments for a week together or are there going to be
separate calendar pages for separate schedules?

What type of values are you storing in the Week field?
Hi everyone,
Click to expand...
[quoted text clipped - 26 lines]
I need help.
Click to expand...
Click to expand...
Click to expand...
 
Thank You again for the help.

I'll spend the weekend working on this.

I'll get back with the outcome.

Thank You, and have a nice weekend

Duane said:
Did you modify the srptCalendar to display your appointment records?
If you have at least one appointment for each week, set the Record Source of
the main report to:

SELECT DateAdd("d",-Weekday([Date]),[Date])+1 AS WeekOf
FROM tblAppointments
GROUP BY DateAdd("d",-Weekday([Date]),[Date])+1;

Then set the Link Master property of the subreport control on the main
report to:
Link Master Fields... txtDay1
Link Child Fields......[Date]
Set the Sorting and Grouping to only
WeekOf Ascending
This should remove the Doctor header section.
Well, its more simple, i think...
Click to expand...
[quoted text clipped - 33 lines]
Click to expand...
 
Hi again,

Well, everything is working fine.

I just have one question...

Can i use the "Date" on the Table instead of "WeekOF"?
What do i need to change?

TY
Thank You again for the help.

I'll spend the weekend working on this.

I'll get back with the outcome.

Thank You, and have a nice weekend
Did you modify the srptCalendar to display your appointment records?
If you have at least one appointment for each week, set the Record Source of
Click to expand...
[quoted text clipped - 17 lines]
Click to expand...
 
Back
Top