Default Avatar

Petter S.

Petter S.

About

Username
Petter S.
Joined
Visits
0
Last Active
Roles
Members

Comments

  • Hi. Possible reasons: * Property 'Allow expression' set to false * Property 'ExpressionDelimiter' set to other than '[,]' Petter
  • Hi. I would have tried: group1.condition := ' + '; The code should be executed before the grouping starts, so the main begin-end would be a good place to put it. Petter
  • Hi. A couple of things I didn't notice at first: - In my FR I must use ',' between statements, not ';' (in your exemple you have one ',' in the second IIF...), and '.' as decimal point. Maybe this can be set up somewhere - i don't know... - if …
  • Hi. The message says: " ')' expected". As far as I can count you have 15 left braces, and just 14 right braces. So I would guess that one more ')' should do the trick.
  • seafea wrote: » An alternate solution I've already had working before would be to get the date from the user on a dialog page that's shown before the report is displayed, but that's not ideal in this situation. Hi. Have you considered: …
  • Hi. I think the IIF wants single quotes, not double: [IIF( < , - ,'0.00')] Petter
  • Hi. Instead of making a Delphi-side user function, you can simply put your function in the code of the report, before 'begin'. The function then can be used inside the report both in code and in MemoView's. In a MemoView you can put something …
  • ReinaldoCrespo wrote: » Is there any way to avoid having the databand advance the object? Hi. Try setting the databand.height to 0. Can be done by code in the databand's OnBeforePrint if you want to keep your dot visible in the designer…
  • sorinh wrote: » I use the basic sintax "iif( = True, frdbBillBPay.Text := 'Yes', frdbBillBPay.Text := 'No');" The IIF can be used in the MemoView, not in event script. In the memo you can put something like: [iif( = True, 'Yes', 'No')]…
  • Hi. The 'Round' does not take parameters in FR. How about trying something like this: [round(SUM()*100)/100] I don't think that it is esasy to calculate directly from what is inside a memo. I think you should try to use whatever is the sour…
  • Hi. You can group your data in SQL, or in the report. I suppose you are not able to use sql? In the report, here is how it can be done: Drop 5 bands on your report: - 1 x page header - 1 x masterdata - 1 x group header - 1 x group fo…
  • Milan Mehta wrote: » Can someone help me in the matter ? Help will be highly appreciated as this is a burning issue for us. TIA Milan. Hi. This pascal function seems to work: function IndianFormat(s: String): String; var   s1: S…
  • Hi. You might try to use clipped = true in designtime, and then set it to false by code when the report is executed. Petter
  • Hi. If your data comes from a query, you should be able to do this in the main code area of the report: MyQuery.Open; MyQuery.First; If MyQuery.EOF then   Memo8.Visible := True                                 …
  • You can modify the PageFooter.visible in its OBP-event: procedure PageFooter1OnBeforePrint(Sender: TfrxComponent); begin if = then PageFooter1.visible := true else PageFooter1.visible := false; …
  • dschuch wrote: » Yes, i use a bad word now: WTF. For MANY MANY years people are asking for a usefull PDF export now. Our customers are beginning to kill us because of the worse pdf export. Say a price and we pay for it. Our most important cu…
  • IIF( <> Null, Format('%n', []), '')
  • Hi. I think you should be able to use the 'Format'-function inside the IIF. Petter
  • felipeiw wrote: » I had tried this way but it does not work, for example, a report of 3 pages he imprimie 2/1, 3/1, 4/1 and 5/1, that is not the total pages. You have to enable 'DoublePass' for the report EngineOptions to get the TotalPages…
  • felipeiw wrote: » and to make the same amount in [TotalPages#] ? Yes, [ + 1] or [ + 1] Petter
  • Instead of modifying the page number itself, you can modify the output in you memo: [ + 1]. Petter
  • Hi I have not seen any problems with the page space with this method i my projects. Attached you will find a sample report with 3 childbands, where all of them have their visibility and height set by random, leaving no extra space. (There i…
  • Hi. If I understand you correct, each subreport prints only one record, and the data source is the same as the main masterdata? And the reason why you use subreports is that you want to hide them conditionally? I so, I would consider not to u…
  • Spielhallen_Frank wrote: » There is no OnGetValue-event to choose on Memos, DetailData, MasterData. Sorry about that. I meant OnAfterData-event. And then, the value only returns what comes from fields or variables inside the memo, not from…
  • Spielhallen_Frank wrote: » Hello all, i have got plenty memos with float values in it. I need to add these values. ShowMessage(FloatToStr(Memo1.Value)) gives an empty Message back. XY := StrToFloat(Memo1.Text) gives an error back (xx,xx is a inv…
  • Try this: [IIF( <> '', + chr(13) + , )]
  • If you know at design-time how to modify the fonts inside the memo, you could look into the RichText Object as an alternative to the Text Object.
  • Hi. A page footer will print in fixed position, depending on the page's bottom margin. A masterdata band will move to new page when there is not room for one more in the current page. So, you can try one on these alternatives: - ajust bottom…
  • Felipe Pucci wrote: » i have to do a list of payments with many clients but i have to put the total value received at the last row of the client, but i can't use the group footer because it adds one more line. i just want to show the total value…
  • rommel wrote: » THANK YOU VERY MUCH FOR THE ANSWER.. FOR WHEN FR5?, DO YOU KNOW? Have no idea. I love FR, but waiting for Fr5 gives me flashback to the dying of Rave, where everyone was waiting for ?? new version that never came... We ha…