Default Avatar

misiak

misiak

About

Username
misiak
Joined
Visits
0
Last Active
Roles
Members

Comments

  • gordk wrote: // report has a variable recid created in the dictionary // on dialog form of report sql parm name oid set to type float value set to // [recid] Hi Gord, One more question: How to change name of variable ([recid] -> [rec…
  • Ad 1) Actually I dont change SQL much : before: 'select * from bill where bill_id = :RID' after: 'select * from bill where bill_id = 15' Ad 2) I do not define anything in data dictionary (no expressions) Ad 3) I dont make variables names …
  • I can change SQL property of queries on frReport's DialogForm but then my reports are empty. It looks like queries have no records, but if i check SQL its ok, its different for every report (diffrent = every report has different RECORD_ID). I th…
  • Ok I found a way! frReport (the one to which I add prepared reports) canot have loaded .frf file. frReport.Clear; frReport.EMFPages.AddFrom(fr); This works! Best regards misiak
  • For 2nd method I wrote this code: frReport.Clear; fr := TfrReport.Create(self); try for i := 0 to High(ARowIds) do begin // ARowIds := [100, 101, 102] fr.Clear; fr.LoadFromFile('report.frf'); frVariables := ARowIds;//this is RECORD_ID fr.…
  • Thanks Gord, I think the 2nd method will work for me. Is it possible to change SQL property of Query placed on frReport's DialogForm from Delphi code? Something like this: obj := frReport.FindObjectByName('MyQuery1'); obj.Sql.Text := 'select …
  • hmmm... still no answers...