Request Page Calendar Control

[AdamMWD]

Has anyone tried to add a graphical Calendar Control to a Request Page to generate a date range? (Actuate 7 Build 70C030426)

I know they can be added to normal HTML/ASP/etc pages.

Thanks for any assistance.

--- Adam

 

[milton747]

I'm guessing you mean having 2 date parameters (begin and end range) , which display the little calendar and you click the date.
I wrote a quick report and it worked OK. Here's what I did.


1) Identify the SQL date column which you want the range test to be applied to.
2) Add and ad hoc parameter to that date column.
3) In Tools->Paramters set that parameter to Hidden.
We will set the range from the 2 date parameters.

4) In Tools->Paramters create 2 date parameters of type Date.
Eg: Date_Begin and Date_End.

When the program runs, the user will pick the dates from the calendar that
appears.

5) In the Datasource::ObtainSelectstatement method, we will access the 2 date
parameters, add the required syntax around them, them move the new string to
the hidden ad hoc param.
Here's my code:


Function ObtainSelectStatement( ) As String

' Insert your code here

showFactorystatus("BeginDate = " & Date_Begin)
showFactorystatus("EndDate = " & Date_End)

Dim s As String

' Create the required search string
' Note there is a hyphen in the middle. Thus # - #
'
s = "#" & Date_Begin & "#-#" & Date_End & "#"

' Move the string to the parameter
orders_askByDate = s

ObtainSelectStatement = Super::ObtainSelectStatement( )

' Show the SQL
showFactoryStatus("ObtainSelectStatement = " & ObtainSelectStatement)


End Function


NOTE: You would need to add code to ensure the user does not enter a
backward range. Not that it matters, simply no rows would get returned.


Hope this helps
Milton

 

[AdamMWD]

Milton:

Thanks for the reply

That takes care of using the date parameters, but it doesn't appear to generate the GUI Calendar Control itself, which is what I was really asking about.

--- Adam

 

[milton747]

I was using 8sp1. Maybe Rel 7sp0 did not support that little graphical calendar when you run the report on the server.

 

[AdamMWD]

There may be a difference in that respect between the two versions. I did, however, find out that we should be able to have that GUI control on the Request Page (we're implementing from within MRO Maximo). Still working on it

 

[riad12]

Hi,
If you have access MRO support site (

http://support.mro.com)you

can search for the document M04432.
Title: Creating custom request page report to access a datelookup in Actuate

Hope this helps.

Riad.