Sage Construction & Real Estate

Welcome to the Sage Construction and Real Estate products Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Report writing

Posted By Ryan Lipka 11 months ago

I am trying to write a report, i have a if then and select syntax.

Does anybody know the correct code for the tmcdln.crtfid table/column

I want the report to be able to select sum from the tmcdln.hrswrk based on a y in the tmcdln.crtfid column.

using y, yes, Y, Yes, YES, "Y", 1, none of these are recognized. Any help will be appreciated.

Parents

0 Walt Mathieson 11 months ago

Jim is a terrific source for reports. I agree that the SQL approach, with a SELECT Sum() approach is probably better. The tmcdln.crtfid actual data is Y or N or Blank. You might need to use single quotes around the Y (like 'Y') in the WHERE section of the calculation.
Cancel
Vote Up 0 Vote Down

Reply

Verify Answer

Cancel

Reply

0 Walt Mathieson 11 months ago

Jim is a terrific source for reports. I agree that the SQL approach, with a SELECT Sum() approach is probably better. The tmcdln.crtfid actual data is Y or N or Blank. You might need to use single quotes around the Y (like 'Y') in the WHERE section of the calculation.
Cancel
Vote Up 0 Vote Down

Reply

Verify Answer

Cancel

Children

No Data

Sage Construction & Real Estate

Report writing

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING