Nagornyi will it work for Tabular!!

[saketbansal]

Hi nagornyi

I am not perfect in report.

AS abezuide asked for supressing NULL column in form tyope report
Will it work for tabular type report

Field A Field B Field C
------- ------- -------

If field B column is NULL for all rows then HIDE ,Supress the space of this column and Field C should display at the position of Field B

I was trying to make repeating frame around the existing filed in Layout model which was already in default Repeating frame.But i am not bale to see this filed to be transferred in the new created repeating frame in oject navigator window Tree.It exists under the old repeating frame.
After creating rframes for all field Should i write format trigger also on fields and frames?
Should i delete the default repeating frame in which all field are enclosed?
Should i make Horizontal variable of frames and fields?

Thanks!

 

[nagornyi]

Make the horizontal elasticity of all three fields variable, for the Field B enter in the format trigger between begin and end:

if :field_B is null then return false;
else return true;
end if;

Replace field_B with its real name as in the Source property

 

[saketbansal]

Thanks

U are a Star** Yaa it works

Now i made new fileds manually and repeating frame for each.
But i am not able to place existing fields which are in default rFrame in layout in a new repeating frame.

 

[saketbansal]

Hi

I have to make repeating frame for each fields and set the horizontal elasticity to variable of frames

It works for fields but now problem for heading display:-

My headings are in simple frame.Now i want to supress the heading label also when the field is supressed.And the label should also get shifted as the field shifts

Thanks!

 

[nagornyi]

Create report level summary field that would assume the maximum of field B. Then repeat the same trick with labels as with fields, but in the format trigger instead of field B use the summary field.

 

[saketbansal]

Sorry
I am not able to understand the use of summary field in hiding the label for null column.Please explain I am new in report.

And in my report there are 30 columns out of which 10 can be null
I can hide and shift the null columns in tabular report by using repeating frame for each field.And verti elasticity to variable.
But not able to shift their labels.

This report will be substitute of my matrix report which i asked u.

Thanks!

 

[nagornyi]

OK.
To shift fields you created format trigger for the field B. In the format trigger you used the name of field B putting it with the column after IF. Now you need to do the same with labels. You will have to create format trigger for the middle label. But instead of field B name, you will use the name of the summary you created, otherwise the trigger body will be the same.

 

[saketbansal]

Yes

I can hide the label with sumarry field.But for one column
As i set it's source to field B.

As i wrote i have 30 columns then i will have to make 30 sumarry columns for supressing the labels.Because any number of columns can be null out of these 30 columns.

Thanks for ur quick reply...

 

[saketbansal]

Hello

Sir i did the hiding of label also but no sumarry field used .
In format trigger of label I write the select staement and get sum or max of filed in varaible and check the value if null then return false else return true

Is it right way ?If any other way then please tell?

Thanks!

 

[nagornyi]

That's fine. You did the summaty manually right in the format trigger. More coding, but OK. So you solved your problem now?