2. ASPRunnerPro General questions
  3. Printer friendly grouping
This topic is locked

Printer friendly grouping

 		11/2/2006 12:20:20 PM
ASPRunnerPro General questions
C
 chris author

Hi all,

I have a table view created to list fields that the client wants to see in a report, with the new wysiwyg, I am able to now do a decent layout of those fields, but what I really need is it to group or group nesting and I can seem to find anything to help me with that.

I only need that to happen in the printer-friendly page, so I am assuming that would be the page that is modified with the visual editor.

I would also like some pagination with that based on the a field, I have found some information on that elsewhere in this forum which I believe I could use to my advantage.

My sql query is as followed:

select "MANUAL_OBSERVATION_ID",

"OBSERVATION",

"IAD_RECOMMENDATION",

"IMSS_RESPONSE",

"ISSUE_ID",

"START_DATE",

"END_DATE",

"DUE_DATE",

"STATUS",

"ISSUE_OWNER",

"ISSUE_TITLE",

"ISSUE_DESCRIPTION",

"ISSUE_RESOLUTION",

"CONTACT_ID",

"REPORT_NAME",

"MANUAL_SECTION_ID",

"SECTION_NAME"

From "OBSERVE"."AUD_RPT_ALL_OPEN_ISSUES"



I would like to nested group based on report name, Manual_observation_id, issue_id in that order.

Any help would be greatly appreciated.

Thanks,

Chris.
Sergey Kornilov admin 11/4/2006

Chris,
you can try something like this.

  1. Proceed to SQL query tab in ASPRunnerPro and choose to order data by

    report name, Manual_observation_id, issue_id
  2. Make sure those fields appear first in fields list on the list page
  3. Set View format of REPORT_NAME field to Custom.

    Use the following code:
    if Session("SavedReportName")<>strValue then

    Session("SavedReportName") = strValue

    else

    strValue=""

    end if
    This will print Report name only when value changes.
  4. Repeat the same for other fields using different session variable for each field.
C
 		chris author 11/6/2006

Chris,

you can try something like this.

  1. Proceed to SQL query tab in ASPRunnerPro and choose to order data by

    report name, Manual_observation_id, issue_id
  2. Make sure those fields appear first in fields list on the list page
  3. Set View format of REPORT_NAME field to Custom.

    Use the following code:
    if Session("SavedReportName")<>strValue then

    Session("SavedReportName") = strValue

    else

    strValue=""

    end if
    This will print Report name only when value changes.
  4. Repeat the same for other fields using different session variable for each field.


I have done this and I am not getting the results I would expect, the printer friendly page only displays the number of records that I specify on the sql query page and nothing more. I really need help with this quickly.

I am not sure if it is a bug, design or programming issue.

How do I get this to look like a real report, do I need to get ASP programmer involved?

Maybe I am not using the program in the correct fashion, since the printer friendly could be meant to only strip away things from the displayed screen and not actually be a print the report type use.

Also, some of the fields are not displaying, they are numeric fields not string or text.

Thanks,

Chris.
Sergey Kornilov admin 11/6/2006

Printer-friendly page displays the same data as the list page.

Actually my recommendation mostly applies to the list page.
You can have a custom view in ASPRunnerPro for report purposes and number of records per page can be set to 10000 or something like this.
Not sure what is wrong with fields that are not displayed. Send me your files if you like me to take a closer look.