From what I know about Sharepoint 2010, a calendar is simply a Sharepoint List displayed in a calendar form.
Based on this, I am trying to build a Sharepoint Foundation 2010 calendar that is populated (dynamically) from a SQL query that I have done using SQL Business Intelligence Development Studio.
The query uses two variables (beginning date and ending date) that produces a two column report that contains dates and event names between the two dates. I want to use this query result to populate the Sharepoint 2010 calendar and embed it in a Web page. I would like for someone to be able to run the query to show events for the current month.
OTHER INFO: Sharepoint Foundation 2010 is installed on Server A and SQL is installed on Server B. Both are all installed and working. My intent is to use the SQL server as a Report Server for Sharepoint. I just learned that I have to install Sharepoint Foundation on both A and B in order for A to use B as a report server.
Can this be done? If so, does anyone have any guidance on how to do this?