2. PHPRunner General questions
  3. Viewing only 'users own data' for reports
This topic is locked

Viewing only 'users own data' for reports

 		4/18/2007 7:58:14 PM
PHPRunner General questions
L
 little44236 author

The update looks great.
I easily made a summary report for data but I'm having a problem in getting the viewing restricted to "users own data." The report setup doesn't allow me to set up a master/detail relationship so I just set the advanced security access to "users can see and edit their own data only." When I login as one of my users the summary of all the data in the database is visible.
How should I fix this?
Also a more minor problem: for some reason the report formatting from the detail is lost when I used the "sum" function but maintained when I used the "average." I have both in my report and one is properly formated and the other is not. I know how to fix this in the html code.
Bob Small
J
 		Jane 4/19/2007

Bob,
please see my answers below:

  1. thank you for pointing me to this bug.

    We'll fix it in the next PHPRunner update.
  2. I'm not sure that I understand you correctly. Please give me more detailed description on how to reproduce this error.
L
 		little44236 author 4/19/2007

To duplicate the problem:

  1. Do a report and format the detail as current
  2. Click the Sum and Average indicator for this data. You will not be able to format these as currency
  3. When you run the report the detail and the average data will be properly formated but the sum will not. Code below which shows different formating for sum and average

    [codebox]<TR>

    <TD class=group_1 style="BORDER-LEFT: #cccccc 1px solid">Sum</TD>

    <TD class=group_1>Â </TD>

    <TD class=group_1>Â </TD>

    <TD class=group_1>{$row.groupMONTH_totalGross_Sales_sum}</TD>

    <TD class=group_1>{$row.groupMONTH_totalTotal_Charges_sum}</TD>

    <TD class=group_1>{$row.groupMONTH_totalNet_Recovery_sum}</TD>

    <TD class=group_1>{$row.groupMONTH_totalFEES_sum}</TD>

    <TD class=group_1>{$row.groupMONTH_totalA_FEES_sum}</TD>

    <TD class=group_1>{$row.groupMONTH_totalNET_TO_sum}</TD><!-- Avg -->

    <TR>

    <TD class=group_1>Average</TD>

    <TD class=group_1>Â </TD>

    <TD class=group_1>Â </TD>

    <TD class=group_1>{$row.groupMONTH_totalGross_Sales_avg}</TD>

    <TD class=group_1>{$row.groupMONTH_totalTotal_Charges_avg}</TD>

    <TD class=group_1>{$row.groupMONTH_totalNet_Recovery_avg}</TD>

    <TD class=group_1>{$row.groupMONTH_totalFEES_avg}</TD>

    <TD class=group_1>{$row.groupMONTH_totalA_FEES_avg}</TD>

    <TD class=group_1>{$row.groupMONTH_totalNET_TO_avg}</TD><!--{/if}--><!--{/foreach}--></TR></TBODY></TABLE><BR>{$pagination}<BR><BR>{include_if_exists file="include/footer.php"}

    </BODY></HTML>[/codebox]
J
 		Jane 4/20/2007

Thanks for explanation.

We'll fix it in the next PHPRunner update.
J
 		jbartc 6/28/2007

Bob,

please see my answers below:

  1. thank you for pointing me to this bug.

    We'll fix it in the next PHPRunner update.
  2. I'm not sure that I understand you correctly. Please give me more detailed description on how to reproduce this error.
J
 		jbartc 6/28/2007

Bob,

please see my answers below:

  1. thank you for pointing me to this bug.

    We'll fix it in the next PHPRunner update.
  2. I'm not sure that I understand you correctly. Please give me more detailed description on how to reproduce this error.


Jane:
I just upgraded to 4.0 Build 265 and am experiencing the same issue of not being able to limit users to seeing their only their own data in reports. Was the bug reported in this post fixed?
Thanks.

John
J
 		Jane 6/29/2007

John,
I can't reproduce this error.

Try to reset your pages in the Visual Editor tab and rebuild your pages.

If it doesn't help publish your project on Demo Account and send to [email=support@xlinesoft.com]support@xlinesoft.com[/email] a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.