Share via

Custom functions not working in group levels in

Peter Nolan 1 Reputation point
2021-03-09T17:46:40.067+00:00

![75937-a01-report-services-error-01.jpg][1] [1]: /api/attachments/75937-a01-report-services-error-01.jpg?platform=QnA 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
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,848 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,816 Reputation points
    2021-03-10T02:06:02.07+00:00

    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. Peter Nolan 1 Reputation point
    2021-03-13T19:03:43.397+00:00

    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