Xdialog Variable not Showing in Drag Drop List

[Rudy16]

Re: Xdialog Variable not Showing in Drag Drop List

Hi Mike,

If my questions are not clear, it's because I'm confused. The v_mth GLOBAL variable can be from "01" through "12" and I need a script or something that states
if v_mth="01"
v_mth_desc="January"
else
if v_mth="02"
v_mth_desc="February" on so forth and so on, up to month 12.

In my Report, I drag the GLOBAL variable v_mth onto it. It contains any month from "01" through "12". Where do I create the script to interrogate the variable and based on it's contents, move in the correct Month Decsription based on the above code. Also where do I create the GLOBAL variable v_mth_desc? v_mth_desc should be placed on the report also and reflect the value of January, February, etc. based on the value of v_mth.

Thanks,
Rudy

[Stan Mathews]

Re: Xdialog Variable not Showing in Drag Drop List

You can use Alpha functions to derive the month name, no code needed.

cmonth(ctod(v_mth+"/01/1950"))

Just create a calculated field for the report.

[Rudy16]

Re: Xdialog Variable not Showing in Drag Drop List

Hi Stan,

How's everything going today? Good I hope. The user can actually run a December 2009 report in january of 2010. Is your function using the current date system field? If so, it's not what I'm looking for.

Rudy

[Stan Mathews]

Re: Xdialog Variable not Showing in Drag Drop List

Is your function using the current date system field?

Do you see any reference to the system date field?

I think Mike was suggesting something similar.

Take a month "number" in the form 01 to 12.
Make a character "date" with it like 01/01/1918, the day of the month and the year are not important so long as the result is valid (not 01/49/1918 for example).

Use the ctod function to translate the character "date" into a date value.

Use the cmonth function to return the name of the month in the date value.

The cmonth function will return "January" for dates 01/01 to 01/31 of any and every year.

Perhaps it will help to see the steps illustrated in the interactive editor.

v_mth = "01" 'we start with something like this

v_chardate = v_mth+"/01/1918" 'we get a character "date" like this
? v_chardate
= "01/01/1918"


v_date = ctod(v_chardate) 'we translate to a date value like this
? v_date
= {01/01/1918}

? cmonth(v_date) ' we get the month name like this
= "January"

? cmonth(ctod(v_mth+"/01/1918")) 'collapse all those steps into one expression
= "January"

[Peter.Greulich]

Re: Xdialog Variable not Showing in Drag Drop List

Rudy,

1) how does the user select the year for the report?
2) does the table include a relevant date field?

[Rudy16]

Re: Xdialog Variable not Showing in Drag Drop List

The user selects the year from an xdialog window prior to entering the report("On Push" Event. He selects the year from a list. The year is stored in a global variable called v_curr_yr.

The user also selects the month for an xdialog window also, same ("On Push" event used above for the year. This is also selected from a list. The month is stored in a global variable calles v_mth.

The detail table that's used for the report has a process date attached to each detail record.

[Keith Hubert]

Re: Xdialog Variable not Showing in Drag Drop List

Hi Rudy,

Do you have the Year and Month selection in the same dialog? If not, is there a special reason?

Do you have the selections from drop downs?

[Mike Wilson]

Re: Xdialog Variable not Showing in Drag Drop List

Rudy,
Attached is an example of what I envision you are trying to accomplish. See if this helps.