This topic is locked

Sql statement

6/13/2010 12:27:55 PM
PHPRunner General questions
S
skiswani author

Hello,

How can get the sql statement use in a report from inside the report , I mean what is the variable holding it.
Thank you all

D
danaci 6/13/2010

insert code snippet on report page.

S
skiswani author 6/13/2010

Hello

Thank you for your reply , but what I need is the variable which holds the sql statement that I can display for debugging or reuse it.
Thank you again

C
cgetty 6/14/2010

Are you trying to do something like this?
http://www.asprunner.com/forums/topic/14611-printer-friendly-editer-moving-a-field/pagehlcgettyfromsearch1

S
skiswani author 6/15/2010

Not exactly .. what I want is : in the summary bar I want to divide one sum result with another sum resultin all grouping levels

the following images can explain my idea
Design Page :


OutPut :(but for all grouping levels)


It so appreciated if help is available because I tried all what I know but failed.
with lots of thanks

A
ann 6/15/2010

Hi,
you have to do it manually in the HTML mode on the Visual Editor tab.

S
skiswani author 6/15/2010

Hello,

I tried to do it manually in the html code , I inserted a script in it but the result was that the code was transformed into somthing else and didnt remain as I wrote it.
can you give more help if possible?
thank you

A
ann 6/15/2010

Hi,
It's difficult to tell you what's happening without seeing actual files. Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.

S
skiswani author 6/15/2010

Hello,

Thank for keeping up with me, the thing that Iam not getting any errors , just cant display the vlues.

one thing could give a good start, how to get these values into php or java script
{$page_totalgrade_from_sum}

{$page_totalgrade_to_sum}

thank you again

A
ann 6/18/2010

Hi,
you can access these values in the generated file \output\classes\reportlib.php only. Use function _writePage() to change them.

S
skiswani author 6/19/2010

I will try that .. thank you
Regards