This topic is locked

Issue with Visual Editor and Reports

12/4/2008 7:47:25 AM
PHPRunner General questions
hfg author

This may be a bit hard to describe, but here it goes.
I have a report where I have 3 fields, Customer, Cost and Days. There are a number of other fields that are included in the reports search page but not shown. For Cost I have a Sum and a Average, for days just an average. The report is Grouped on the customer.
The default report is about 4 lines long for each customer (summary only). I have been attempting to cut this down to a single line per customer. After doing so in visual editor the boxes for Show come unchecked on the "Report:Totals" wizard page, rechecking them messes up all of the work I had done on visual editor.
I have even attempted to do the editing in HTML mode making sure none of the control elements {begin...} are removed. This did not help.
Am I doing something wrong? Is there an easier way using reports to get everything on a single line?
For the moment I have gone back to using a list and the Group by sql method. This isn't as nice as the reports, but it cuts down on the paper.

J
Jane 12/4/2008

Hi,



Visual Editor
allows do mix all totals in one line.

Please make sure you have just drag and drop, not delete these controls on the Visual Editor tab.

hfg author 12/4/2008

When I did the HTML edit I made sure the only things I deleted were <TR><TD></TD></TR> type tags. Any thing in a {} bracket was left alone. It still unchecked the Show on the Totals page.

J
Jane 12/4/2008

Please zip and send your project along with database creation script to support@xlinesoft.com.

hfg author 12/5/2008

I will get that to you next week. I did make a few discoveries though.
1st, before I was building a summary only report. I gave up on that and made a Group by list.
But the user asked for a detail report as well. Now that I am including the detail the problem has largely gone away.
Where I am now having a problem is the order I set for the fields gets changed when I rebuild the project (if I'm making a change to something else).