dynamic button text on report

[gkeramidas]

I created a report with a button on it. I dynamically change the text on each button to match an id number for the record. when the button is clicked, it's supposed to bring up a form with the correct record.
the number prints correctly on the preview, but when I hover over the button, the id number changes to the last id number on the page. so, when any button is clicked, it always brings up the same record.

anyone know why the button text changes when I hover the mouse and click the button?

[Stan Mathews]

Re: dynamic button text on report

To preview the report all records that fit the report filter are fetched in turn. I've never tried what you suggest but I imagine when you hover you're seeing something display the current record number/id, which is the last record.

I was able to duplicate your issue with the exception of the form being opened here opens to the correct record. I used a simple action script to open a form with the filter current recrod only. Appears to me that the button text changing on hover is a byproduct of the dynamic property "firing". Why the button text reverts to the proper value when not being hovered is a mystery to me.

[gkeramidas]

Re: dynamic button text on report

thanks, stan. I just ended up placing the field on the form and using the on push event to load the form with the correct data. I could use a separate button and make it work, done that plenty of times. I was just trying to use 1 less field because it barely fits on a sheet now.

I found if I disabled the flyover event, the button text would stay but it would still bring up the incorrect record.

[Ray in Capetown]

Re: dynamic button text on report

I'm intrigued, "onPush" action on a field?
I see there is an event OnPush for a field. i have never looked. So I tried a msg_box() on the OnPush event.
As I expected ... . nothing
How do you do it Gary?

[Al Buchholz]

Re: dynamic button text on report

I'm intrigued, "onPush" action on a field?
I see there is an event OnPush for a field. i have never looked. So I tried a msg_box() on the OnPush event.
As I expected ... . nothing
How do you do it Gary?

Did you preview the report and then click on the field?

Works for me.

[gkeramidas]

Re: dynamic button text on report

ray:
as al stated, did you preview the report and then click on the field?
one application I use it for, is a client has to verify that the ingredients used in products they purchase haven't changed. so the person can take a tablet, preview the open po report and click a button next to that particular item. that loads a label they have scanned and stored on the server and they can easily compare the 2 labels.
if they don't match, they can't received it. or they can, but then my client needs to change the ingredient statement on the product they're producing.

[MoGrace]

Re: dynamic button text on report

Not having seen your report...if the id field appears in the report, you can change the appearance of it to look like a button and put your script in the onpush event that reads the field value.

button.jpg

I just added a button in the section then copied the appearance to the field and deleted the button. Then I tweaked the flyover events to change the color and bold the text.

This is my script to open a detail view of the record:

dim gorec as c
gorec = this.value
choice = ui_get_list("Edit "+gorec,1,"Act Menu Detail","ActMenuX")
select
    case choice = ""
    	'user cancelled
    	end 
    case else
    	'put your own script or udf here
    	Go_frm(choice,"sortkey",gorec)        
end select

[gkeramidas]

Re: dynamic button text on report

that's what I did, I made it look like a button and it works fine

[MoGrace]

Re: dynamic button text on report

I'm always a day late!

[Ray in Capetown]

Re: dynamic button text on report

Did you preview the report and then click on the field?

Works for me.

Getting back a bit late.
I must admit I missed the point. Misled by picking up on

<Gary>thanks, stan. I just ended up placing the field on the form and using the on push event to load the form with the correct data.

in isolation and checked it on a form. This functionality is new to me, and does provide interesting possibilities. Thanks.

[MoGrace]

Re: dynamic button text on report

Hi Ray,
Check out the drilldown reports in AlphaSports.

[Ray in Capetown]

Re: dynamic button text on report

I will Robin thanks for the pointer.