Comments

• You can't to use macros in ADOQuery (TADOQuery doesn't support macroses), you can build SQL statement or use parameters only

  in How to pass the "where"of a query as a parameter / variable Comment by gpi January 2011
• Set parGiorno value to 'LUNEDI' instead of LUNEDI

  in How to pass the "where"of a query as a parameter / variable Comment by gpi January 2011
• IIF function doesn't declared in FS. You must declare it in FS

  in IIF function Comment by gpi January 2011
• Attach a sample with problem based on FRDemo database

  in [ask] how to suppress repeated values in subreport ?? Comment by gpi January 2011
• And comment your code procedure MasterData1OnBeforePrint(Sender: TfrxComponent); begin    //AdoQuery2.Close;    //AdoQuery2.Open;       end;

  in blank pages Comment by gpi January 2011
• Try to set permission for full access for all users for Fast Report 4 folder

  in Problems during the installation of Enterprise Rave Comment by gpi January 2011
• Did you run installer as administrator?

  in Problems during the installation of Enterprise Rave Comment by gpi January 2011
• Try to use Select from Select statement This SQL works OK in MS Access Select * from (SELECT tab1.id*3, tab1.id , tab1.name FROM tab1) order by 3 wrote: (I find it rather amazing that FR does not support sorting, especially as it does in c…

  in Sorting rows? Comment by gpi January 2011
• All works OK. See a test report template in attach

  in [ask] how to suppress repeated values in subreport ?? Comment by gpi January 2011
• Try to set MasterData1.StartNewPage to False and set ADOQuery2.Master to ADOQuery1

  in blank pages Comment by gpi January 2011
• FR can't to sort datasets Try to use (SELECT cumulativeAttendance FROM tbl_attendance AS T WHERE t.weeknumber = 14 AND t.Adno = tbl_attendance.adno ) - (SELECT cumulativeAttendance FROM tbl_attendance AS T WHERE t.weeknumber = 15 AND t.Adno = tbl_…

  in Sorting rows? Comment by gpi January 2011
• wrote: No response on this? I have to make a decision on the purchase and I would, thank you. Why you ignored second post from stefque?

  in How to pass the "where"of a query as a parameter / variable Comment by gpi January 2011
• Try FORMATFLOAT('00',) +'-' + FORMATFLOAT('0000',)

  in Group header multivalue Comment by gpi January 2011
• You may create child band, copy all objects from header to child band and show child band when you need with Engine.ShowBand command in script

  in Print Detail Hedaer, if Detail Data is Empty Comment by gpi January 2011
• Also you can use script variables instead of report variables

  in Problem with a string variable from delphi Comment by gpi January 2011
• See a Programmer's manual: wrote: 1.9 Building a composite report (batch printing) In some cases it is required to organize printing of several reports at once, or capsulate and present several reports in one preview window. To perform this, t…

  in Merge reports Comment by gpi January 2011
• Hello, You may use Engine.ShowBand and show any band when you need For example: procedure PageHeader1OnAfterPrint(Sender: TfrxComponent); begin      if MasterData1.Dataset.RecordCount = 0 then Engine.ShowBand(Header1); end;

  in Headers not showing Comment by gpi January 2011
• Try if engine.freespace < GroupFooter1.Height then   Engine.NewPage; Engine.CurY:= Engine.PageHeight - GroupFooter1.Height - 1;

  in Position of the band Comment by gpi January 2011
• Try diadatamodule.AppSrvClientGeneral.Answer.GetStreamField(2,reportdata,fldtype); reportdata.Position := 0; frxReport1.PreviewPages.Initialize; frxReport1.previewpages.LoadFromStream(reportdata); frxReport1.ShowPreparedReport;   frxReport1.Previe…

  in View .fp3 file on remote system Comment by gpi January 2011
• No

  in Sorting dbcross by grandtotal Comment by gpi January 2011
• See Programmer's manual "1.12 Creating a report form from code" chapter

  in Barcode Tag Editor Comment by gpi January 2011
• Use TfrxOverlay band

  in water mark Comment by gpi December 2010
• You can resort preview pages after preparing of report: var i, j: integer;     page : TfrxReportPage; begin      frxReport1.PrepareReport();      j := frxReport1.PreviewPages.Count div 2;      page := TfrxReportPage.Create(nil);   …

  in Help, About FR4 Muti Pages Report.... Comment by gpi December 2010
• Try procedure TForm1.frxReport1PrintReport(Sender: TObject); var i, Copies: integer;     ShowDialog: Boolean; begin      if frxReport1.PrintOptions.Copies > 1 then        begin          Copies := frxReport1.PrintOptions.Copi…

  in Both sides printing Comment by gpi December 2010
• // Using:    conv := TConverterQr2Fr.Create;    conv.Source := QuickRep1;    conv.Target := FReport;    conv.Convert;    FReport.SaveToFile('converted_fromQR.fr3'); wrote: What is converted the bands, database-interface, scripts an…

  in From QuickReport to FastReport Comment by gpi December 2010
• You may store variable in script variable and print this variable on group footer var MyLine: integer;    procedure GroupHeader1OnBeforePrint(Sender: TfrxComponent); begin      MyLine := ;                           …

  in Group Header count Comment by gpi November 2010
• See a test report template in attach

  in Change colors series Chart Comment by gpi November 2010
• Try to use: Chart1.SeriesData[0].Source4 := 'clGreen;clRed';

  in Change colors series Chart Comment by gpi November 2010
• Attach your report template (fr3)

  in fix picture on verso Comment by gpi November 2010
• Try to use (for Adobe Reader for example ) TfrxOLEView(frxReport1.FindObject('OLE1')).OleContainer.CreateObjectFromFile('C:\test.pdf', False);

  in Working with OLE containers Comment by gpi November 2010
More Comments