"Get" report name

[preston2]

Anyone know how to "Get" a reports name.

Since it seems to be impossible to change the text in the default report drop down toolbar [Send Report Drop-down] I have had to create a custom tool bar for each language my app will use.

I just put a button on the toolbar to email as a pdf. Simple enough for now.

The problem is using the following I need to change the first parameter to reflect the name of the report.

Report.Send("Invoice","PDF",query.filter,query.order,myemail_client,email_to,subject_param,message_param,cc_param,bcc_param)

This code sends the report named "Invoice" but I have several other reports that will need to be emailed and I do not want to make several custom toolbars for each report.

The only option I can think of right now is to set a variable to the report's name when they push a button to preview the report and then use that in the report.send code.

[johnkoh]

Re: "Get" report name

Preston,

tbllist ="customer" 'one or many dbf name
ReportNamelist = a5enum("report",alltrim(tblist))

check the previous discussion at " Xdialog and Print Preview "

[preston2]

Re: "Get" report name

Ok,

I looked at that and found that A5.REPORT_ENUM(2) gets a list of all the reports. Not what a really want.

Cannot find any documentation on a5enum and

tblist="wo_header.dbf"
repname = a5enum("report",alltrim(tblist))

Returns NUL

but

tblist="wo.set"
repname = a5enum("report",alltrim(tblist))

Returns a list of report names used with that set.

None of this is what I think I am looking for.

What I am trying to do is:

I have a report open in "Preview". When I click a button on the tool bar to run the script to email the report, I want to capture the report name, put it in a variable and then use the variable in the report.send.

When you use the default toolbar for emailing a report, Alpha some how knows the reports name when you click the email as pdf so there has to be away to get the report name when using a custom toolbar while viewing a report.

All that said, I will try firing this from a button on a tool bar when viewing a report and see if it just gives me the reports name.

Well, tried that and no-go, still get a list instead of the report name of the report that has focus.

[MoGrace]

Re: "Get" report name

Hi Preston,
Since most of the report methods seem to prefer shared or global vars, your calling script can get the name of the report, then all you need do is modify the preview toolbar with a button to send that report using your variable. It should pick up whatever report is displayed.

[G Gabriel]

Re: "Get" report name

What I am trying to do is:
I have a report open in "Preview". When I click a button on the tool bar to run the script to email the report, I want to capture the report name, put it in a variable and then use the variable in the report.send.

Here is a script to do that:

dim lst as c
dim rpt_lst as c=""
lst=a5_list_open_windows()
x=*count(lst)
for i=1 to x
	rpt_lst=rpt_lst+word(word(lst,i,crlf()),2,"Preview_")+crlf()
next
rpt_lst=remove_blank_lines(rpt_lst)
msgbox(rpt_lst)

This code will give the user a list of the names of all reports in Preview mode. The user could then click on their choice and place that in a the variable you want to use in your script.
Note:
If the name of the report has spaces in it, alpha will replace the space with under score. For instance, if the name of the report is: "Customer History", the name of the report in the preview mode will be:
"Preview_Customer_History"

[preston2]

Re: "Get" report name

Thanks Gabriel but again, not what I am looking to do.

I do not want the user to have to preform an additional step by picking from a list.

They are viewing a report. That report has focus. They go to save or email that report then there should be a way to get the name of the report into a variable without having to pick from a list. I say this because if you use the default tool bar, Alpha does not ask you to pick from a list of reports to preform those functions.

I think the easiest way to do this would be to just load the report name into a variable when they click a button on a form to preview it.

[Stan Mathews]

Re: "Get" report name

Not sure it would be easier but it appears you could create your own function to get the report name.
a5_list_open_windows() will tell you which report is being previewed

? a5_list_open_windows()
= ControlPanel
Preview__DC_Row_Bin
Code_Editor
__a5documentation_window

Process that list to capture the normalized report name after Preview__.

[preston2]

Re: "Get" report name

Ok, this works.

Fired from a button on the report preview tool bar.

dim repname as c
repname = topparent.name()
repname=ltrim(repname,"Preview__")

This puts the current open report name into the variable repname that I can then use in the rest of a script to either save or email the current report out in several languages.

Thanks again Stan, Gabriel and Robin.
While not like the example Stan posted, searching the docs and then cannibalizing part of a function example for a5_list_open_windows() I ended up with a simple solution that works.

[Stan Mathews]

Re: "Get" report name

Glad you found what you needed. I think that will work for any report with a normalized name. If you had a report named Fiscal year, for example, I don't think it would. Just a thought.

[preston2]

Re: "Get" report name

If you had a report named Fiscal year, for example, I don't think it would. Just a thought.

The code above would return "Fiscal_year" for a report named "Fiscal year". So it includes an underscore for the space between "Fiscal" and "year". But so does the code you posted above.

[Stan Mathews]

Re: "Get" report name

Which is why I suggested a user defined function to manipulate the returned value from a5_list_open_windows(). One could check for the all words in the report name or the first and last word, etc. Easier to avoid the issue by just using report names that don't change when normalized.

Again, glad you have it working as desired.

[G Gabriel]

Re: "Get" report name

I added that part so the user could confirm to send that specific report. Using your script, if the user shifts the focus to a different window before clicking to send the report, either he/she will email the wrong one or it wouldn't work. Also and as I mentioned earlier, alpha replaces the spaces with underscore. You could easily eliminate those.

[preston2]

Re: "Get" report name

Using your script, if the user shifts the focus to a different window before clicking to send the report, either he/she will email the wrong one or it wouldn't work. Also and as I mentioned earlier, alpha replaces the spaces with underscore. You could easily eliminate those.

If the user shifts focus to another window then the toolbar that has the button on it is no longer in play so they cannot send the report anyway. If by some chance they open preview on several reports, it will still only get the name of the report they have in focus which would/should be the report they wanted to save or send.

[G Gabriel]

Re: "Get" report name

That's what Hillary said.

[preston2]

Re: "Get" report name

Just tested it with several reports opened at the same time and it only picks up the name of the report that has focus. Works for me.