VISIO 2007 Calendar - Populate with data from SQL Server 2000

[vpdj]

PLEASE HELP - This is driving me crazy!!!

I am trying to get data from a SQL Table into a VISIO 2007 calendar.

The data is being pulled from a view:
alter VIEW [dbo].[LQ_CLIENT_FILE_DELIVERY_CALENDAR]
as
SELECT
CONVERT(varchar(10), DATEADD(dd, DJS.I_EXPECTED_FREQUENCY,
DJS.D_LOAD_FINISHED), 101) AS [Date to Display],
CONVERT(varchar(10), DATEADD(dd, DJS.I_EXPECTED_FREQUENCY,
DJS.D_LOAD_FINISHED), 101) AS [Start date],
CONVERT(varchar(10), DATEADD(dd, DJS.I_EXPECTED_FREQUENCY,
DJS.D_LOAD_FINISHED), 101) AS [End date],
LEFT(DJS.VC_NOTE, 50) AS [Subject]
FROM dbo.TBL_LOOKUP_DJS_FILE_NAME DJS

I created the Calendar in VISIO 2007:

 

[vpdj]

PLEASE HELP - This is driving me crazy!!!

I am trying to get data from a SQL Table into a VISIO 2007 calendar.

The data is being pulled from a view:
    alter VIEW [dbo].[LQ_CLIENT_FILE_DELIVERY_CALENDAR]
    as
    SELECT
        CONVERT(varchar(10), DATEADD(dd, DJS.I_EXPECTED_FREQUENCY,
DJS.D_LOAD_FINISHED), 101) AS [Date to Display],
        CONVERT(varchar(10), DATEADD(dd, DJS.I_EXPECTED_FREQUENCY,
DJS.D_LOAD_FINISHED), 101) AS [Start date],
        CONVERT(varchar(10), DATEADD(dd, DJS.I_EXPECTED_FREQUENCY,
DJS.D_LOAD_FINISHED), 101) AS [End date],
        LEFT(DJS.VC_NOTE, 50) AS [Subject]
    FROM dbo.TBL_LOOKUP_DJS_FILE_NAME DJS

I created the Calendar   in VISIO 2007:

(Sorry -- here is the rest of my message

File -> New -> Schedule -> Calendar

and drag/drop'd a monthly calendar

I then connected to the view (Link Data to Shapes wizard) - and
multiple rows per date appear on the lower half of the window.

Then I cannot get the Data onto the Calendar!!!

It seems so simple, but I just cannot figure it out - I have tried
everything I can think of (Automatically Linking), etc.

I am ready to just cut and paste the data, but would really like to
know the right way to do this.

I have multiple rows per date - and some dates have no rows.

PLEASE HELP!!

-- Paul J.

 

[vpdj]

Can this be done with the Database Wizard or one of the other VISIO
2007 wizards?

If so, then how?

-- Thanks,
-- Paul J.