Alpha Video Training
Results 1 to 4 of 4

Thread: Problems with web report...

  1. #1
    Member
    Real Name
    Jim Dusoe
    Join Date
    Aug 2008
    Location
    Maine
    Posts
    48

    Default Problems with web report...

    I am new to Alpha 5 (last couple of weeks) and need help with getting a report to publish and run on my server.

    Here is what I have working so far after searching the forums and watching video tutorials:

    1. I have verified the Alpha Printer and Amyuni print drivers are installed
    2. I have successfully connected and built both display and maintenance pages (active linked tables - I am using an MS SQL Server 2005 on a hosted server connected through a hosted VPS. All works well)
    3. I have successfully created and am able to view 2 simple reports - a Course list and a Student list on my desktop.
    4. I have added the following code in the After Validate event code of a simple dialog control:

    Code:
    dim filter as c 
    dim order as c 
    Filter = ".T."
    Order = ""
    Dim filename as c 
    filename = session.session_folder + "tempreport.html"
    filename = report.saveas("CourseList@[PathAlias.ADB_Path]\v_a_yr_course_list.ddd","html",filter,order,filename,.f.)
    if file.exists(filename) 
    	currentform.RedirectTarget = session.session_url + "tempreport.html?" +  time("hms3")
    end if
    This code is all generated from the Genie just to try to get it to run one report.

    I get the following error on both my local desktop and production server:

    Errors in: event.AfterValidate code:

    Amyuni Low Level Print:
    Layout name: CourseList@[PathAlias.ADB_Path]\v_a_yr_course_list.ddd
    Layout type: report
    Layout has no pages.


    I cannot seem to find anything on the forums in respect to this. I believe I have my path aliases set up properly:

    Local Profile
    local webroot = [PathAlias.ADB_Path] = =a5.get_path()

    Summit Profile
    [PathAlias.ADB_Path] = C:\A5Webroot\Summit

    Any help would be GREATLY appreciated. Can't seem to track this one down.
    Jim Dusoe
    Net Data Design Innovations
    Alpha Software Senior System Architect

  2. #2
    Member Tommy Thompson's Avatar
    Real Name
    Tommy Thompson
    Join Date
    Apr 2000
    Location
    Tennessee (Macgregor 26S)
    Posts
    451

    Default Re: Problems with web report...

    Try changing the filter from ".T." to "" like the order and see if it prints.
    Tommy Thompson
    Thompson Consulting Services
    Beautiful Kentucky Lake, Springville, TN 38256
    tommy@btthompson.com


  3. #3
    Member
    Real Name
    Jim Dusoe
    Join Date
    Aug 2008
    Location
    Maine
    Posts
    48

    Default Re: Problems with web report...

    Thanks!! That was it. I had tried settting filter = ".f.", but not leaving it blank.

    Kudos!!
    Jim Dusoe
    Net Data Design Innovations
    Alpha Software Senior System Architect

  4. #4
    "Certified" Alphaholic
    Real Name
    Mike Christensen
    Join Date
    Nov 2005
    Location
    Michigan U.P.
    Posts
    5,937

    Default Re: Problems with web report...

    Curious.....
    Setting to "" works why?? Is it that this defaults to true? And that maybe in the Web Side" of things, you have to use character and so maybe setting the value to be "True" would have worked as well??
    Mike
    __________________________________________
    It is only when we forget all our learning that we begin to know.
    It's not what you look at that matters, it's what you see.
    Henry David Thoreau
    __________________________________________




Similar Threads

  1. Report problems !!please help!!
    By devingray_2000 in forum Alpha Five Version 8
    Replies: 1
    Last Post: 02-06-2008, 02:07 AM
  2. Report Problems
    By Silver in forum Alpha Five Version 8
    Replies: 12
    Last Post: 01-06-2008, 12:48 AM
  3. Print web record and make web report.pdf ?
    By emrprive in forum Web Application Server v7
    Replies: 1
    Last Post: 04-18-2006, 11:51 AM
  4. Report problems--could be me....
    By Monica Hammers in forum Alpha Five Version 5
    Replies: 21
    Last Post: 07-26-2005, 05:01 AM
  5. Web report similar to filtered desktop report
    By Robert Rough in forum Web Application Server v6
    Replies: 2
    Last Post: 06-08-2005, 10:14 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
  •