Focal Point
[CLOSED] Limit of BY Fiels in a report

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2947005695

January 06, 2011, 09:05 AM
ChristianP
[CLOSED] Limit of BY Fiels in a report
Hello,

i have a general question. Is there a limit of BY Fields in a report.
in my actual report project, i can not add additional fields. i do not get
an error message, the fields are just not populated.

christian

This message has been edited. Last edited by: Kerry,


WF Production Version: 7.7.02M
WF Test Version: 7.7.02M
Developer Studio: 7.7.02
HTML, EXL2K, FLEX, PDF,PPT
January 06, 2011, 09:17 AM
Prarie
Yes there is a Limit...I think it's 30 or 32.
January 06, 2011, 10:21 AM
FrankDutch
What you might be able to do is concatenate some of the "logical fitting together" by fields

for example if you have a client_ID and a client_name and a client_adres you can create a string that holds the 3 fields and you win 2 by fields




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

January 06, 2011, 03:37 PM
Waz
How many do you have, and what versio are you on ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

January 06, 2011, 03:41 PM
GamP
I seem to remember that the old limit of 32 has been increased. If I'm not mistaken it might even have gone up to 256.
Which reminds me that I really should start reading those snf's. Red Face


GamP

- Using AS 8.2.01 on Windows 7 - IE11.
in Focus since 1988
January 06, 2011, 04:14 PM
Waz
Your right, it did.

That is why I asked which version, and how nay fields.

Seems 7.6.5 has a limit of 32.
And 7.7 has 128.

Can't find any mention of increases in between.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

January 06, 2011, 04:34 PM
Prarie
Good news to know.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
Thanks a lot!!! i use the 7.6.8 Version for this report an after 32 BY fields the report ignores additional BY,s.


WF Production Version: 7.7.02M
WF Test Version: 7.7.02M
Developer Studio: 7.7.02
HTML, EXL2K, FLEX, PDF,PPT
Then you will have to use Franks suggestion of concatenating fields to reduce the number of BY's.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code