2. PHPRunner General questions
  3. Report from/on the list page limitations
This topic is locked

Report from/on the list page limitations

 		4/30/2009 2:26:02 PM
PHPRunner General questions
V
 vytb author

In order to overcome the limitations (four groups, etc.) of the report pages, I make queries (one row) to expose them on the list pages as the reports. That's OK.
However, if I insert a row below and subsequentialy insert/drag the fields, they appear empty. Only fields on the 'original' row are OK.
What am I missing?
vin7102 5/1/2009

Vitas,
Just an idea here that I started using when I ran into the 4 group limit. I setup the first 4 groups and their properties, then I go to the report totals page and drag and drop the remaining fields into order of how i want them to appear.

After selecting the block layout, I go to the editor and start to modify. If I want to add a group, I just go to the fifth column and right click on the bottom field (fifth field from the top) and cut, to remove that field from the page. Right click again on that (now empty white field) and choose cell properties and change the background color. Then change all the fields above that to the colors and fonts I want to see for the new group. Now I have 5 groups in a sense... keep going down the line for as many groups as you need.
Hope it works for you,

Vince
V
 		vytb author 5/1/2009

Vitas,

Just an idea here that I started using when I ran into the 4 group limit. I setup the first 4 groups and their properties, then I go to the report totals page and drag and drop the remaining fields into order of how i want them to appear.

After selecting the block layout, I go to the editor and start to modify. If I want to add a group, I just go to the fifth column and right click on the bottom field (fifth field from the top) and cut, to remove that field from the page. Right click again on that (now empty white field) and choose cell properties and change the background color. Then change all the fields above that to the colors and fonts I want to see for the new group. Now I have 5 groups in a sense... keep going down the line for as many groups as you need.
Hope it works for you,

Vince


Thanks, very interesting, I'll try!
On the other hand, some of my reports can hardly be automatic since they mostly consist of calculated fields (totals, means, percentages, std, etc.) thus I would need more flexibility. Layout changing, field inserting on the list page would be enough if succeeded (like in add/edit) pages. Another option would be manually transpose the fields, labels, etc. However, when the number of these fields gets big, a simple dragging of them like on the other pages would be extremely beneficial.