2. ASPRunnerPro General questions
  3. report
This topic is locked

report

 		11/22/2008 6:09:13 AM
ASPRunnerPro General questions
C
 carlo author

hi

i still working with asp runner 6.0

and i have some trouble with report

  1. how i could chosse columen order ?

    trere is not like table a page where i caould choos in simply way in wich order i want my column
    (eg:

    i have id, description, qty, price , qty*price

    i would to have a differnet order
    i could decide only in sql query?)
  2. i need to hide a a value

    i need to hie a value based upon another

    (eg :
    i have id, description, qty, price , qtyprice

    if description is null i do not want to see qty    price)
  3. i would like to start report page with only 1 group per page

    i have follow suggestion in tips and tricks (sql before) but i not work

    on page i see 1 but in the page i have 5 groups...
    thanks
    carlo
J
 		Jane 11/24/2008

Carlo,
please see my answers below:

  1. to change fields order on the report proceed to the Report: Totals tab and drag and drop fields as you want.
  2. to hide field value based on the another field value use Custom format on the "View as" settings dialog on the Visual Editor tab.

    Here is a sample:
    if rs("description")="" then

    strValue = ""

    end if


3. to change number of groups per page open generated ..._report.asp file, find and modify following code:

if SESSION(strTableName & "pagesize")="" then

SESSION(strTableName & "_pagesize")=5
C
 		carlo author 11/24/2008

thanks for your asnwer
Carlo
C
 		carlo author 11/28/2008

Hello Jane
I have try but :

Carlo,

please see my answers below:
2. to hide field value based on the another field value use Custom format on the "View as" settings dialog on the Visual Editor tab.

Here is a sample:
how i cold do it with a test upon another value in my report ?

(i mean : i have code,description,qty,price,total

if price is equal to zero the total i wudl to hide

without using RS( ) )


Is not possible to put it in events ?

Carlo,

please see my answers below:
3. to change number of groups per page open generated ..._report.asp file, find and modify following code:


Thanks
carlo
J
 		Jane 11/28/2008

Carlo,
here is a sample:

if rs("price")=0 then

strValue = ""

end if


Is it possible to put it in events ?



No.

We'll add this option to the project in the next version.