cfinclude, cflocation, frames...how should I do this?

[married2themachine]

I need advice on the best way to accomplish something simple [i think]...

I have a report that displays as a default when I go to a page. What i want is to put choices at the top of that page that allow users to select a different report if they don't want the default. I would also like this to occur using radio buttons and perhaps a 'onchange' event?

Example choices:

Current Week-to-date, Saturday, Sunday, Monday, Tuesday, etc.

Underneath the choices above, I want the report displayed. When user makes a different choice, I want their chosen report to display in place of the default. The reports are actually the same file but with a passed variable in the WHERE statement of the query so the choice made above, needs to be passed as a variable so it can be substituted in the report query.

Thank you so much for any direction you can provide.

 

[LyndonOHRC]

Do you want it to submit when the radio button is clicked? or with a submit button?

It is pretty simple if you use a submit button. If your query Look to see if the form element exists otherwise let your query run in the default manner.

<cfquery...
select fld1,fld2...
from ...
Where TransActionDate >= figure your starting date
<cfif isdefined("form.MyRadioButton")>
<cfif form.MyRadioButton neq 'WeekToDate'>
And DayOfWeek(TransActionDate) = #Val(form.MyRadioButton)#
</cfif>
</cfquery>



Lyndon

---People Remember about 10% of what you say ---They never forget how you made them feel. Covey

 

[married2themachine]

Thanks Lyndon...I'll give it a shot.