Reports (Page 2 of 2)

Thank you Adam for the full size images. I am certainly not an expert when it comes to record level images whether they are stored in the database or linked externally. I don't typically work with them. But for my own edification I did some research in the forum and found the following project from Dimitry where you can link an image in a report through a script. I went ahead and updated your project with the same type script.

http://myvisualdatabase.com/forum/misc. … download=1

Something I learned (at least I think I learned) when it comes to defining images externally (LinkFile).  Apparently, you still define the image in the table, but it is never loaded (null) and you define another field for the actual image file name. It's kind of awkward. The calculated field in the table kind of threw me.

Sorry Adam, I could not replicate the error. It works fine for me.

Adam,

The report was built using the "ReportSQL". I adjusted the "Report" to print the same invoice format. There are two reports 1) Invoice.fr3 and 2) InvoiceSql.fr3. Each report button will run it's respective report.

Attach your project Adam and I'll take a look at it.

Adam, Fixed project is attached. In your project the notes memo field was memo20 not memo24. ReportNotes is a text field so ReportNotes.value should be ReportNotes.text.

I'm having reports blues again......

This time I'm trying to create a report for "SaleTransHist"
On "SaleTransHist" repeating values are hidden or replaced with value zero for easier reading and avoiding incorrect sums on tGrid footer.
Unfortunately, fast reports gets repeating values, therefore having duplicates and wrong sums in the report.
I tried workaround by copying column tGrid footer values those applying to per invoice not InvItem (Discount, Delivery and Inv Totals) but couldn't get those values displayed in fast reports?

Please see images below for additional reference:

Sample is project attached. FR file "SalesTransHist.fr3" in the reports folder:

Hi EHW,

Thank you very much...................

Your approach is much better than mine. Taking out repeating fields to group header makes reading clearer and easier. Nice one..... Appreciated.......

Another wall I hit on FR......

I have a memo field with multiple pages of text. On report designer, I cannot get it displayed beyond first page. Tried different bands, stretch, set clipped to false but no luck.

Please see the attached sample projects:

AD1408
Hello.

For component Reportnote set property StrechMode = smActualHeight

for MasterData1 set property Stretched = True

I have an Invoice report. I like to change color of two fields in Fast Reorts depending on field 1 value.

Field 1. DbCr with 2 values (ReportDbCrdbcr)
Sale
Refund

Field 2. Fast reports text field (Memo1)

In Fast reports script editor I need the following script please.
----------------------------------------------------------------------------------
If Field 1 value is  'Sale' then Field 1 and Field 2 text color =clBlue

If Field 1 value is  'Refund' then Field 1 and Field 2 text color =clRed

The following didn't work?

procedure ReportDbCrdbcrOnAfterData(Sender: TfrxComponent);
begin
  if DbCrdbcr.text := 'Sale' then
  begin              
  DbCrdbcr.textColor := clBlue;
  Memo1.text := clBlue
  else
  if DbCrdbcr.text := 'Refund' then      
    begin
    DbCrdbcr.textColor := clRede;
    Memo1.text := clRede
    end;              
end;

Hi EHW,

Thank you very much...........
Truly appreciated........

I had to take out  Report word from ReportMemo1 to get it working. I guess it was because memo1 wasn't db field, just a label in Fast reports. The following worked for me thanks to your kind help:

if trim(ReportDbCrdbcr.text) = 'Sale' then
  begin              
    ReportDbCrdbcr.font.Color := clBlue;
    Memo1.font.color := clBlue;
  end else    
    begin
     ReportDbCrdbcr.font.Color := clRed;
     Memo1.font.color := clRed;
    end;