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 …
-
thanks
-
hmmm... still no answers...