Has anyone run into a case where in InfoAssist the Repeat So...

[NYCBabak .]

Could you provide an example with sample data

[Debra Waybright]

I havent been able to recreate the issue with the CAR file.

[NYCBabak .]

So, it involves only format XLSX and AHTML and the COMPUTE has to have values where LAST value is the same as current rows value. This appears to be a very specific scenario. I havent seen anything like this so opening a tech support ticket might be the best way to go. However, just as a test, are you able to run the same code on the Reporting Server (eliminating the client) and see what you get If this behavior doesnt reproduce on the Server, that may mean your client is causing an issue. Have you tried adding a SET BYDISPLAY= ON or ALL or ACROSS to the beginning of the .fex to see if that makes a difference

[Debra Waybright]

I looked at the report a little closer (it isnt one I wrote). The first BY column is actually NOPRINT and when it is repeated, the BYDISPLAY=ON is not working. I dont think it has to do with the compute column because when I removed that, it was still not working. Removing the NOPRINT from the first BY column didnt fix it either.

[NYCBabak .]

Try SET BYDISPLAY=ALL. if you have ACROSS also try SET BYDISPLAY=ACROSS. Does it work if you run the code on the reporting server

[Debra Waybright]

I tried that. It still didnt work. No ACROSS. Running via Console on Reporting Server it works (or rather doesnt work) the same.

[NYCBabak .]

Time to call ibi tech support but at least you have a lot of additional knowledge to provide them to review.

[Debra Waybright]

I figured Id end up there. Thanks for your help.

[Debra Waybright]

Has anyone run into a case where in InfoAssist the Repeat Sort Value selection is not working correctly Looking at the generated code, it does have SET BYDISPLAY ON. But Im seeing in the output where the first columns data is not repeated if the compute columns data is the same as the row prior. It does this in both Excel and Active Report outputs.

I probably have to open a case but I thought Id post here first.

Thanks,

Deb

WF 8.2.03M

Windows/Chrome

[Toby Mills]

Hi Deb

Just wondering about a fixed problem I found:

[bYDISPLAY does not work with BY TOTAL]

A report that has BYDISPLAY ON is suppressing repeating BY values

when BY TOTAL is present.

Any chance this is your mystery thing

Found that here:

https://techsupport.informationbuilders.com/ptf/wbfs/wbfs_fix_med_7709_server.html

3 cases reported with this problem.

Fixed in 7709/8205

In any case, this one is interesting to me too - please let us know if / when you find out whats going on there.

Thanks!

Toby

[Debra Waybright]

Toby, you are wonderful! Thats it. There is a BY TOTAL and we are still on 8.2.03.

Thank you!

[Toby Mills]

Thats great Deb - of course its not great that youre still stuck there, but at least you know what it is. Maybe you can come up with a workaround now that we know what the deal is.

Thanks!

Toby