HTML Reports for web applications - How?

[danh]

Re: HTML Reports for web applications - How?

It is a bug, but here is a simple work around that I got from Selwyn:

1. add code similar to this at the start of the page:

dim cs as c
cs = _A5_AlphaDAO_ConnectionStrings.get("mysql_alphasports_v11_2")

2. and change the 'source' line like this:

dim htmlReportDef as c
htmlReportDef = <<%html%
<!--A5Report::Report
source=SQL:__cs__
select=SELECT CUSTOMER_ID, FIRSTNAME, LASTNAME, BILL_CITY FROM customer-->
<style>
<!--

3. then add this code just before the rg.load() command:

htmlReportDef = stritran(htmlReportDef,"__cs__",cs)
rg.Load(htmlReportDef)

I tried it and it works.

[DaveF]

Re: HTML Reports for web applications - How?

That's strange. I wonder why it works for me. I use the following connection string:

source=SQL:::Name::SQL Server 2008

Maybe its because I am running in Live Preview and not in Published mode.

[danh]

Re: HTML Reports for web applications - How?

Don't know, but I was running into it in published mode.

Next question:
I'm opening this report (now in an a5w page) in a popup ajax window. Any ideas how to print the report from that popup window?

[DaveF]

Re: HTML Reports for web applications - How?

If you're using the Action Javascript routine to open the window, you can add custom buttons at the bottom of the window. I think you can use “window.print()” to print the contents of the window.

[danh]

Re: HTML Reports for web applications - How?

That works great, except that it prints the WHOLE page, not just the contents of the popup window. Tried "this.print();", but didn't do anything.

[DaveF]

Re: HTML Reports for web applications - How?

Sorry, but I think that's about as far as I had got too. I remember making progress by adding a "Print" button and getting it to print something, but I was still was not happy with the results. Let me know if you get any further.

[DaveF]

Re: HTML Reports for web applications - How?

This is the best solution I could find. The only thing I don’t like is that a temporary browser window displays. It closes automatically after you close the Print Dialog. Create a Print button and add the following code in the Button Definition:

var iFrame = document.getElementById('A5dlg0.BODY');
var iFrameBody;
if (iFrame.contentDocument)
{ // FireFox
iFrameBody = iFrame.contentDocument.getElementsByTagName('html')[0];
}
else if (iFrame.contentWindow)
{ // IE
iFrameBody = iFrame.contentWindow.document.getElementsByTagName('html')[0];
}

var wnd = window.open('', '', 'width=750,height=650,top=50,left=50,toolbars=no,scrollbars=yes,status=no,resizable=yes');
wnd .document.writeln(iFrameBody.innerHTML);
wnd .document.close();
wnd .focus();
wnd .print();
wnd .close();

Please let me know if you come up with something better.

Thanks

[danh]

Re: HTML Reports for web applications - How?

That's a nice step forward! I hadn't worked on it anymore - been busy with other things.

Is it possible to hide the window as part of the specs? Like: display:none

I'll see what else I can find and post it here.

Thanks for sharing that.

[DaveF]

Re: HTML Reports for web applications - How?

In my first attempt, I was able to print just the IFrame without a new browser window popping up, but it only printed the visible part and also printed the scroll bars and frame outline. I looked everywhere for an example of hiding the browser window and tried many different things, but could not figure out a way to make it hidden. There is nothing special about the browser window attributes I used in the window.open function above. I tried setting the window position and dimensions so it would display off the visible screen, but the print dialog appeared in the lower right hand corner. When I clicked the button to Print, I think FF re-displayed the new window back in the visible area for a second and then it disappeared when window.close was called.

[danh]

Re: HTML Reports for web applications - How?

Found a simple solution!

If you use action javascript to open the a5w page and define a window button to print the report, like we discussed previously, this code in the button will print the contents of the window:

var id = this.getWindowId('body');
$(id).contentWindow.print();

This works for me in firefox, haven't tried it in other browsers.

[DaveF]

Re: HTML Reports for web applications - How?

Thanks. This works much better with FF, Chrome and Safari, but IE and Opera are printing the entire page.

[danh]

Re: HTML Reports for web applications - How?

Had a javascript buddy look into this and here's what he found that works in ie:

var id = this.getWindowId('body');
if(jQuery.browser.msie) {
	$(id).contentWindow.document.execCommand('print',false,null);
} else {
	$(id).contentWindow.print();
}

Not sure about Opera...

[DaveF]

Re: HTML Reports for web applications - How?

Thanks. Works for all browsers except Opera. I tried the following to see what would happen:

if(jQuery.browser.msie || jQuery.browser.opera)

I didn't get any errors, but nothing printed out.