NYCBabak . Posted September 4, 2020 Share Posted September 4, 2020 Could you provide an example with sample data Link to comment Share on other sites More sharing options...
Debra Waybright Posted September 4, 2020 Author Share Posted September 4, 2020 I havent been able to recreate the issue with the CAR file. Link to comment Share on other sites More sharing options...
NYCBabak . Posted September 4, 2020 Share Posted September 4, 2020 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 Link to comment Share on other sites More sharing options...
Debra Waybright Posted September 4, 2020 Author Share Posted September 4, 2020 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. Link to comment Share on other sites More sharing options...
NYCBabak . Posted September 4, 2020 Share Posted September 4, 2020 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 Link to comment Share on other sites More sharing options...
Debra Waybright Posted September 4, 2020 Author Share Posted September 4, 2020 I tried that. It still didnt work. No ACROSS. Running via Console on Reporting Server it works (or rather doesnt work) the same. Link to comment Share on other sites More sharing options...
NYCBabak . Posted September 4, 2020 Share Posted September 4, 2020 Time to call ibi tech support but at least you have a lot of additional knowledge to provide them to review. Link to comment Share on other sites More sharing options...
Debra Waybright Posted September 4, 2020 Author Share Posted September 4, 2020 I figured Id end up there. Thanks for your help. Link to comment Share on other sites More sharing options...
Debra Waybright Posted September 4, 2020 Author Share Posted September 4, 2020 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 Link to comment Share on other sites More sharing options...
Toby Mills Posted September 7, 2020 Share Posted September 7, 2020 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 Link to comment Share on other sites More sharing options...
Debra Waybright Posted September 8, 2020 Author Share Posted September 8, 2020 Toby, you are wonderful! Thats it. There is a BY TOTAL and we are still on 8.2.03. Thank you! Link to comment Share on other sites More sharing options...
Toby Mills Posted September 8, 2020 Share Posted September 8, 2020 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now