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


12»»

report issue Expand / Collapse
Author
Message
Posted 6/3/2006 12:48:43 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
ok i have a report .what i am trying to do is this ..

it is June 06 , i want to run a report for April 06 which i cannot do cause the system doesnt give me an option

ie only get Month current / month previous etc. 

i tryied customized search for april doesnt work . is there a way to do this

Randy

Post #1430
Posted 6/3/2006 2:10:51 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:10:09 PM
Posts: 1,834, Visits: 4,252
Hi Randy

A suggestion would be to create a custom filter on a date column relevant to the data you want to display .

Examples of this are also in the following topics:

topic http://forum.ayanova.com/Topic1319-90-2.aspx

topic http://forum.ayanova.com/Topic1304-90-1.aspx

 

For example, the custom filter below will show workorders with Service Date of Dec 14 2006 1:36AM, and June 5 2006 8:00AM and all workorders between those two selected Service Dates. 

A tutorial on creating custom filters can also be found in the AyaNova Manual "Tutorial: Using Custom Filters to Filter a Grid" starting page 99

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #1431
Posted 6/3/2006 2:23:58 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
also i cannot custom select ie .

want a specific client .so i select the client and it gives me all client workorders which is fine.

now i want to select only tags(work orders) from the month on april.06  it doesnt do it . it still shows me

all tags still . so how to i do this >?

Post #1432
Posted 6/3/2006 2:31:05 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
thanks
Post #1433
Posted 6/3/2006 2:32:49 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:10:09 PM
Posts: 1,834, Visits: 4,252
randy232 (6/3/2006)
also i cannot custom select ie .

want a specific client .so i select the client and it gives me all client workorders which is fine.

now i want to select only tags(work orders) from the month on april.06  it doesnt do it . it still shows me

all tags still . so how to i do this >?

Hi Randy

Not quite sure what you mean by "It doesn't do it. It still shows me all tags still"?

Not sure if this is what you are getting at - a column is only filterable by what it is. You can't filter the "Workorder" column by a date as a workorder is a number.

If you want to only show all workorders for a specific client with a Service Date in the month of April, than a suggestion is to =

filter the Client column to show only that client.

And than create a custom filter on the Service Date column, selecting for Less Than (as shown in examples in the topic links above and the screenshot above) the first Service Date in May, and for Greater than or Equal To the first Service Date in April.

I encourage you to try out the custom fields - they aren't set in stone so do feel free to try differenct combinations, etc to get the data you are looking for.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #1434
Posted 6/5/2006 1:58:11 AM
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
what was happening was i could select let say in service workorders to only

see tags from one client , so the system will show me only those tags

then i select to show me just completed to for the customer , the system then

show me all tags(work orders) for all customers . and i dont know why. 

randy

Post #1441
Posted 6/5/2006 7:26:49 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:10:09 PM
Posts: 1,834, Visits: 4,252
Hi Randy

Can you confirm from what specific navigation grid you are setting the filter on which column, and in this same navigation pane, the second filter on the second column in this same navigation grid? This way I can recreate what you are doing to help you identify what the issue is. I encourage you to provide specifics whenever posting a topic support request - in this way I can recreate exactly what you are doing and seeing.

Thanks

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #1445
Posted 6/7/2006 12:11:58 AM
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
hello

i think the newest version corrected this issue. i just update our systems to3.1.7 seems to work correctly now .

thanks for the help

Post #1493
Posted 6/7/2006 12:32:14 AM
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
ok every on the screen seems to work now but when i run the report complete by client.

it shows all data from the begining . now this is only happening when i select the custom

field like above. if i select previous or last 14 it seems to work fine. it is just when i select

custom that it shows all

<