Empty records

Comments

• borut

  March 2004 edited 11:47AM

  Why nobody anwser my question? I realy need help!
  
  Thx
• gordk St.Catherines On. Canada.

  March 2004 edited 11:47AM

  hi
  trying to understand what you are trying to do.
  build your expression using expression builder it will help you get syntax and correct bracketing.
  are you tring to swap strings or test for a value
  either way the first part of the expression will be true for all recs
  where Table1.Id_partner = 11 wether or not other fields contain data
  regards
• gordk St.Catherines On. Canada.

  March 2004 edited 11:47AM

  here is a couple of examples
  
  mytestv var in dictionary expression to sub 1 datafield for another
  
  IF([CustomerData.Orders."AmountPaid"]<> 0.00,
  [CustomerData.Orders."PaymentMethod"],
  [CustomerData.Orders."Terms"])
  
  expression to sub a string in place of a data field
  
  IF([CustomerData.Orders."AmountPaid"]<> 0.00,
  [CustomerData.Orders."PaymentMethod"],
  'unpaid')
  
  regards
• borut

  March 2004 edited 11:47AM

  Well I'd like to achieve, that those records which do not match criteria aren't shown (like a filter). I would use a filter, but on one report different filters should be used. Example:
  - on Band1 i d like to show records from Table1 where id = 2
  - on Band13 i d like to show records from Table1 where id = 11
  - on Band22 i d like to show records from Table1 where id = 14
  - ...
  
  thx
• gordk St.Catherines On. Canada.

  March 2004 edited 11:47AM

  Hi change your thinking
  A band is only a place holder on a design page,it instructs the reportengine where to place the objects,(memos,shapes,etc.) that fall within its bounds. master,detail,subdetail bands require a connection to a dataset, either frdbdataset,fruserdatasetmor a virtual dataset of n records, the dataset instructs the band to repeat the number of times(recordcount)of the table or query to which it is connected, and moves the cursor of the table/query as required. the actual connection to the data to be displayed is through the datafield inserted in the memo.
  The report engine does NOT do sorting. you must supply sorted data to it, either by filtering, presorting, or by running a query with an orderby clause which places the fields in the order on which you want them sorted.
  Do NOT think of an mdband detailband subdetailband as a master detail relationship between tables but as data of firstl level , 2ndlevel,3rdlevel, on the designpage. how you connect the tables is up to you.
  hope this helps you understand it.
  regards
  
• borut

  March 2004 edited 11:47AM

  Thx I've solved the problem...But here is another one:
  
  I have a Band with fixed height and width.
  On this band there is a memo, which is filled with values programaticly from C++ Builder (Memo1->Memo->Text = "Blabla..".
  Memo1->Streched = true.
  I'd like to achive that if text in memo exceed the height of Memo1(Memo1->Height = Band->Height), size of the Font is decresed (to the size of font, which will fit in memo). Any help would be appriciated.
  
  Thx in advance.
  Borut
  
• gordk St.Catherines On. Canada.

  March 2004 edited 11:47AM

  hi itisually easir to just strech the band but since you are passing in the text any way do your calculations out side and set the font accordingly.
  use findobject method after loading report, retrieve size of the object then set the properties.
  regards