gordk
gordk
About
- Username
- gordk
- Location
- St.Catherines On. Canada.
- Joined
- Visits
- 0
- Last Active
- Roles
- FR Team
Comments
-
try using page and totalpages the system variables with # are for batch reports.
-
in the third memothird memo [( - )]
-
use a summary band and write code in its obp event to drive it down. you can do that with any other footer band. procedure ReportSummary1OnBeforePrint(Sender: TfrxComponent); begin if engine.freespace > reportsummary1.height then begin …
-
a page footer band is just that a page footer. it's objects are the last output to the finished page. it is not stretchable. you can use other footers or child or summary bands before the page footer.
-
parameterize your query Assuming you are using internal data components. in the parameter edito select the parameter type and in value box point it to the dateedit. Look at the main demo internal datasets reports.
-
I am not a c coder but i will try to shed some light on passing string values into categorized variables. A categorized variable is treated as an expression unless the string value is enclosed in string delimiters once inside the report (it then t…
-
the rtf object only imports the formatted text it does not support line drawing.
-
procedure DialogPage1OnActivate(Sender: TfrxComponent); begin dateedit1.date:= now; end;
-
make sure that windows is not blocking the file. acess file properties through explorer and unblock
-
the iif function is for use inside a memoview IIF([DatasetName."FieldName"]=1,'true','false') bad syntax [IIF( =1,'true','false')]
-
you can at runtime sample delphi form code procedure TForm1.Button4Click(Sender: TObject); begin frxreport3.Clear; frxreport3.OnBeforePrint := nil;// disconnect unwanted events frxreport3.OnAfterPrint := nil; frxreport3.LoadFromFile(wpath+'va…
-
queryname.close; sample query select * from customer where custno = :p1 in the params editor set the params datatype and point its value to a variable. in code close query set the variables value open query. see sample report in main demo u…
-
what version and build# of fr i can't reproduce here d14, fr4.9.99 your code runs fine.
-
yes but not the query of the current dataset.
-
it will depend upon where you are doing it which event of which object Pete's suggestion tries to concantenate strings. you can use the value property of a memo but be careful as it is the value of the last processed expression in the memo. anot…
-
if you set these values in the dialog from selecting print in the preview window just select print again
-
Steve you are only changing the visibility of the object not its position on the output page. the report engine processes from top down by band type and left to right in the band in order the objects were created, you therefore cannot modify an ob…
-
have you read the user's manual chapter on exporting and designRefrences.
-
use overlay band plus text object or background image of page.
-
grouping is designed to work with one query across several tables, using an orderby clause returning all data required. sample is nested group report in main demo. need more info about your report what band is subrep located on? are you using…
-
overlay is one per design page it prints on every output page. name is somewhat misleading as it is more of an underlay and is processed first.
-
if you want the object to appear on every page produced use an overlay band. tip when using overlaybands use largeheight in design mode and place overlay after all other bands.
-
set the allowsplit property of the band also.
-
in a memoview you are only allowed one set of [] braces per expression they must be first and last.
-
here is a sample before begin end. block of report code var i: Integer; ds: TfrxDataSet; list: TStringList; this may be used in any procedure ds := Report.GetDataset('frxDBDataSet1'); // the username of the ds list := TStringList.Create; …
-
ds1, ds2, ds3: TDataset; should be ds1, ds2, ds3: TfrxdbDataset;
-
your .fr3 file is giving me a bad format error. please when you attach files either zip or rar them before attaching.
-
i'll take a look later today or tomorrow. BTW when you post in the news groups post in the correct news group or your message may never be seen. The binaries ng is for large files demos from all news groups etc. You place those files in the binar…
-
you can use begin end blocks just like in delphi begin if (SUM() > 0) then begin line1.frame.color := clRed; line5.frame.color := clRed; end else begin line1.frame.color := clBlue; line5.frame.color := clBlue; end; end; but you…