AyaNova service management & work order software
AyaNova Support Forum
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        


12»»

Blank Report Fields Expand / Collapse
Author
Message
Posted 2/14/2007 11:57:24 AM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 10/1/2007 10:04:58 AM
Posts: 118, Visits: 569
Hi Joyce,

I've attached two templates I am having trouble trying to get the Client Name and Unit S/N to display on the report.  I have quite a few other templates I am having the same issue with but these two are the ones I need to use presently.  All were created pre-version 3.3.3.

I read through and tried the suggestions listed in the upgrade notice http://forum.ayanova.com/Topic2579-100-1.aspx.  I have also tried deleting and recreating the two problems fields without success.

Would you please take a look at the two templates I have uploaded and advise if there is a quick tweak I can do to make these fields display?

Thanks,

Bob

  Post Attachments 
Template Problems - Units.zip (2 views, 75.10 KB)

Post #2787
Posted 2/14/2007 12:19:28 PM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Today @ 2:02:40 PM
Posts: 1,835, Visits: 4,253
Hi Bob

I will take a look and get back to you as soon as I can.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #2788
Posted 2/14/2007 12:55:40 PM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Today @ 2:02:40 PM
Posts: 1,835, Visits: 4,253
Hi Bob

The Detailed report template you provided did not have a WorkorderHeader band - resulting in the report not understanding where to get any data from and resulting in blank fields. I created a copy of the Sample Unit History Report Showing Labor Details Plus Sub-Charges and Totals from http://forum.ayanova.com/Topic790-103-1.aspx and have put in the zip file attached for you.

The report called Unit History Report you sent had a GroupHeader band not tied to any dataset - resulting in the report not understanding where to get the data fields from.

I deleted that GroupHeader band, added a GroupHeader band for within the WorkorderHeader band and set the Client datafield to show within there. I also editd the collection property for this GroupHeader band so that it groups on the client name (in case you have more than one client filtered to show on the grid).

I also added the unit's serial number datafield into the Detail band for the WorkorderItem.

It is not possible to use the unit to group from the workorderheader - because the data from that is actually avaialble from the WorkorderItem

If you want to group units to display together for the same client, it is suggested before printing that you sort the Items grid first column by the Clients, and second column by the Serial Number so that the units are already in order when you print.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com


  Post Attachments 
newunithistoryreports.zip (4 views, 69.46 KB)
Post #2789
Posted 2/14/2007 4:41:46 PM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 10/1/2007 10:04:58 AM
Posts: 118, Visits: 569
Thank you Joyce,

I will compare the ones I have against the ones you provided and learn where I made my mistakes so I don't have to keep pestering  you.

Bob

Post #2790
Posted 2/14/2007 4:55:33 PM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Today @ 2:02:40 PM
Posts: 1,835, Visits: 4,253
That's OK Bob - because the new report engine is more stringent than the old version to be able to provide compatibility with new operating systems and address internal issues, some reports that worked in the old version need to be redone so that they follow the requirements  - i.e. datafields placed within bound data bands only when using a "detailed" style report template.

If you find others and not sure what to do, do let me know as you have done by zipping up the old and attaching.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #2791
Posted 5/10/2007 9:30:28 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 9/26/2008 10:09:16 AM
Posts: 14, Visits: 25
I am having the same issue and I cannot seem to figure out how to add the appropriate changes to the work order reports. I have attached a zipped copy of the report and if you can look it over for me I would appreciate it.

This issue is the customers name and address information in the detail section is blank. After reading your post here I noticed that this detail section does not have an appropriate detail header assigned to it but when I create a new detail header it creates a whole new detail section as well.

This is the first time I have tried attaching a file to a post so forgive me if I don't get it right the first time

Thanks in advance...JOE

  Post Attachments 
_Work Order.zip (2 views, 52.38 KB)

Post #3085
Posted 5/10/2007 9:41:59 AM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Today @ 2:02:40 PM
Posts: 1,835, Visits: 4,253
Hi

You will need to create a new detailed workorder report from scratch - this report template is not useable in AyaNova v3.3.3.0 or higher, nor can be edited to work.

I would suggest downloading and importing the Sample Dispatching Report template from http://forum.ayanova.com/Topic2580-103-1.aspx and customizing it - as it already has the bands inserted (for WorkorderHeader, for WorkorderItem, for ScheduledUsers etc) along with their datafields so that you can see what goes where.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #3086
Posted 5/10/2007 11:57:32 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 9/26/2008 10:09:16 AM
Posts: 14, Visits: 25
Ouch...I was afraid you would say that

thanks for the help.

JOE

Post #3088