Alpha Video Training
Results 1 to 8 of 8

Thread: Session variables displaying on Reports - truncating to 10 characters

  1. #1
    Member
    Real Name
    Mike Perry
    Join Date
    Apr 2012
    Posts
    13

    Default Session variables displaying on Reports - truncating to 10 characters

    Thank you for viewing my post - I am a recent A5 convert so apologies in advance if my questions are a little fundamental


    My query:

    I have successfully displayed session variables onto reports

    However the displayed output of the session variables is truncated to 10 characters


    What I am doing to generate the above:

    1. I have a dialog that has some dropdown boxes and a "Print Report" button
    2. When the user presses the button an AJAX callback saves the dropdown box data as session variables and calls a report
    3. In the report I have some calculated fields that have the following type expressions - session.Lead_Report_Practise
    4. The displayed output of each session variable is truncated to 10 characters no matter what width I format the field as

    The only other interest point is that I am using the recent Power search feature for reports

    Regards
    Mike

  2. #2
    Member
    Real Name
    Mike Perry
    Join Date
    Apr 2012
    Posts
    13

    Default Re: Session variables displaying on Reports - truncating to 10 characters

    bump.........

    Since no replies I will try to provide more detail

    I have included images that:

    Image 1: Shows the presented report were the calculated filed is being truncated (see the circles)
    Image 2: Shows how I am defining the calculated field
    Image 3: Shows how I am defining the session variable within an AJAX callback

    Please note: I have noticed that in the database fields I can select/specify the width of my field in the format tab, however in a calculated field there is no such option available in the format tab

    I hope this helps

    truncated3.JPGtruncate1.JPGtruncate2.JPG

  3. #3
    Member
    Real Name
    Jeff Benson
    Join Date
    Jul 2002
    Location
    Stamford, CT USA
    Posts
    90

    Default Re: Session variables displaying on Reports - truncating to 10 characters

    The format tab has display format width property for a calculated field.

  4. #4
    Member
    Real Name
    Mike Perry
    Join Date
    Apr 2012
    Posts
    13

    Default Re: Session variables displaying on Reports - truncating to 10 characters

    Thanks for the reply to my post.

    I have attached a screenshot of the Format Tab of the calculated field and you will see that I have no width property available

    Hopefully I have made a simply error?

    dbfieldproperties.JPGcalcfieldproperties.JPG
    Last edited by mikeperry; 09-24-2012 at 09:00 AM.

  5. #5
    Member
    Real Name
    Jeff Benson
    Join Date
    Jul 2002
    Location
    Stamford, CT USA
    Posts
    90

    Default Re: Session variables displaying on Reports - truncating to 10 characters

    I don't know. I have created a bunch of calc fields and they all have the format width showing.

    I don't think you need the function *current_expression. That is a desktop only function, I believe, not relevant in a web application. What happens if you remove that function?

  6. #6
    Member
    Real Name
    Bruce Jonson
    Join Date
    May 2010
    Location
    New Zealand
    Posts
    432

    Default Re: Session variables displaying on Reports - truncating to 10 characters

    Hi Jeff,
    I will answer for Mike as I am working with him on this.
    It makes no difference if you remove that function. We have another calc filed and it behaves exactly the same as in truncates to 10.
    In the example Mike did the screen shots of Yeah that has the added complication of the function that retuns the Group by value as in for each group header we want "North Carolina" not "State" But that function allows us to pass in "State" and it Returns "North Carolina" Or wjat ever the value of the State field is for each grouping. In another run the grouping may be by City for example... But I digress...

    In another example we have a a straight Session variable we want to display, no functions just passing in the Session Variable.
    The mystery for us is why there is no Display Format Properties for Calc fields. We are popping up the an Alert just before the report opens and says the Session variable is "Company Name" then on the report we get "Company N" << Truncated to 10... What gives???

    Mike has laid out in his posts exactly what we are doing. What are we missing?
    Any help would appreciated as we are completely stumped.

    Thanks Bruce
    Last edited by kiwibruce; 09-24-2012 at 08:43 PM.

  7. #7
    Member
    Real Name
    Mike Perry
    Join Date
    Apr 2012
    Posts
    13

    Default Re: Session variables displaying on Reports - truncating to 10 characters

    Hi all - thank you for your replies.

    The problem has been solved by going to the Object Explorer and setting the width field in the Entry property for each object. I still do not know why the calc fields property box did not give me access to the width property but the above work around gets me there

    Many thanks again to those who posted replies

  8. #8
    Member
    Real Name
    Robin Jones
    Join Date
    Sep 2009
    Location
    Wetherby West Yorkshire
    Posts
    92

    Default Re: Session variables displaying on Reports - truncating to 10 characters

    I've had simialr problems with calculated fields.

    I found that if you put the fields in a rich text container, that does it.

Similar Threads

  1. Using Session Variables with Reports
    By Dfred in forum Application Server Version 11 - Web/Browser Applications
    Replies: 5
    Last Post: 03-19-2012, 11:21 AM
  2. Using Session variables across multiple grids in same session
    By timposey in forum Application Server Version 10 - Web/Browser Applications
    Replies: 2
    Last Post: 11-24-2010, 11:49 AM
  3. Variables not displaying in DEBUG
    By Gary Kissinger in forum Alpha Five Version 8
    Replies: 11
    Last Post: 03-27-2008, 06:09 PM
  4. Displaying Session Variables on web page
    By robert swanson in forum Web Application Server v6
    Replies: 6
    Last Post: 10-15-2005, 11:16 AM
  5. Variables variables global, session or layout?
    By Greg Fong in forum Alpha Five Version 4
    Replies: 4
    Last Post: 07-11-2001, 03:54 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •