Craig,

If you want a date range based on JC Transactions' Accounting date you may want to try KB133449.

How do I create a date range on a report in Report Designer?

This is a much more simple design formula for date ranges on reports.

Call me if you have not solved this if you like

Thank you for the suggestion. Unfortunately, it did not work.

I am trying to modify the JC Labor Hours report to create a JC report that counts the number of hours worked on certain cost codes in a specific time frame so we can produce backup for charge-out hours.

I am guessing the CND I created is not available because the Labor Hours report uses JTD Labor Units from the JC - Cost Code index and nothing from the JC - Transaction index. Is that likely?

This is all new to me and i am teaching myself to use Report Designer in my spare time (online training for RD may not be available until March).

My attempt at solving this is going to be replacing to JC - Cost Code index fields with JC - Transaction index fields and see where that gets me. Unless any of the good people on this site have a different suggestion?

My thanks,

Craig

Craig,

I believe you've reached a level of understanding with your report design.  Every report created in Report Designer has a primary driving record, i. e., the data file which the report reads and sorts in the order you designate, and to which any filters are applied (i.e. "conditions" imposed via formulas or other specific criteria which are logically applied against each record as the report reads through the file.

Timberline uses Master Files and Transactions Files.  Only Transaction files have an accounting date field, and to produce a report that allows you to filter by specific accounting dates, your driving record needs to be a transaction record.  In Job Cost, the Master File contains accumulator buckets, such as YTD, JTD, QTD, MTD, Last Month, Next Month, etc.   Reports that draw on the master file are much quicker to produce, because the data is already stored, and summary totals do not need to be recalculated.  

However, if the predefined accumulator totals do not specifically meet your report requirements, then you would need to create a report that uses the Transaction file as the driving record. You can still pull information from the Master file for inclusion on the report, such as Job Name, Cost Code Description, etc., and through the use of totals and summarization options be able to present the data in a similar fashion to that stored on the master file, but have it include only the specific date range you desire.

I would be willing to help you remotely for 15 minutes or so to point out how to use these features. I support multiple Sage 300 CRE Timberline clients using GoToAssist, a remote desktop help program, allowing me to see your screen while speaking to you on the phone.  Please send me a private message if you would like to do that.

Regards,

Art Minds

Thanks for the explanation Art, it is quite well described.

I would send you a private message except that, being new to this forum, i have not figured out how to do that. Also, other projects are demanding my time.

Many thanks to you!

Craig

Craig,

Short answer: for a formula to show up as an available option to apply as a condition must include a boolean evaluation (evaluates as true or false) referencing a data field in the driving record of the report. A boolean condition is one or more of these: equal to, great than, greater than or equal to, less than, less than or equal to, not equal to.

In your example, if you were evaluating against the Accounting Date of a Job Cost Transactions record, you would need two prompts: beginning date and ending date.  And your formula would read something like Accounting Date (from the Current.JCT file) >= beginning date (prompt) and Accounting Date  (from the Current.JCT file) <= ending date (prompt).

Of course, if you were building this report from scratch, you would need to create additional formulas and apply additional conditions to extract only the specific transactions containing the data you want in the report.

Hope that help.

Art Minds

Pasadena, CA

This is excellent information you're sharing here Art.  I really appreciate your participation!

Thank you,

Scott Haines

The likely reason is that the primary driving record for the report design does not contain the fields that you used in your print condition formula.

Hello,

I have a follow up question. I'm also trying to modify an existing report and I've added JC - Category into the list of available Fields. It does show up in report designer, but not in Add Conditions. I understand it could be same "primary driving record" issue? If so, how come JC - Work Order, JC - Job and even PJ - Job are available to choose from, but not JC - Category? Is it possible to somehow "add" it to the list?

Thanks a lot!

Sergey