2. PHPRunner General questions
  3. [SOLVED]  Custom View similar to Invoice
This topic is locked
[SOLVED]

 Custom View similar to Invoice

 		3/12/2014 11:26:00 AM
PHPRunner General questions
A
 Anapolis author

I am going to start over here with my question.
Is there a way with PHPRunner 7.1 to create a CUSTOM Export Page?
That is, what is the possibility to use the Visual Editor and Styles editor to Modify the Look and layout of the EXPORT page?
I have records that I want to Select for Export but PHPRunner gives me no control over the Look and Layout as it would if this were an ADD page.
I am using a mySQL query that creates temporary Column values on the List page that are calculated just for the List and View pages. But I want to re-arrange the values and have Custom labels for them and fixed locations for the PDF or Word doc that is generated from the Export Selected Records function.
For instance I want to select records and create an EXPORT PDF that follows this general format --


IF I had a VISUAL template then I could grab Values and assign them physical places.
And IF I had the Visual Template for an EXPORT page then I could also create dynamic Summing of various columns so that the SubTotals and Totals adjusted for whatever records I selected.
Is there a way to put a Template into the Export function so that I could see the layout ahead of Time in the Visual Editor?
Thanks very much!
A
 		Anapolis author 3/13/2014

As a followup to my question .. I have tried to get a layout this simple with Reports but it is not easily possible.
Reports has only 4 possible Table based layouts. Editing the resulting layout in HTML is a heap of work that still doesn't achieve the simpler result of my example.
Reports dictates that the Grouped fields always start on the left, which is opposite of a typical invoice look.
I have tried 25 different Report setups and I can't get the "Invoice look" of final columns on the Right.
I bought the Invoice template but learning how to apply it is a whole new learning curve since it has no documentation.
A
 		Abul 3/13/2014



As a followup to my question .. I have tried to get a layout this simple with Reports but it is not easily possible.
Reports has only 4 possible Table based layouts. Editing the resulting layout in HTML is a heap of work that still doesn't achieve the simpler result of my example.
Reports dictates that the Grouped fields always start on the left, which is opposite of a typical invoice look.
I have tried 25 different Report setups and I can't get the "Invoice look" of final columns on the Right.
I bought the Invoice template but learning how to apply it is a whole new learning curve since it has no documentation.


I tried several time to do the same in PHPR project with no luck as I wanted. Finally I moved to use FPDF lib to create Invoice or Invoice like report from PHPR. I think PHPR has shortfall in custom report making part.
A
 		Anapolis author 3/16/2014

I have since discovered the Solution for me.
It has been a while since I have used the "Totals" settings because of past "strangeness".
But for this purpose selecting "Total" for each of the 3 fields I wanted to finally add up .. (Sub-Total), (Taxed Value), (Sub-total + Taxed Value) Solved it!
The answer was sitting there the whole time!
I can select the records I want, Export to a Print-Friendly output and then Select PDF and as long as I don't choose over three records at a time I get the "Invoice" view with Totals columns in the bottom on the right side.
Handy feature