I have a database ( SQL) with two fields year period For reporting purposes I need to combine these into one . ie period 6 2007 becomes 2007o6 period 10 2008 200810 so that I can use them as filters
Issue is report that needs tobe filtered from period 6 2007 to period x 2008 I have not found a way to createthis filter in Jet fx as selection data is coming from an optiosn page
Date
Votes
3 comments
-
Jet Reports Historic Posts I've not had much in the way of experience dealing with periods, but from what I can think of from the top of my head, using an actual date that corresponds to those periods may be a better way of doing it.
Can you share some more information on the layout of your report? -
Jet Reports Historic Posts Hi Vanjump,
As I don't have your table I created one in NAV that contains a Year and a Period field - both Integers. After all it's the method that counts, not the database, isn't it?
I think that the enclosed report may help you to get it right for your own report and database.
Please let me know if it works for you. -
Jet Reports Historic Posts SOrry I took so long to get back to you will try this and see
Please sign in to leave a comment.