Calendar Style Report 4

[Cydamac]

Has anyone ever created a report that has th elook and feel of a calendar? I am a report designer for a company that develops meeting planning/room reservation software. I have had many requests from external cleints for a report that looks like a calendar. Does anyone know of any way to do this in Crystal 8.5?

Thanks,

cydamac

 

[TaylorTot]

Boy you must be tired of this, but may I get a copy as well?

mnsebastian@comcast.net

Thank you in advance

 

[Zedleppelin]

Could you send me a copy too. This is a real time saver

Thanks a million

zedleppelin13@hotmail.com

 

[lbass]

Just sent it.

-LB

 

[Mike Lewis]

Lbass,

A lot of folk have asked you for a copy of your report, and you have been generous in supplying it.

If it would save you time, I would be happy to make the report available on my web site so that people can download it at any time. I could also include a short note explaining what the report is and how to use (with full credit to yourself, of course).

It's just a thought. It could save you having to mail individual copies, and would make it easier for people to receive. Let me know what you thing.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[rosemaryl]

Dear LB,

I have created a calendar style report too and would love to see yours if you wouldn't mind emailing it. Mine is based on a sql server db and was kind of an excercise in futility for what I wanted to do, but it does display a current month calendar and at the top left and right sides previous month and next month. I would be happy to share it with you though.

If you wouldn't mind emailing yours, I would appreciate it.

Thanks,

ro


Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[LaurieHamlin]

LB
Could you e-mail me a copy of this. I have 8.5 and designed my own, but it didn't quite work so I tried yours and I'm having the same problem with it.
I appreciate you saving me from banging my head on the wall.
Laurie

 

[LaurieHamlin]

Oops! That's to lhamlin@monroecounty.gov
Thanks.

 

[kskid]

LBass,

I would also appreciate a copy.

Thanks in advance.

lwilson@wichita.gov

 

[lbass]

You can download the sample report directly from:

http://www.ml-crystal.com/articles/calendar.htm

Please let me know if you need further help.

-LB

 

[hsandwick]

Dear lbass:

Crystal Reports 9
Sql server 7
Excel 2000 9

The calendar report is really GR8! Thank you. I'm able to run it locally, but when I try to run it where the rest of my reports are residing, called from within a software application, I receive the error message: Logon failed. DAO error code oxbd4. The workgroup information file is missing or opened exclusively by another user.

Does the excel subreport, created separately to hold the date info, have to reside on the same server as the SQL server 7 db that houses the rest of the data?

Has anyone experienced a similar issue?

Would really appreciate your feedback.

Thanks,

Helen

 

[lbass]

I'm sorry, but I don't know the answer to your question. I hope someone else will jump in. Otherwise, you could start a new thread with your question and reference this one.

-LB

 

[Mike Lewis]

Helen,

Does the excel subreport, created separately to hold the date info, have to reside on the same server as the SQL server 7 db that houses the rest of the data?

I don't think so. In fact, it doesn't have to be an Excel file. You could try setting it up as a text file to see if that gets round the problem.

Alternatively, you have sufficient rights, you could set it up as a normal SQL Server table.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)

 

[hsandwick]

Thank you, Mike and lbass:

I will try the txt file and then the sql server table and will let you know!

Greatly appreciated,

Helen

 

[BlurredVision]

I thought I would add a little something to this topic. I love the report, but I didn't want to use a table to store my dates because it uses space and some kind of generation mechanism is needed. The following SQL user function creates the table/dates on the fly. Once the function is created, use a stored procedure to call the function, you can then call the stored procedure from within your Crystal Report. With this, there is no need to maintain a spreadsheet or table for your dates.

Both the Funcation and Procedure are listed below

Brian
Chicago, IL

******* USER FUNCATION *******

Create function RPT_CALENDAR
(@p_year smallint)
returns @tbl table (cal_date smalldatetime)
as
begin
-- 2 --
declare @p_start_date smalldatetime
set @p_start_date = convert(smalldatetime, convert(varchar(4), @p_year) + '0101')

-- 3 --
insert into @tbl
select cal_date
from
(
select
@p_start_date +
n3.num * 100 +
n2.num * 10 +
n1.num as cal_date
from
(
select 0 as num union all
select 1 union all
select 2 union all
select 3 union all
select 4 union all
select 5 union all
select 6 union all
select 7 union all
select 8 union all
select 9
) n1,
(
select 0 as num union all
select 1 union all
select 2 union all
select 3 union all
select 4 union all
select 5 union all
select 6 union all
select 7 union all
select 8 union all
select 9
) n2,
(
select 0 as num union all
select 1 union all
select 2 union all
select 3
) n3
) gencalendar
order by 1
return
end

****** STORED PROCEDURE ******

/*
** This procedure returns dates for calendar reporting
*/
create procedure dbo.rpt_calendar_view
as
DECLARE @current_year INT
SET @current_year = DATEPART(year, GETDATE())
SELECT RPT_CALENDAR.*
FROM dbo.RPT_CALENDAR(@current_year) RPT_CALENDAR
GO