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


12»»

custom totals report by client Expand / Collapse
Author
Message
Posted 3/2/2007 11:40:08 PM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 3/6/2007 1:34:52 PM
Posts: 43, Visits: 136
hi all !

Joyce you helped me on this report a while ago .but now it wont work . i corrected what i thought was wrong

but it still only show the first page . i must of missed something.. if you could look at this and correct my problem that would be great.. send me a bill for your time please ..

Randy

Post #2862
Posted 3/3/2007 8:44:26 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: 10/10/2008 2:53:05 PM
Posts: 1,840, Visits: 4,267
Hi Randy

This report template has been redone and is available in the topic http://forum.ayanova.com/Topic2424-103-1.aspx which provides three renditions of this report template for your needs. Delete this report template in your AyaNova database via Administration navigation pane - > Report Templates; and then download, extract and import the report templates available from that forum topic.

The report template you provided (I removed the attachment so that no one else accidentily attempts to use it) is not compatible with AyaNova 3.3.3.0 or higher, as that is when the latest report printing engine component was included with AyaNova to provide compatiblity with new operating systems and address internal reporting issues. As this new printing engine component version is more stringent in how data is laid out, that report template you had attached is not compatible with the new printing engine because it does not include a WorkorderHeader band resulting in the report template not understanding where to get the data from.

Additional details about updating from a version older than 3.3.3.0 and the new report printing component can also be found in the forum topic http://forum.ayanova.com/Topic2579-100-1.aspx

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #2863
Posted 3/3/2007 2:13:38 PM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 3/6/2007 1:34:52 PM
Posts: 43, Visits: 136
Joyce

I have already downloaded that version it isnt even close to the detail we use in our report plus it doesnt show N/C hour total billed etc.

so i was just wondering how can i get my old report fixed. can you look at it and let me know . I dont have the time to mess with it now .but I am willing to pay you to do it for me . if that is possible ?

Randy

Post #2864
Posted 3/3/2007 2:15:56 PM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 3/6/2007 1:34:52 PM
Posts: 43, Visits: 136
Joyce,

on a side note did you look at our report or just assume it was like the original ?

cuz it is way different..


Randy

Post #2865
Posted 3/3/2007 4:01:27 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: 10/10/2008 2:53:05 PM
Posts: 1,840, Visits: 4,267
Hi again Randy

Yes - I took a look at the report template you had attached - I must of missed the N/C data fields if they were on the report template you attached, as it looked very much like the report templates from http://forum.ayanova.com/Topic2424-103-1.aspx and your original post did not state specifically what was the issue.

I'll take a look again, and see what fields are different. Do also identify specifically what an issue is when asking about a report template, this way I can respond quicker to your issue.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #2866
Posted 3/3/2007 4:13:42 PM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 3/6/2007 1:34:52 PM
Posts: 43, Visits: 136
joyce,

let me know it was late when i posted that so i may not have loaded the correct report .

thanks for all your help

Randy

Post #2867
Posted 3/3/2007 4:19:11 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: 10/10/2008 2:53:05 PM
Posts: 1,840, Visits: 4,267
Hi again Randy

The report template you posted was called "Monthly total by client" accessed from the Service Workorders grid - it defintiely is a report template that won't work with AyaNova 3.3.3.0 or higher due to the new printing engine component as identified above

I checked that report template you provided again - and it does have a Net NC and a Total NC added, I apologize, I missed seeing those fields as didn't know exactly what I was supposed to be looking for - I will edit one of those sample report templates from that topic I provided and post it as soon as I can.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #2868
Posted 3/3/2007 4:31:50 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: 10/10/2008 2:53:05 PM
Posts: 1,840, Visits: 4,267
Hi again Randy

The report template you sent, because I am using 3.4.2.0, I can not see what it used to be grouped by. I am assuming because Project was set in the GroupHeader, that the workorders were grouped by Project, not by client - is this correct?

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #2869
Posted 3/3/2007 5:25:05 PM
AyaNova Sales & Support

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