Calendar Style Report

Any ideas on how I might be able to create a report with a page for each
month, columns for each day, rows for each week and scheduled activities on
the appropriate date?
I have a db with rows for each activity and columns for various types of
dates, i.e, start, review, submit, etc.
TIA
deanIt's actually quite a lot of work...
You need to drive the report from a dataset that has generated calendar data
in it, and join your real data to this table on the date values. Then of
course you can group on month and week in the standard way.
There are two tricky parts. The first is generating the calendar data --
have you ever done this before? Here is an example -- not sure if this is
exactly the same as the one that I use, but it looks similar.
http://blogs.x2line.com/al/archive/2004/04/10/229.aspx
The second is a *bit* tricky, but mostly it is tedious: setting up the
columns for all the days in any given week. The information for each column
has a different offset (starting with 0 and going to 6) from the first day
of week.
Basically, it's a lot of SQL.
>L<
"Dean" <Dean@.discussions.microsoft.com> wrote in message
news:938ADD6C-2509-40C5-8339-AED5B2EC9224@.microsoft.com...
> Any ideas on how I might be able to create a report with a page for each
> month, columns for each day, rows for each week and scheduled activities
> on
> the appropriate date?
> I have a db with rows for each activity and columns for various types of
> dates, i.e, start, review, submit, etc.
> TIA
> dean

calendar style report

Is there a way to generate a report that looks like a calendar. If i want to
view a schedule with people assigned to days of the month.I'm working on this problem now and here's what I have so far.
Create a query that has the various date parts as columns in the result set.
As an example:
Select datepart(yy,shipDate) as yearnum,
datepart(mm,shipDate) as monthnum,
datename(mm,shipDate) as monthname,
datepart(wk,shipDate) as weeknum,
datepart(dw,shipDate) as daynum,
datename(dw,shipDate) as dayname,
datepart(dd,shipDate) as datenum,
shipmentID
from shipments
Order by shipDate
Now step through the new report wizard.
Choose the Matrix report layout.
Choose yearnum and monthnum for the page fields
Choose daynum for the column fields
Choose weeknum for the row fields
Choose datenum as the detail fields
This will cause the report to page break on month and year, the columns wii
be by day of week (starting with Sunday), and the rows will be the weeks of
the year.
Once you are at the format tab of your report, change the appropriate number
values to the name values so the column and page headers will be
human-friendly. right click on the datenum detail field and add a row below.
drag-and-drop your shipmentID field into the new row.
A little creative application of borders an you have a pretty good calendar
report.
It works pretty well EXCEPT...
when there is more than one row per date, you will only get the first detail
value. Perhaps someone can shed some light on how to get multiple rows in a
single date box without ruining the format. At this point I'm thinking about
resorting to a stored proc as my query so I can cursor through and create a
single text colum that is a concatenation of all the detail data for that
date.

Calendar slow to load

Is anyone else experiencing performance problems with reports that use the calendar control for date parameters? Whenever we load a report that uses a calendar it takes several seconds to fully load the form (you can see something like this in the status bar:"...ReportViewerWebControl.axd?OpType=Calendar..."). This is not a serious problem, but if the user tries to use the control before it fully loads then the page throws javascript errors. I am wondering if this is a issue with the report itself or the server configuration, or if it is just something we have to live with.

The calendar control works by loading a years worth of dates to allow you to browse through the months more quickly. This is not a overly large amount of data and I have not seen it take a significant amount of time myself. The is, however, no way to change the behavior of this control. Things that might cause this behavior are a slow network connection or a slow server, however you would notice everything having longer load times then.

-Daniel

|||

I have a new RS2005 server in production and the speed at which the calendar control loads is also painfully slow.

On the initial rounds of testing it was so slow that my Business Analysts / QA person reported *bugs* with the calendar control refreshing the page or displaying blank and so forth.

Is there a way to limit how much date information it pulls down initially or to possibly build a custom control based on the out of the box control and then limit the date range loaded by default?

For my users at least the date range is going to be from minus 3 months to present for about 95% of the runs.

|||Just to add to this, I have the same problem, I thought it was a bug too but there doesnt seem to be a way of fixing this....at least none that I know of.|||

We have the same problem with calendar control. I have a filter with a date that should be greater than a value given by the user in the report. If I have a default value on the date the report loads very slow, in about 10 seconds. When I change the value in the report and click view report it still load slow.

On the other hand if I dont give a default value in the filter the report loads within 2 seconds. It also loads within seconds if I change the value in the report?

Any suggestions?

/Stefan

|||

I wonder if this isn't related to bugs in the control?

The two behaviors I notice are an incredible amount of sluggishness associated with having a default value and that each time you change the value it makes a server round-trip even though you haven't clicked on the View Report button.

|||

Can you file a bug on this issue along with your report definition that makes this happen? When you do so, please include infomration on the SQL Server Reporting Services version you're using and what browser and it's version you're using.

You can file the bug here: http://lab.msdn.microsoft.com/productfeedback/

When you have an expression based default value, we need to do a round trip to the server to determine the new value for the parameter. If the parameter depends on a previous parameter, whenever you change the upstream parameter we'll do a round trip. What I'd like to know is if the slowness persists if you were to substitute a string parameter for your datatime parameter. If it does, it is probably that the server is taking a long time to process your request - is it adequately resourced for the work load? Otherwise it might be specific to the data picker control.

Hope that helps,

-Lukasz

Calendar slow to load

Is anyone else experiencing performance problems with reports that use the calendar control for date parameters? Whenever we load a report that uses a calendar it takes several seconds to fully load the form (you can see something like this in the status bar:"...ReportViewerWebControl.axd?OpType=Calendar..."). This is not a serious problem, but if the user tries to use the control before it fully loads then the page throws javascript errors. I am wondering if this is a issue with the report itself or the server configuration, or if it is just something we have to live with.

The calendar control works by loading a years worth of dates to allow you to browse through the months more quickly. This is not a overly large amount of data and I have not seen it take a significant amount of time myself. The is, however, no way to change the behavior of this control. Things that might cause this behavior are a slow network connection or a slow server, however you would notice everything having longer load times then.

-Daniel

|||

I have a new RS2005 server in production and the speed at which the calendar control loads is also painfully slow.

On the initial rounds of testing it was so slow that my Business Analysts / QA person reported *bugs* with the calendar control refreshing the page or displaying blank and so forth.

Is there a way to limit how much date information it pulls down initially or to possibly build a custom control based on the out of the box control and then limit the date range loaded by default?

For my users at least the date range is going to be from minus 3 months to present for about 95% of the runs.

|||Just to add to this, I have the same problem, I thought it was a bug too but there doesnt seem to be a way of fixing this....at least none that I know of.|||

We have the same problem with calendar control. I have a filter with a date that should be greater than a value given by the user in the report. If I have a default value on the date the report loads very slow, in about 10 seconds. When I change the value in the report and click view report it still load slow.

On the other hand if I dont give a default value in the filter the report loads within 2 seconds. It also loads within seconds if I change the value in the report?

Any suggestions?

/Stefan

|||

I wonder if this isn't related to bugs in the control?

The two behaviors I notice are an incredible amount of sluggishness associated with having a default value and that each time you change the value it makes a server round-trip even though you haven't clicked on the View Report button.

|||

Can you file a bug on this issue along with your report definition that makes this happen? When you do so, please include infomration on the SQL Server Reporting Services version you're using and what browser and it's version you're using.

You can file the bug here: http://lab.msdn.microsoft.com/productfeedback/

When you have an expression based default value, we need to do a round trip to the server to determine the new value for the parameter. If the parameter depends on a previous parameter, whenever you change the upstream parameter we'll do a round trip. What I'd like to know is if the slowness persists if you were to substitute a string parameter for your datatime parameter. If it does, it is probably that the server is taking a long time to process your request - is it adequately resourced for the work load? Otherwise it might be specific to the data picker control.

Hope that helps,

-Lukasz

Calendar slow to load

Is anyone else experiencing performance problems with reports that use the calendar control for date parameters? Whenever we load a report that uses a calendar it takes several seconds to fully load the form (you can see something like this in the status bar:"...ReportViewerWebControl.axd?OpType=Calendar..."). This is not a serious problem, but if the user tries to use the control before it fully loads then the page throws javascript errors. I am wondering if this is a issue with the report itself or the server configuration, or if it is just something we have to live with.

The calendar control works by loading a years worth of dates to allow you to browse through the months more quickly. This is not a overly large amount of data and I have not seen it take a significant amount of time myself. The is, however, no way to change the behavior of this control. Things that might cause this behavior are a slow network connection or a slow server, however you would notice everything having longer load times then.

-Daniel

|||

I have a new RS2005 server in production and the speed at which the calendar control loads is also painfully slow.

On the initial rounds of testing it was so slow that my Business Analysts / QA person reported *bugs* with the calendar control refreshing the page or displaying blank and so forth.

Is there a way to limit how much date information it pulls down initially or to possibly build a custom control based on the out of the box control and then limit the date range loaded by default?

For my users at least the date range is going to be from minus 3 months to present for about 95% of the runs.

|||Just to add to this, I have the same problem, I thought it was a bug too but there doesnt seem to be a way of fixing this....at least none that I know of.|||

We have the same problem with calendar control. I have a filter with a date that should be greater than a value given by the user in the report. If I have a default value on the date the report loads very slow, in about 10 seconds. When I change the value in the report and click view report it still load slow.

On the other hand if I dont give a default value in the filter the report loads within 2 seconds. It also loads within seconds if I change the value in the report?

Any suggestions?

/Stefan

|||

I wonder if this isn't related to bugs in the control?

The two behaviors I notice are an incredible amount of sluggishness associated with having a default value and that each time you change the value it makes a server round-trip even though you haven't clicked on the View Report button.

|||

Can you file a bug on this issue along with your report definition that makes this happen? When you do so, please include infomration on the SQL Server Reporting Services version you're using and what browser and it's version you're using.

You can file the bug here: http://lab.msdn.microsoft.com/productfeedback/

When you have an expression based default value, we need to do a round trip to the server to determine the new value for the parameter. If the parameter depends on a previous parameter, whenever you change the upstream parameter we'll do a round trip. What I'd like to know is if the slowness persists if you were to substitute a string parameter for your datatime parameter. If it does, it is probably that the server is taking a long time to process your request - is it adequately resourced for the work load? Otherwise it might be specific to the data picker control.

Hope that helps,

-Lukasz

Calendar Reporting Control

I have a request to have a report created in a calendar layout. Does anyone
know of a charting component that can do this or an example that would help
me get started.
Thanks,
DavidHi David,
Welcome to MSDN Managed Newsgroup!
Unfortunately, I am afraid we do not have direct solution for this calendar
layout report in Microsoft. You may have to handle the layout yourself and
write custom code if required.
Let's wait to see whether other community members have such experience. You
may also search the google.com for related information.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Calendar Report Layout Help

Hello

I need to create something like the following table:

MON TUE WED THU FRI SAT SUN

01/01/07 02/01/07 03/01/07 04/01/07 05/01/07 06/01/07 07/01/07

Blank Field Blank Field Blank Field Blank Field Blank Field Blank Field Blank Field

08/01/07 09/01/07 10/01/07 11/01/07 12/01/07 13/01/07 14/01/07

Blank Field Blank Field Blank Field Blank Field Blank Field Blank Field Blank Field

The user would enter the start date, in this case the 1st Jan 07 and then this would populate a table. This seems like it should be so simple but I can't work it out, can anyone help please?

Cheers

I sorted it using a cross tab query.