Current record printing problem

[reedallenbrown]

I need to find out how to print just the current record that is shown on my web app screen. I would like to have a button on the screen and when the user clicks on it the report will print filtered by the record that is on the screen. I have tried so many ways but I cannot figure out how to make it work.

Thank you for your time, you guys are so helpful !!

[willobeth]

Re: Current record printing problem

I put a tab pane at the bottom of my grid fields. Then I put in a calculated field, "Project_PDF_Report", that I had created as a calculated field in query.

That was added as a link field after the tab pane. I titled the Tab Pane "Add/Report/Delete" because I have all those functions running there.

The Link Properties for Project_PDF_Report field are "Static Text", text is "Run", Computed from fields in the Grid, address is "Print_Projects_PDF_ID.a5w?session.ID={Id} and it opens in a new window.

I created the a5w page with this code:

<%a5
'If eval_valid("vLeaseId") = .f.
' goto skipreport
'end if
Dim vFilter as C
Dim vOrder as C
Dim vFilename as C
vOrder=""
vFilter="Id="+s_quote(session.Id)
vFilename = session.session_folder + chr(92) + "Projects_PDF.pdf"
vFilename = report.saveas("Projects_PDF@[PathAlias.ADB_Path]\Projects.set","pdf",vFilter,vOrder,vFilename,.f.)
if file.exists(vFilename)
response.redirect(session.session_url + "Projects_PDF.pdf?" + time("hms3"))
else
?"Couldn't find the Projects_PDF printout."
end if
end

skipreport:
?"There was an error. Unable to print this Projects_PDF Report."
%>

Note the vFilter code above; vFilter="Id="+s_quote(session.Id)
and the Link address portion after the linked a5w page; ?session.Id={Id}

This is the link between the Grid record and the filtered report.

I know that the naming I have used could, and should be shorter, but, as a model, this works for me. Good luck.

[reedallenbrown]

Re: Current record printing problem

Great, thanks ! What is a tab pane and how do I add that to my grid?

[willobeth]

Re: Current record printing problem

When you are working on your Grid, below the list of "Available Fields" you will see "Insert Layout Command" in blue. These commands allow you to insert "dividers" and areas to distinguish different elements of your Grid when displayed. I use them, for instance, to separate my Contracts Grid into Details, Contractor (name, address, bond, license type and #, etc), Related Projects, Accounting and the like. The Insert Layout Command allows you to merge cells as well so you have the entire address in one box instead of in a box for street, another for city, another for state, etc.

You can name the tabs to key the user as to functions. That way they have a visual cue that they are moving from one area of functionality to another within the Grid.

You don't have to use the tabs. I do it simply to guide my users through a set of functions more efficiently.

[reedallenbrown]

Re: Current record printing problem

Well I got most of it to work, however I still do not know what to do in the report itself?