topic Re: Printing tables to pdf along with map in ArcGIS API for Flex Questions

Printing tables to pdf along with map

IrisGreen — Fri, 04 Oct 2013 03:45:45 GMT

Hello Everyone,

I need to print tables generated using a query along with the Map in "pdf" format such that they are auto arranged in the white
space on the map.
I am looking for any suggestion using flex which can help me do this.

Thanks in Advance.

Iris

Re: Printing tables to pdf along with map

AaronNash1 — Fri, 04 Oct 2013 15:57:23 GMT

I was able to accomplish this using AlivePDF, it is an open source PDF printing API. You can take any of the columns of a datagrid and publish that into a PDF report. You can also take display features (like a map) and print them as images in the report. I attached two sample reports, one is a list out of a datagrid, the other is an inspection report and shows a map. When pulling data from a datagrid it honors the sort.

Re: Printing tables to pdf along with map

PaulHastings1 — Fri, 04 Oct 2013 16:17:16 GMT

we use coldfusion + iText for this server side. we build the attribute tables dynamically, measure their sizes once the tables are filled w/data, then merge them w/the PDF map document produced by the AGS print task, sticking what fits in the map's white space & dumping what doesn't onto supplemental pages. iText gives you an insane amount of control, coldfusion lets us glue this altogether more easily.

i suppose anything server side that can talk to java or c# an be used w/iText (it has java & c# versions).

we've tried purePDF (partial AS3 port of iText) & alivePDf client side but we found these too slow & lacking some functionality.

Re: Printing tables to pdf along with map

IrisGreen — Mon, 07 Oct 2013 03:52:15 GMT

Thank You Folks!! Will look into you suggestions.

Re: Printing tables to pdf along with map

PamTurner — Mon, 11 Nov 2013 19:27:22 GMT

I was able to accomplish this using AlivePDF, it is an open source PDF printing API. You can take any of the columns of a datagrid and publish that into a PDF report. You can also take display features (like a map) and print them as images in the report. I attached two sample reports, one is a list out of a datagrid, the other is an inspection report and shows a map. When pulling data from a datagrid it honors the sort.

Hi Aaron - I am trying to do something almost identical to what you shared with your Test.PDF document. I have implemented similar things on the .NET side, but trying to output this from the flex API is stumping me. Anyway you could share some code?

Thanks in advance.

Re: Printing tables to pdf along with map

AaronNash1 — Tue, 12 Nov 2013 11:14:13 GMT

attached is the code I used in my application. Any questions let me know

Re: Printing tables to pdf along with map

LefterisKoumis — Wed, 08 Jan 2014 02:22:12 GMT

Hello Paul. Would you mid sharing the source code in CF? Thanks.

we use coldfusion + iText for this server side. we build the attribute tables dynamically, measure their sizes once the tables are filled w/data, then merge them w/the PDF map document produced by the AGS print task, sticking what fits in the map's white space & dumping what doesn't onto supplemental pages. iText gives you an insane amount of control, coldfusion lets us glue this altogether more easily.

i suppose anything server side that can talk to java or c# an be used w/iText (it has java & c# versions).

we've tried purePDF (partial AS3 port of iText) & alivePDf client side but we found these too slow & lacking some functionality.

Re: Printing tables to pdf along with map

MGSethe — Thu, 23 Jan 2014 12:33:51 GMT

attached is the code I used in my application. Any questions let me know

Hi ,
Has anyone tried to include the Legend using this code?
I need to include the Legend on the map, but no luck .Please help.

Re: Printing tables to pdf along with map

PaulHastings1 — Fri, 24 Jan 2014 06:45:26 GMT

Hello Paul. Would you mid sharing the source code in CF? Thanks.

oops didn't see this until just now. sorry no, its the clients. but if you have specific questions i can probably whip up generic cf code.

Re: Printing tables to pdf along with map

AaronNash1 — Tue, 28 Jan 2014 12:10:32 GMT

Hi ,
Has anyone tried to include the Legend using this code?
I need to include the Legend on the map, but no luck .Please help.

I ran a quick test and it is possible using alivePDF, just add your legend as a component to the map and you can use the addimage property in alivePDf to add the legend as an image to the report.

Re: Printing tables to pdf along with map

MGSethe — Tue, 28 Jan 2014 17:25:07 GMT

I ran a quick test and it is possible using alivePDF, just add your legend as a component to the map and you can use the addimage property in alivePDf to add the legend as an image to the report.

Hello Aaron

Thanks for the quick reply, I tried it and I am not winning, could you please share the code you have if you do not mind?
I am referring to the code that have the Legend.

Thanking you in advance

Re: Printing tables to pdf along with map

AaronNash1 — Thu, 30 Jan 2014 18:18:49 GMT

attached is a text file of the project I was working on, its a simple PDF report. just shows that it can be done.

Re: Printing tables to pdf along with map

MGSethe — Wed, 12 Feb 2014 05:55:30 GMT

Thanks a million times. It did the trick

Re: Printing tables to pdf along with map

LefterisKoumis — Mon, 28 Apr 2014 18:19:01 GMT

oops didn't see this until just now. sorry no, its the clients. but if you have specific questions i can probably whip up generic cf code.

Thank you Paul. I am interested to see how you posted the legend. Any generic code to share, I'd appreciate it. Thanks.

Re: Printing tables to pdf along with map

PaulHastings1 — Tue, 29 Apr 2014 07:16:36 GMT

our suite of apps parses the layers in each map service the apps will use via rest calls (an admin app that sets which users/groups can use which map services/tools, etc). that includes the legends. that's all stored in a sql server table & this reporting tool simply pulls that data out of the table & adds it to the PDF.

the map template is from arcMap. i get a PDF of that blank template & measure out the available space for the legend, etc. using a PDF tool (foxit for example)--mainly because the designers either don't know or won't say the space available for each piece of the template. those become constants. the legend,etc. tables are built in server memory & measured against the available space.if they fit, they go in, if not they get added to a supplemental page (next iteration will measure rows & fit as many as possible instead of this binary approach).

if you can read coldfusion, i'll try to get a generic example together.

Re: Printing tables to pdf along with map

LefterisKoumis — Tue, 29 Apr 2014 14:21:17 GMT

our suite of apps parses the layers in each map service the apps will use via rest calls (an admin app that sets which users/groups can use which map services/tools, etc). that includes the legends. that's all stored in a sql server table & this reporting tool simply pulls that data out of the table & adds it to the PDF.

the map template is from arcMap. i get a PDF of that blank template & measure out the available space for the legend, etc. using a PDF tool (foxit for example)--mainly because the designers either don't know or won't say the space available for each piece of the template. those become constants. the legend,etc. tables are built in server memory & measured against the available space.if they fit, they go in, if not they get added to a supplemental page (next iteration will measure rows & fit as many as possible instead of this binary approach).

if you can read coldfusion, i'll try to get a generic example together.

Thank you for your reply, Paul. It it very interesting the approach you described and open up to me new possibilities. I have a license of CF 9, and I was using it for web apps but since then I turned my attention to ASP.NET. Based on your reply, it seems that you also have a license for the Foxit PDF SDK to implement in your solution. If you provide a generic example it will be very helpful. Thanks.

Re: Printing tables to pdf along with map

PaulHastings1 — Wed, 30 Apr 2014 08:56:08 GMT

no, as i said, we're using coldfusion & the iText version that comes w/it, server side. foxit that i used to measure the template bits is the free version. nothing special about it.

Re: Printing tables to pdf along with map

LefterisKoumis — Thu, 08 May 2014 00:08:59 GMT

attached is the code I used in my application. Any questions let me know

Aaron, thank you for posting the code for printing the display features in a pdf.

For the report.pdf, I assume that you used a spark datagrid. Could you please post the code for printing to pdf the datagrid as displayed in the report.pdf? Thanks.

Re: Printing tables to pdf along with map

AaronNash1 — Sat, 11 Dec 2021 13:52:23 GMT

here is some code for just printing a table

public function generatePDF2():void
{
     var myCoreFont1:IFont = new CoreFont ( FontFamily.ARIAL );
     
     myPDF = new PDF(Orientation.PORTRAIT, Unit.MM, Size.TABLOID);
     myPDF.setDisplayMode( Display.FULL_PAGE, Layout.SINGLE_PAGE );
     myPDF.addPage();
     myPDF.setFont(myCoreFont1, 12);
     myPDF.addText('List of Development Services Projects - Status', 11, 10);
     myPDF.setFont(myCoreFont1, 8);
     myPDF.addText('Printed:' + dateFormatter.format(now.toLocaleDateString()), 180, 10);
     var gridColumnOwner1:GridColumn = new GridColumn("Project Name", "Name", 90, Align.LEFT, Align.LEFT);  
     var gridColumnOwner2:GridColumn = new GridColumn("Condition", "Color", 18, Align.LEFT, Align.LEFT);
     var gridColumnAddress:GridColumn = new GridColumn("Status", "Status", 20, Align.LEFT, Align.LEFT);
     var gridColumnMailCity:GridColumn = new GridColumn("Next Step", "Cur_Status", 20, Align.LEFT, Align.LEFT);
     
     var gridColumnMailStat:GridColumn = new GridColumn("Department", "DS_Department", 35, Align.LEFT, Align.LEFT);
     var gridColumnManager:GridColumn = new GridColumn("Project Manager", "Manager", 35, Align.LEFT, Align.LEFT);
     var gridColumnCost:GridColumn = new GridColumn("Project Assistant", "Assistant", 35, Align.LEFT, Align.LEFT);
     
     
     myPDF.setFont(myCoreFont1, 8);
     myPDF.textStyle ( new RGBColor ( 0x000000 ), 1 );
                                        //resultsGrid is the name of the datagrid
     var grid:Grid = new Grid (resultsGrid.dataProvider.toArray(), 0, 0, new RGBColor (0xC0C0C0), 
      new RGBColor (0xCCCCCC), true , new RGBColor(0x000000), 1, Joint.ROUND);
     
     var columns:Array = new Array (gridColumnOwner1,gridColumnOwner2, gridColumnAddress, gridColumnMailCity, gridColumnMailStat, gridColumnManager, gridColumnCost);
     grid.columns = columns;
     myPDF.addGrid(grid, 1, 6);
     //export to pdf web service
     myPDF.save(Method.REMOTE, "name of server",Download.INLINE,"myPDF.pdf");
}

Re: Printing tables to pdf along with map

LefterisKoumis — Sat, 11 Dec 2021 13:52:25 GMT

here is some code for just printing a table

public function generatePDF2():void
{
     var myCoreFont1:IFont = new CoreFont ( FontFamily.ARIAL );
     
     myPDF = new PDF(Orientation.PORTRAIT, Unit.MM, Size.TABLOID);
     myPDF.setDisplayMode( Display.FULL_PAGE, Layout.SINGLE_PAGE );
     myPDF.addPage();
     myPDF.setFont(myCoreFont1, 12);
     myPDF.addText('List of Development Services Projects - Status', 11, 10);
     myPDF.setFont(myCoreFont1, 8);
     myPDF.addText('Printed:' + dateFormatter.format(now.toLocaleDateString()), 180, 10);
     var gridColumnOwner1:GridColumn = new GridColumn("Project Name", "Name", 90, Align.LEFT, Align.LEFT);  
     var gridColumnOwner2:GridColumn = new GridColumn("Condition", "Color", 18, Align.LEFT, Align.LEFT);
     var gridColumnAddress:GridColumn = new GridColumn("Status", "Status", 20, Align.LEFT, Align.LEFT);
     var gridColumnMailCity:GridColumn = new GridColumn("Next Step", "Cur_Status", 20, Align.LEFT, Align.LEFT);
     
     var gridColumnMailStat:GridColumn = new GridColumn("Department", "DS_Department", 35, Align.LEFT, Align.LEFT);
     var gridColumnManager:GridColumn = new GridColumn("Project Manager", "Manager", 35, Align.LEFT, Align.LEFT);
     var gridColumnCost:GridColumn = new GridColumn("Project Assistant", "Assistant", 35, Align.LEFT, Align.LEFT);
     
     
     myPDF.setFont(myCoreFont1, 8);
     myPDF.textStyle ( new RGBColor ( 0x000000 ), 1 );
                                        //resultsGrid is the name of the datagrid
     var grid:Grid = new Grid (resultsGrid.dataProvider.toArray(), 0, 0, new RGBColor (0xC0C0C0), 
      new RGBColor (0xCCCCCC), true , new RGBColor(0x000000), 1, Joint.ROUND);
     
     var columns:Array = new Array (gridColumnOwner1,gridColumnOwner2, gridColumnAddress, gridColumnMailCity, gridColumnMailStat, gridColumnManager, gridColumnCost);
     grid.columns = columns;
     myPDF.addGrid(grid, 1, 6);
     //export to pdf web service
     myPDF.save(Method.REMOTE, "name of server",Download.INLINE,"myPDF.pdf");
}

Thank you. I got a bit of work to do. The layers and the attributes are pre-selected by the user before the datagrids are printed out.