question

Peter-Nolan-IBI avatar image
0 Votes"
Peter-Nolan-IBI asked Peter-Nolan-IBI answered

Custom functions not working in group levels in

![75937-a01-report-services-error-01.jpg][1] [1]: /answers/storage/attachments/75937-a01-report-services-error-01.jpg One last problem. Where I have drills on reports the group levels are not formatting according to the custom functions being used to colour the text and set the fonts. If I set the color to red the text will come out red. Is there any known problem with report where the calls to custom assemblies does not work for the group level headings? I am guessing it is an upgrade bug. Thanks and Best Regards Peter

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Peter-Nolan-IBI avatar image
0 Votes"
Peter-Nolan-IBI answered

Hi Lukas,

sorry. I have been busy working on the migration of these reports and doing video demos for them.

My apologies for not answering sooner.

I published a post which includes all the source code here: http://www.instantbi.com/2021/03/09/bi4all-008-report-services-reports/

The source code is here: https://www.dropbox.com/sh/0m9rtgvbivg2z0b/AAA1IR66zRYm_yxIPLpXnSTia?dl=0

The custom assembly works at the old 2005 level and it works for everything except the group heading level colouring / fonts that is in the small picture.

This is what makes it so strange.

Yes, I could set the colours , fonts etc inside each report.

But the way the reports have been written is to be used as an example of how to implement RS for customers. They were demos we created back in 2006.

So I would like to solve the problem rather than to work around it. Ok?

With the source code published anyone can take a look. :-)

Best Regards

Peter

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Peter,

Thanks for the sharing of workaround. Unfortunately the video is not accessible for now. (or maybe it is caused by my network I will check it later.)

I'd like to convert this comment as an answer, since it is a solution to this issue.

0 Votes 0 ·
LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered LukasYu-msft converted comment to answer

How have you set the color and font ? What kind of function have you used?

If the customer assembly is not working , could you write the code in the report definition and run the functions directly in the report?

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,

We have not heard from you back? Did you resolve your issue ? If not, we are waiting for your feedbacks on clarifying the question. :)

0 Votes 0 ·

Hi Lukas,
Thank you for following up. No, I have not solved the issue. And I have now published the source code and the video demonstrations. So perhaps someone has seen this before.

I can't imagine no one has ever seen this error before.

Best Regards

Peter

0 Votes 0 ·