Hi all, I don't know if I'm being terminally stupid (very probably) but...
I have a Graphic Table Report to output Concrete Cube Test Results, tested on a date specified at output via a Report Var. CUBEDATA being the parent table with data about the cube to be tested, CUBERES being the child with the results of the test. The report works really well but I can't get one small part to work.
In the footer is some general bumph about accreditations etc and below that I want to be able to list Project level remarks (easy, as there is only one Project level remark field) and below that I want to be able to list any remarks that are stored in the CUBEDATA table remarks field, relating to specific Cubes. I am using:-
<<SqlList(<<CR>>,_Select [CUBEDATA].[CubeRem] _From [CUBEDATA] _Where [CUBEDATA].[PointID] = '<<PointID>>' _And [CUBEDATA].[CubeTestDt] = '<<Report Var.Prompt>>' _)>>
If I don't use the "And" part, the query works fine, but outputs all the remarks for the whole project, not just the ones being reported in the body of the report
(<<Report Var.Prompt>> asks for a date at output and only outputs results that were tested on that date)
My question is, is there a way to make the SqlList function take any notice of the result of the prompt?
Miles
replace '<<Report Var.Prompt>>'
with #<<Format(<<Report Var.Prompt>>,MM/dd/yyyy HH:mm:ss)>>#
Phil WadeDatgelBentley Channel Partner and Developer PartnerE: phil.wade@datgel.com | T: +61 2 8202 8600 & +65 6631 9780
Get the most out of gINT with Datgel Tools.
Phil, many many many thanks for that. I'd been banging my head against this for ages to no effect. It makes sense that the prompt needs to be formatted to the same type as the comparison field.