Workflow Soluiton

We are buidling somthing like a shopping cart process that is writing selected items to a temporarray sql table. After the customer is done we wanted to generate a PDF that lists all the options they added to the cart. I can get the data out of sql easy enough. The problem is the only way I know to make a PDF in Workflow is by generating a word document with the word merge. But you cannot add the array to the word document only single entries so it can either list the first or last item from the sql results has anyone accomplished this? If this was crystal reports it would be easy but word just isnt as powerful.

I make pdfs in workflow by first writting my data to a text file in HTML format. Then, I use the "execute process and wait" component to run the free WKHTMLtoPDF executable. This reads in the html file and writes out a pdf. Use the "read file" component to get the pdf back into workflow and you can then email it, display it on a form, whatever.

Thanks Michael i will try that, I have had a little bit of success using the Merge HTML and then HTML to PDF but that requires a lot of HTML coding on the source to make it nice. What sort of formating can you do with this? Crystal was just so much easier to use.

You definitely have to do the messaging of the HTML (using a merge component) yourself just like if you are using the Symantec provided HTML to PDF conversion. I like using WKHTMLToPDF instead because the PDF more closely matches the input html.

Will take a look thanks.