Report Selection

[James Peterson]

Using Action Scripting I have put a button on the Main Menu form that is supposed to bring up a list of the reports so one may be selected to print or preview. However, when the button is activated the Select Layout dialogue box appears, but none of the reports are shown although the layout type is designated as "report".

If this is covered in any of the books I would appreciate being so directed. I am missing something.

[Al Buchholz]

RE: Report Selection

James

Have you looked at the AlphaSports form CustQueryReport?

I think it is doing what you are describing. If not, then please post the table/set that you are working with and we'll try to figure out what is not working as expected.

alb

[James Peterson]

RE: Report Selection

Thanks for the reply. Alphasports is not doing just what I had in mind. The reports designed for the tables all work as they should if printed/previewed from an individual button on the Main Menu form or on a Report Menu form. What I had in mind was to use Action Scripting so a list of the available reports would appear in a list and then execute the chosen report. Part of the Action Scripting is to "Prompt at runtime" rather than the name of the individual report. This is where it breaksdown. The procedure refers to the Main Menu table which does not have any reports designed for it, so the list is blank. I find no way to change the referenced table or set.

I may be misreading the choice "prompt at runtime" that is shown in the Script Genie, Preview a Layout.

[Al Buchholz]

RE: Report Selection

James

The screen that I was refering to is attached here.

Please note the Select Layout Type and Select Layout to Print fields as the ones that are doing what I think you are looking for.
The advantage of this is that you can specify multiple tables to choose reports from in the Select Layout to Print field.

I also put an image of the action scripting genie with the current table or other table pull down showing. Are you getting this choice?

This is from build 1397-1028.

Hope that makes sense and helps with your design.

[Al Buchholz]

RE: Report Selection

And here's the attachment.

[James Peterson]

RE: Report Selection

We are on the same page now. I uploaded the latest patch, 1031 and still do not get anything but "current table or set" for the runtime option. I will try reinstalling the patch.

[davej]

RE: Report Selection

James,

Would this work for you? For one of my clients, I have the following 'Reports' menu written by Selwyn, which displays on OnFlyover.

[b]
'Date Created: 08-Sep-2002 05:29:46 PM
'Last Updated: 18-Nov-2002 08:51:18 PM
'Created By :
'Updated By :

this.align = "Left"
this.font.color = "Dark Green"
this.font.name = "Comic Sans MS"
this.font.size = 12
this.font.bold = .T.
this.border.has_left_edge = .T.
this.border.has_bottom_edge = .T.
this.fill.style = "Transparent"
topparent:RTF4.object.visible = .T.
menu =

[davej]

RE: Report Selection

That's is what happens if you forget the break tag at the end of the line after checking HTML. Sorry

James, Would this work for you? For one of my clients, I have the following 'Reports' menu written by Selwyn, which displays on OnFlyover.
[b]
'Date Created: 08-Sep-2002 05:29:46 PM
'Last Updated: 18-Nov-2002 08:51:18 PM
'Created By : Dave Jampole
'Updated By :

this.align = "Left"
this.font.color = "Dark Green"
this.font.name = "Comic Sans MS"
this.font.size = 12
this.font.bold = .T.
this.border.has_left_edge = .T.
this.border.has_bottom_edge = .T.
this.fill.style = "Transparent"
topparent:RTF4.object.visible = .T.
menu =
Report One
Report Two
Report Three
Report Four
Report Five
Report Six
Report Seven
Report Eight
Report Nine
Report Ten
%a%

result=ui_popup_menu(menu)
if result="Report One" then
script_play("scpReportOnr")
else if result="Report Two" then
script_play("scpReportTwo")
else if result="Report Three" then
script_play("scpReportThree")
else if result="Report Four" then
script_play("scpReportFour")
else if result="Report Five" then
script_play("scpReportFive")
else if result="Report Six" then
script_play("scpReportSix")
else if result="Report Seven" then
script_play("scpReportSeven")
else if result="Report Eight" then
script_play("scpReportEight")
else if result="Report Nine" then
script_play("scpReportNine")
else if result="Report Ten" then
script_play("scpReportTen")
end if

Dave

[James Peterson]

RE: Report Selection

Dave, thank you for the suggestion. I am not sure what your script does. I am not a programmer and wss relying on Action Scripting to get the job done. It appears my present build of A5V5 (1031) does not give me the options that I need to select the tables/sets that the reports would be based upon.

[davej]

RE: Report Selection

James,

The script goes in the OnFlyover event for the Reports button.

First of all, create a script the run each report (what I've called scpReportOne, scpReportTwo, etc. Then select the script in the previous message. Go into design mode for the form on which the Report button is located. Select the Report button (you'll see the small selection handles around the button). Right click your mouse, select Events and then OnFlyover and the Code Editor dialog box opens. Paste the script in the box. Between

[James Peterson]

RE: Report Selection

Al, I contacted Alpha support and after much ado they had me change my Windows ME appearance to "Windows Standard". And would you believe that solved the problem.

I want to thank you and Dave for the assistance. Dave's code will be very useful in the future as it shows all the reports, not just those written for a particular table or set.