×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Request Page Calendar Control

Request Page Calendar Control

Request Page Calendar Control

(OP)
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

RE: Request Page Calendar Control

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

RE: Request Page Calendar Control

(OP)
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

RE: Request Page Calendar Control

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

RE: Request Page Calendar Control

(OP)
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  :)

RE: Request Page Calendar Control

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close