Default Avatar

gordk

gordk

About

Username
gordk
Location
St.Catherines On. Canada.
Joined
Visits
0
Last Active
Roles
FR Team

Comments

  • assuming your query is internal to the report parameterize your query use an fr dialog with 2 dateedits, 2 buttons and set the params of the sql to the dateedits. if your query is external then you must create your own dialog outside of the repor…
  • EccoBravo wrote: » Many thanks, but Your efforts are without of success, unfortunatly. Now I'm looking for another solution, printing a lot of *.bmp-Pictures into a NoDatabaseReport. Should it possible to load the *.bmp-Pictures in the De…
  • procedure Picture1OnBeforePrint(Sender: TfrxComponent); begin picture1.loadfromfile(trim(memo1.text)); end; works fine if the memo contains [datasetname."fieldname"]
  • since memo1.text is all the text of the memos array of lines. you need to use the trim function to strip any leading or trailing spaces. picture1.picture.loadfromfile(trim(memo1.text)); this will work if memo1 contains text like c:\logo.jpg and …
  • Yes see the main demo "urls anchors report" under other features
    in Hyperlinking Comment by gordk March 2010
  • there does seem to be a bug when passing values to loadfromfile or to filelink property will get back to you. the reason you only see the expression that is in the memo view is that is what is there before it is handled so use the oadevent of the…
  • you drop the exportcomponent from the delphi palette on to your underlying delphi form then the exports are available in the preview menu bar. if you are trying to run from code no dialogs typicaly frxreport1.loadfromfile('path&filename"); …
  • The info you are refering to is for .net what product are you trying to work with Fr4.# for delphi ?
  • before calling load call the clear method also you may find problems when using the form create event may be better to use form show
  • Picture1.Picture.LoadFromFile('fullpath&filename;) requires a string and needs string delimiters so build your string correctly Picture1.Picture.LoadFromFile('+(Memo1.Text)+'); or Picture1.Picture.LoadFromFile('+(vartostr(Memo1.value))+');
  • you dont have it set printoptions collate to true. connect the tfrxreport component dataset to the dataset which will control the number of times the report is run.
  • read the user manual report design references about what happens when exporting overlapping objects.
    in alignment Comment by gordk March 2010
  • template report must be located in the designers template directory.
  • look at the main demo basic reports nested groups. it relys on one joined query accross multiple tables to return all the data required the orderby clause of the query is ordered by the order of the conditions in the group headers.
  • read the user manual displaying database fields with the help of the text object [varname][datasetname."fieldname"]
  • here is problem The properties of the tfrxMemoView regarding the format is Number %2.2n and DecimalSeperator '.', ThousandSeparator ',' %2.2n gives the delphi format which is system reliant. use a custom format string.
  • code is still the same should be no problem. check to make sure you have enough string delimiter's. around your string variable value
  • what you are trying to lay out does not make sense using a group header footer the output of a grpheader masterdata grpfooter results in repetition of the masterdataband as many times as there are records that match the group criteria of the heade…
    in Page Copy Comment by gordk March 2010
  • if it has not been fixed already. go to your fastreport 4\resource\German folder open the xml files in wordpad and replace any english strings with german then recompile using frs recompiler. it is probably in frclass.xml.
  • To save: stream := TMemoryStream.Create; TfrxReport.SaveToStream(stream); stream.Position := 0; (dataset.fieldByName('my_blob') as TBlobField).LoadFromStream(stream); To load: stream := TMemoryStream.Create; (dataset.fieldByName('my_blob') …
  • you must get the query to return the correct sorting fr only presents the data sent to it.
  • where did you try to convert it to numeric.
  • what is the underlying data type of the telephone field,(String I'll bet) you are expecting a numeric sort on a string can't do must convert string value to numeric first.
  • what is your display format setting?
  • see my reply in the news group.
  • the function you were given previously works fine what don't you understand about using it?
  • if your masterdataband is always the same height you will have a set number of records after which you need the band. instead of a column footer use an unattached childband and write code to use the engine.showband(bandname) method in the oap even…
  • use the decodetime function to decode the time into its parts inthe obp event of the pictureview write code to check the value and set the visible property.
  • you should be posting in the correct forum in future. this is for the old fr2. turn off show dialogs typical code to load report set all properties of export component call preparereport frxReport1.Export(frxHTMLExport1);
  • Can't be sure of what you are trying to explain. the tfrxreportcomponents dataset property is ony used with multiple design page reports. it controls the number of times a report is run. usually your masterdataband's dataset property points to …