Empty records

borut

Hello!

I have a variable (in data dictionary) which is expression (if(Table1.Id_partner) = '11'),Table1.Description)). I place this variable on master band, but also empty records (those where Table1.Id_partner != '11') are shown.

Thx in advance

Borut
Slovenia

borut

Why nobody anwser my question? I realy need help!

Thx

gordk

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

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

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

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

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

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