Printing PDF from Grid

[Rich Hartnett]

Steve I'm not having any luck. I figured I'd better leave well enough alone, so I started over with a new dialog and went back to the calendar for the date field. I made the changes you mentioned in the last post, but I'm still getting the same 404 error message. Once again, here is my updated code. I must be still putting something in the wrong place!

DIM Cfilter as c
cfilter = "date >={" + date + "} .and. update <= {" + date + "} .and. Idno = " + Idno
report.saveas("dailylog@<adb_path>\dailylogsheet.set","pdf",Cfilter,"",session.session_folder + "\foo.pdf",.f.)

response.redirect(session.session_url + "foo.pdf" + time("hms03"))

[Rich Hartnett]

Oh, here's the message I'm getting:

404 Not Found

The requested URL /session_folders/b4b2c2ca98294fe8ab39b85f75fe4e6d/foo.pdf192518829 was not found on this server.

[Rich Hartnett]

Whoops, I found one problem already. I forgot to change the second field you had named "update" to "date." I corrected that, but I'm still getting an error message. Here's the updated code:

DIM Cfilter as c
cfilter = "date >={" + date + "} .and. date <= {" + date + "} .and. Idno = " + Idno
report.saveas("dailylog@<adb_path>\dailylogsheet.set","pdf",Cfilter,"",session.session_folder + "\foo.pdf",.f.)

response.redirect(session.session_url + "foo.pdf" + time("hms03"))

[Steve Bovino]

Also, your error message seems to indicate that the pdf file is not being created. Have you created a pdf file as of yet? You can have Alpha create a pdf file by right clicking on the report name and saving as a pdf file. If that does not work we have to make sure everything is installed correcly.

Steve

[Rich Hartnett]

Also, your error message seems to indicate that the pdf file is not being created. Have you created a pdf file as of yet? You can have Alpha create a pdf file by right clicking on the report name and saving as a pdf file. If that does not work we have to make sure everything is installed correcly.

Steve

Steve I wasn't quite sure what you meant by "have I created a pdf file yet?"

I can print to pdf using the Adobe Acrobat Publisher software we have installed on the server, and just now I did the right click on the report and told it to save as "pdf." After a few seconds the Adobe program opened up and the pdf was created, but this was being done by the Adobe v5.0 that was installed two years ago on the server. Does the pdf report have to be created by Adobe software located within the A5 program? Also, was I supposed to save the pdf version of the form someplace?

(Sorry this is turning out to be so complicated.)

[Steve Bovino]

That's good Rich. It means Alpha is printing the pdf file. Are you still receiving an error message when you try to run the report?

Steve

[Lenny Forziati]

Your response.redirect has a minor problem, which causes the browser to try to load a non-existent file instead of the PDF you've just created.

change

response.redirect(session.session_url + "foo.pdf" + time("hms03"))

to

response.redirect(session.session_url + "foo.pdf[B]?[/B]" + time("hms03"))

[Rich Hartnett]

Lenny I'm still getting the same error message, even after changing that last line of code.

404 Not Found
The requested URL /session_folders/e6c3618e8dd94374965494eb58543f21/foo.pdf was not found on this server.


Here's my code as it is stands now:

DIM Cfilter as c 
cfilter = "date >={" + date + "} .and. date <= {" + date + "} .and. Idno = " + Idno 
report.saveas("dailylog@<adb_path>\dailylogsheet.adb","pdf",Cfilter,"",session.session_folder + "\foo.pdf",.f.) 
 
response.redirect(session.session_url + "foo.pdf?" + time("hms03"))  

[Rich Hartnett]

[QUOTE=Rich Hartnett]Lenny I'm still getting the same error message, even after changing that last line of code.

404 Not Found
The requested URL /session_folders/e6c3618e8dd94374965494eb58543f21/foo.pdf was not found on this server.


Here's my code as it is stands now:

DIM Cfilter as c
cfilter = "date >={" + date + "} .and. date <= {" + date + "} .and. Idno = " + Idno
report.saveas("dailylog@<adb_path>\dailylogsheet.adb","pdf",Cfilter,"",session.session_folder + "\foo.pdf",.f.)

response.redirect(session.session_url + "foo.pdf?" + time("hms03"))

[Steve Bovino]

Rich:

I note in your code that you reference an adb file in the report.saveas command. I believe it should be either a .dbf or.set file. It should reference the table or set that the report is built on.

report.saveas("dailylog@<adb_path>\[B]dailylogsheet.adb[/B]","pdf",Cfilter,"",session.session_folder + "\foo.pdf",.f.)

Steve

[Rich Hartnett]

Yes I see that Steve. I think that happened when I was experimenting around trying different things to find out why I can't get this thing to work, and forgot to change it back to ".set"

Anyway, I've corrected it, but I'm still getting the same error message. Here's the latest screen shot of my code:

DIM Cfilter as c
cfilter = "date >={" + date + "} .and. date <= {" + date + "} .and. Idno = " + Idno
report.saveas("dailylog@<adb_path>\dailylogsheet.set","pdf",Cfilter,"",session.session_folder + "\foo.pdf",.f.)

response.redirect(session.session_url + "foo.pdf?" + time("hms03"))

Also, remember that in the original code you gave me, this section was listed as:

>={" + start_date + "} .and. date <= {" + end_date + "}

but I kept getting a message on the screen saying that "end_date" was not found, so I changed them both to "+ date +" Could this be one of the problems? What it the correct syntax for these two variables?

[Steve Bovino]

RicH:

Try this.

cfilter= "date= {" + date + "} .and. Idno = " + idno


Steve

[Rich Hartnett]

Nope, same thing. I can't win. I must have something wrong in the code somewhere.....

404 Not Found
The requested URL /session_folders/e6c3618e8dd94374965494eb58543f21/foo.pdf was not found on this server. 


--------------------------------------------------------------------------------

Alpha Five/7.0 Build/3906-3009 at SERVER Port 80

DIM Cfilter as c
cfilter= "date= {" + date + "} .and. Idno = " + idno
report.saveas("dailylog@<adb_path>\dailylogsheet.set","pdf",Cfilter,"",session.session_folder + "\foo.pdf",.f.)

response.redirect(session.session_url + "foo.pdf?" + time("hms03"))

[Lenny Forziati]

Try a simplified version to try to narrow down the problem:

dim pdf_file as c
pdf_file = report.saveas("dailylog@<adb_path>\dailylogsheet.set","pdf","","",session.session_folder + "\foo.pdf",.f.)
if file.exists(pdf_file)
    ? "The PDF was created. <a href=\"" + session.session_url + "foo.pdf?" + time("hms03") + "\">click here to view it</a>."
else
    ? "The PDF file was not created."
end if

If the above works, try adding in your filter.

If the above does not work, confirm that PDF generation in general works on this system.

Nope, same thing. I can't win. I must have something wrong in the code somewhere.....

[Rich Hartnett]

[QUOTE=Lenny Forziati]Try a simplified version to try to narrow down the problem:

dim pdf_file as c
pdf_file = report.saveas("dailylog@<adb_path>\dailylogsheet.set","pdf","","",session.session_folder + "\foo.pdf",.f.)
if file.exists(pdf_file)
    ? "The PDF was created. <a href=\"" + session.session_url + "foo.pdf?" + time("hms03") + "\">click here to view it</a>."
else
    ? "The PDF file was not created."
end if

Lenny I tried that, and when I hit the submit button, the scale at the bottom of the screen went about half way over and then stopped. (Which was different from what I have been getting.) But I never got the pdf form. Keep in mind that this particular set has over 20,000 records in it, so asking for a report without filters would probably mean the report was trying to return a pdf with thousands of records, would it not? Anyway I think it timed out. Then later when I tried it again, I got this response:

Errors in: event.Form Level Validate code:
File 'P:\BHPDa5w\session_folders\b4b2c2ca98294fe8ab39b85f75fe4e6d\\foo.pdf' is in use. Cannot overwrite.

This is driving my crazy. What in the world am I doing wrong?