Hi,
i want to calculate the total of payments by clients within the current month, to do that i used the following code :
D2=01/04/2012, E2=30/04/2012; G2=NP("DateFilter";D2;E2)
I2=NL("filter";"COMPANY$G_L Entry";"Source No_";"G_L Account No_";411000;"Posting Date";G2)
B5=NL("Rows";"COMPANY$Customer";;"No_";$I$2)
C5=NF(B5;"No_")
D5=NF(B5;"Name")
G5=NL("Sum";"COMPANY$G_L Entry";"Amount";"Document Type";"1";"Source No_";C5;"G_L Account No_";411000;"Posting Date"; G2)
The result is perfect, but my problem is : How can i sort those Clients by the Total of Payments ?
i checked a similar post here : http://community.jetreports.com/viewtopic.php?f=7&t=1856, but it doesn't work for me!!
is it possible to do that using Flow Fields? how?
Thanks,
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi,
You can't use the methods described in that other topic when using the universal data source to connect to the backend SQL database used by Navision. You have to be using a Jet Reports Navision data source to use the methods described. Similarly, I believe you need to be using a Navision data source in order for flow fields to work. Your best bet is probably to just use a Navision data source. If for some reason you can't do that, you would have to construct a SQL query and use the SQL= functionality. Does that make sense?
Regards,
Hughes -
Jet Reports Historic Posts Hi and thanks for your relplay,
it works now after we get the licence from our vendor, life is better now with jet :) .
All the best,
Please sign in to leave a comment.