If anyone can help me with this, I would be really grateful. I am using
Reporting Services 2005 and Visual Studio 2005 for this problem.
A while back, I had a formatting problem with my reports that was fixed by
use of the Language property on the report. Although this fixed all
formatting within the report. However, there is still a problem with the
calendar controls that collect DateTime report parameters.
To check that this was not some kind of obscure problem with my particular
report, I put together a very simple example from the AdventureWorks
database.
The dataset was provided by the text query of:
SELECT Title, BirthDate
FROM HumanResources.Employee
WHERE (BirthDate BETWEEN @.StartDate AND @.EndDate)
The @.StartDate and @.EndDate parameters were set to type DateTime with
default value of null. I put a two column table on the report, displaying
Title and BirthDate. The Language of the report is set to English(United
Kingdom). The international setting under options in Visual Studio is set
to 'Same as Microsoft Windows'. My windows setting is English - United
Kingdom.
Once the parameters have been entered on the default calendar controls,
their values are converted to US date format (MM/dd/yyyy). Where the UK
date format will not convert, the following error displays:
"An error occurred during local report processing. The report parameter
'StartDate' is not valid for its type."
If anyone has any ideas of how to fix this, then I would be really grateful.
Virtually every report I run has the start and end date parameters, so
unless I fix this, the default method of collecting these parameters is
effectively useless to me.
Thanks in advance,
Ed AllisonInterestingly, this problem does not seem to occur when reports are deployed
to the report server.
Ed Allison
"Ed Allison" <ed@.optix.co.uk> wrote in message
news:O8B4xJlLGHA.3012@.TK2MSFTNGP14.phx.gbl...
> If anyone can help me with this, I would be really grateful. I am using
> Reporting Services 2005 and Visual Studio 2005 for this problem.
> A while back, I had a formatting problem with my reports that was fixed by
> use of the Language property on the report. Although this fixed all
> formatting within the report. However, there is still a problem with the
> calendar controls that collect DateTime report parameters.
> To check that this was not some kind of obscure problem with my particular
> report, I put together a very simple example from the AdventureWorks
> database.
> The dataset was provided by the text query of:
> SELECT Title, BirthDate
> FROM HumanResources.Employee
> WHERE (BirthDate BETWEEN @.StartDate AND @.EndDate)
> The @.StartDate and @.EndDate parameters were set to type DateTime with
> default value of null. I put a two column table on the report, displaying
> Title and BirthDate. The Language of the report is set to English(United
> Kingdom). The international setting under options in Visual Studio is set
> to 'Same as Microsoft Windows'. My windows setting is English - United
> Kingdom.
> Once the parameters have been entered on the default calendar controls,
> their values are converted to US date format (MM/dd/yyyy). Where the UK
> date format will not convert, the following error displays:
> "An error occurred during local report processing. The report parameter
> 'StartDate' is not valid for its type."
> If anyone has any ideas of how to fix this, then I would be really
> grateful. Virtually every report I run has the start and end date
> parameters, so unless I fix this, the default method of collecting these
> parameters is effectively useless to me.
> Thanks in advance,
> Ed Allison
>|||I have this question as well
"Ed Allison" wrote:
> Interestingly, this problem does not seem to occur when reports are deployed
> to the report server.
> Ed Allison
> "Ed Allison" <ed@.optix.co.uk> wrote in message
> news:O8B4xJlLGHA.3012@.TK2MSFTNGP14.phx.gbl...
> > If anyone can help me with this, I would be really grateful. I am using
> > Reporting Services 2005 and Visual Studio 2005 for this problem.
> >
> > A while back, I had a formatting problem with my reports that was fixed by
> > use of the Language property on the report. Although this fixed all
> > formatting within the report. However, there is still a problem with the
> > calendar controls that collect DateTime report parameters.
> >
> > To check that this was not some kind of obscure problem with my particular
> > report, I put together a very simple example from the AdventureWorks
> > database.
> >
> > The dataset was provided by the text query of:
> >
> > SELECT Title, BirthDate
> > FROM HumanResources.Employee
> > WHERE (BirthDate BETWEEN @.StartDate AND @.EndDate)
> >
> > The @.StartDate and @.EndDate parameters were set to type DateTime with
> > default value of null. I put a two column table on the report, displaying
> > Title and BirthDate. The Language of the report is set to English(United
> > Kingdom). The international setting under options in Visual Studio is set
> > to 'Same as Microsoft Windows'. My windows setting is English - United
> > Kingdom.
> >
> > Once the parameters have been entered on the default calendar controls,
> > their values are converted to US date format (MM/dd/yyyy). Where the UK
> > date format will not convert, the following error displays:
> >
> > "An error occurred during local report processing. The report parameter
> > 'StartDate' is not valid for its type."
> >
> > If anyone has any ideas of how to fix this, then I would be really
> > grateful. Virtually every report I run has the start and end date
> > parameters, so unless I fix this, the default method of collecting these
> > parameters is effectively useless to me.
> >
> > Thanks in advance,
> >
> > Ed Allison
> >
>
>|||I have found no solution to this, I am afraid. Since the problem does not
occur when reports are deployed, I just work around it when developing
reports.
Ed Allison
"Tango" <Tango@.discussions.microsoft.com> wrote in message
news:628FB199-1E9A-4723-8748-0C649E3683EA@.microsoft.com...
>I have this question as well
> "Ed Allison" wrote:
>> Interestingly, this problem does not seem to occur when reports are
>> deployed
>> to the report server.
>> Ed Allison
>> "Ed Allison" <ed@.optix.co.uk> wrote in message
>> news:O8B4xJlLGHA.3012@.TK2MSFTNGP14.phx.gbl...
>> > If anyone can help me with this, I would be really grateful. I am
>> > using
>> > Reporting Services 2005 and Visual Studio 2005 for this problem.
>> >
>> > A while back, I had a formatting problem with my reports that was fixed
>> > by
>> > use of the Language property on the report. Although this fixed all
>> > formatting within the report. However, there is still a problem with
>> > the
>> > calendar controls that collect DateTime report parameters.
>> >
>> > To check that this was not some kind of obscure problem with my
>> > particular
>> > report, I put together a very simple example from the AdventureWorks
>> > database.
>> >
>> > The dataset was provided by the text query of:
>> >
>> > SELECT Title, BirthDate
>> > FROM HumanResources.Employee
>> > WHERE (BirthDate BETWEEN @.StartDate AND @.EndDate)
>> >
>> > The @.StartDate and @.EndDate parameters were set to type DateTime with
>> > default value of null. I put a two column table on the report,
>> > displaying
>> > Title and BirthDate. The Language of the report is set to
>> > English(United
>> > Kingdom). The international setting under options in Visual Studio is
>> > set
>> > to 'Same as Microsoft Windows'. My windows setting is English - United
>> > Kingdom.
>> >
>> > Once the parameters have been entered on the default calendar controls,
>> > their values are converted to US date format (MM/dd/yyyy). Where the
>> > UK
>> > date format will not convert, the following error displays:
>> >
>> > "An error occurred during local report processing. The report
>> > parameter
>> > 'StartDate' is not valid for its type."
>> >
>> > If anyone has any ideas of how to fix this, then I would be really
>> > grateful. Virtually every report I run has the start and end date
>> > parameters, so unless I fix this, the default method of collecting
>> > these
>> > parameters is effectively useless to me.
>> >
>> > Thanks in advance,
>> >
>> > Ed Allison
>> >
>>|||Hi Ed,
I have the same problem and strangely - setting language property on
the report to "default" with international setting under options in
Visual Studio set to "English" sorted out the problem.
If for you this is not acceptable - the way arround (at least it works
for me) is not to press "View report" button - but the small green
refresh button on the toolbar on the preview report tab...
Hope this helps
Ivan
Showing posts with label calendar. Show all posts
Showing posts with label calendar. Show all posts
Wednesday, March 28, 2012
Saturday, February 25, 2012
Report in Calendar/schedule layout
Is it possible to produce a report which is displayed as a calendar, similar to outlook?
im using rs2000 with no option of an upgrade to 2005
any help would be appreciated!
Unless you don′t use any pre-page which sends the parameters to the reportsserver for rendering the report with the specified paramters, there is no way. You can′t change the parameter collection in SQL Server 2000.HTH, Jens Suessmeyer.
http://www.sqlserver2005.de|||
What about for SQL 2005? I need to display a report that is grouped by date in calendar format with totals appearing in the date boxes. I'm guessing I can figure out a way to do this in a Matrix, but it will be very cumbersome and prone to error I'm guessing.
If anyone knows, it is appreciated.
|||Never mind. I didn't realize how relatively easy it would be to make a calendar report using the Matrix control in RS2005. I'm up and running.|||I am trying to do something similar, but am having a problem.
Time is down the left hand side (the rows), and a room is each column. The problem is when rooms have overlapping times.
For example, room A is scheduled 1:00 - 2:00, and room B is 1:30 - 2:30. How do you avoid a line going through room A at 1:30?
Thanks,
Bob
|||You could try using a 3rd part component such as Dundas Calendar for Reporting Services.|||I would recommend using the smallest increment of time as your separator. In the case above 30 minutes. In this way, you have the flexibility to have different rooms per half-hour, but you can also have the same room show at 1:00 and 1:30 to cover the 1 - 2 slot.
In this last case, to remove the line between 1:00-1:30 and 1:30-2:00 I am guessing you could use an expression on the BorderStyle for the Top. I haven't looked in detail at this, but I would think you could evaluate if the previous half-hour was occupied for this room and turn off the boundry. I don't know how easy this would be to accomplish, but it is worth looking at.
Hope that helps.
|||Thanks for the replies.
The "smallest increment" methodology of csi_hugh is actually what I was trying. Using an expression for the borderstyles (top,bottom)does work to make the consecutive cells in the column look like one. The problem I have is that the increments are actually only 5 minutes, and the text for a classroom event can be rather long. The text has to either fit in one actual cell, or be split up programmatically amongst consecutive cells.
Thanks for the ideas, Bob
|||I think you can work around the text split issue with a rectangle in your table cell.|||
Does anyone having an example of one of these reports they have worked out?I tried doing this in a matrix but I am having a lot of trouble.The column grouping is room number and then I have rows for each time interval.I can access only one record per room which means I can only fill in one time interval.Any suggestions?
gisinnovations@.gmail.com
Report in Calendar/schedule layout
Is it possible to produce a report which is displayed as a calendar, similar to outlook?
im using rs2000 with no option of an upgrade to 2005
any help would be appreciated!
Unless you don′t use any pre-page which sends the parameters to the reportsserver for rendering the report with the specified paramters, there is no way. You can′t change the parameter collection in SQL Server 2000.HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||
What about for SQL 2005? I need to display a report that is grouped by date in calendar format with totals appearing in the date boxes. I'm guessing I can figure out a way to do this in a Matrix, but it will be very cumbersome and prone to error I'm guessing.
If anyone knows, it is appreciated.
|||Never mind. I didn't realize how relatively easy it would be to make a calendar report using the Matrix control in RS2005. I'm up and running.|||I am trying to do something similar, but am having a problem.
Time is down the left hand side (the rows), and a room is each column. The problem is when rooms have overlapping times.
For example, room A is scheduled 1:00 - 2:00, and room B is 1:30 - 2:30. How do you avoid a line going through room A at 1:30?
Thanks,
Bob
|||You could try using a 3rd part component such as Dundas Calendar for Reporting Services.|||I would recommend using the smallest increment of time as your separator. In the case above 30 minutes. In this way, you have the flexibility to have different rooms per half-hour, but you can also have the same room show at 1:00 and 1:30 to cover the 1 - 2 slot.
In this last case, to remove the line between 1:00-1:30 and 1:30-2:00 I am guessing you could use an expression on the BorderStyle for the Top. I haven't looked in detail at this, but I would think you could evaluate if the previous half-hour was occupied for this room and turn off the boundry. I don't know how easy this would be to accomplish, but it is worth looking at.
Hope that helps.
|||Thanks for the replies.
The "smallest increment" methodology of csi_hugh is actually what I was trying. Using an expression for the borderstyles (top,bottom)does work to make the consecutive cells in the column look like one. The problem I have is that the increments are actually only 5 minutes, and the text for a classroom event can be rather long. The text has to either fit in one actual cell, or be split up programmatically amongst consecutive cells.
Thanks for the ideas, Bob
|||I think you can work around the text split issue with a rectangle in your table cell.|||Does anyone having an example of one of these reports they have worked out?I tried doing this in a matrix but I am having a lot of trouble.The column grouping is room number and then I have rows for each time interval.I can access only one record per room which means I can only fill in one time interval.Any suggestions?
gisinnovations@.gmail.com
Report in Calendar/schedule layout
Is it possible to produce a report which is displayed as a calendar, similar to outlook?
im using rs2000 with no option of an upgrade to 2005
any help would be appreciated!
Unless you don′t use any pre-page which sends the parameters to the reportsserver for rendering the report with the specified paramters, there is no way. You can′t change the parameter collection in SQL Server 2000.HTH, Jens Suessmeyer.
http://www.sqlserver2005.de|||
What about for SQL 2005? I need to display a report that is grouped by date in calendar format with totals appearing in the date boxes. I'm guessing I can figure out a way to do this in a Matrix, but it will be very cumbersome and prone to error I'm guessing.
If anyone knows, it is appreciated.
|||Never mind. I didn't realize how relatively easy it would be to make a calendar report using the Matrix control in RS2005. I'm up and running.|||I am trying to do something similar, but am having a problem.
Time is down the left hand side (the rows), and a room is each column. The problem is when rooms have overlapping times.
For example, room A is scheduled 1:00 - 2:00, and room B is 1:30 - 2:30. How do you avoid a line going through room A at 1:30?
Thanks,
Bob
|||You could try using a 3rd part component such as Dundas Calendar for Reporting Services.|||I would recommend using the smallest increment of time as your separator. In the case above 30 minutes. In this way, you have the flexibility to have different rooms per half-hour, but you can also have the same room show at 1:00 and 1:30 to cover the 1 - 2 slot.
In this last case, to remove the line between 1:00-1:30 and 1:30-2:00 I am guessing you could use an expression on the BorderStyle for the Top. I haven't looked in detail at this, but I would think you could evaluate if the previous half-hour was occupied for this room and turn off the boundry. I don't know how easy this would be to accomplish, but it is worth looking at.
Hope that helps.
|||Thanks for the replies.
The "smallest increment" methodology of csi_hugh is actually what I was trying. Using an expression for the borderstyles (top,bottom)does work to make the consecutive cells in the column look like one. The problem I have is that the increments are actually only 5 minutes, and the text for a classroom event can be rather long. The text has to either fit in one actual cell, or be split up programmatically amongst consecutive cells.
Thanks for the ideas, Bob
|||I think you can work around the text split issue with a rectangle in your table cell.|||
Does anyone having an example of one of these reports they have worked out?I tried doing this in a matrix but I am having a lot of trouble.The column grouping is room number and then I have rows for each time interval.I can access only one record per room which means I can only fill in one time interval.Any suggestions?
gisinnovations@.gmail.com
Report in Calendar/schedule layout
Is it possible to produce a report which is displayed as a calendar, similar to outlook?
im using rs2000 with no option of an upgrade to 2005
any help would be appreciated!
Unless you don′t use any pre-page which sends the parameters to the reportsserver for rendering the report with the specified paramters, there is no way. You can′t change the parameter collection in SQL Server 2000.HTH, Jens Suessmeyer.
http://www.sqlserver2005.de|||
What about for SQL 2005? I need to display a report that is grouped by date in calendar format with totals appearing in the date boxes. I'm guessing I can figure out a way to do this in a Matrix, but it will be very cumbersome and prone to error I'm guessing.
If anyone knows, it is appreciated.
|||Never mind. I didn't realize how relatively easy it would be to make a calendar report using the Matrix control in RS2005. I'm up and running.|||I am trying to do something similar, but am having a problem.
Time is down the left hand side (the rows), and a room is each column. The problem is when rooms have overlapping times.
For example, room A is scheduled 1:00 - 2:00, and room B is 1:30 - 2:30. How do you avoid a line going through room A at 1:30?
Thanks,
Bob
|||You could try using a 3rd part component such as Dundas Calendar for Reporting Services.|||I would recommend using the smallest increment of time as your separator. In the case above 30 minutes. In this way, you have the flexibility to have different rooms per half-hour, but you can also have the same room show at 1:00 and 1:30 to cover the 1 - 2 slot.
In this last case, to remove the line between 1:00-1:30 and 1:30-2:00 I am guessing you could use an expression on the BorderStyle for the Top. I haven't looked in detail at this, but I would think you could evaluate if the previous half-hour was occupied for this room and turn off the boundry. I don't know how easy this would be to accomplish, but it is worth looking at.
Hope that helps.
|||Thanks for the replies.
The "smallest increment" methodology of csi_hugh is actually what I was trying. Using an expression for the borderstyles (top,bottom)does work to make the consecutive cells in the column look like one. The problem I have is that the increments are actually only 5 minutes, and the text for a classroom event can be rather long. The text has to either fit in one actual cell, or be split up programmatically amongst consecutive cells.
Thanks for the ideas, Bob
|||I think you can work around the text split issue with a rectangle in your table cell.|||
Does anyone having an example of one of these reports they have worked out?I tried doing this in a matrix but I am having a lot of trouble.The column grouping is room number and then I have rows for each time interval.I can access only one record per room which means I can only fill in one time interval.Any suggestions?
gisinnovations@.gmail.com
Subscribe to:
Posts (Atom)