SSRS chart with hint on series results on mouse over graph in "Parameter is not valid"

Rutger Laarveld 1 Reputation point
2020-09-30T14:14:42.1+00:00

I have a very strange problem when I set the tooltip (hint) in the Series properties of a line that includes Environment.NewLine (in all different formats) and even spaces (" ") and other tekst to the different field values. When I preview the report the graph is shown:
29395-image.png

However when I move the mouse over the chart I get an message: "Paramter is not valid":
29396-image.png

However if i change the tooltip hint to show every field in one line (without dividers) the report and the hint works fine:
29451-image.png

I have tried all kinds of dividers and different types of charts... The line series uses =iif(isnothing(Sum(Fields!cumsum_mass.Value)),0,Sum(Fields!cumsum_mass.Value)) expression to show a continuous line per material.

Does anyone have an idea how come?

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.
3,061 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Rutger Laarveld 1 Reputation point
    2020-09-30T14:19:09.927+00:00

    I changed the chart type to "Line with markers" and now it seems to work with dividers... So my question seems answered!

    0 comments No comments

  2. ZoeHui-MSFT 41,491 Reputation points
    2020-10-01T02:18:38.45+00:00

    Hi @Rutger Laarveld ,

    Glad to hear that the issue has been solved by yourself.

    You may "Accept Answer" so that others who are also troubled with this issue could get an idea.

    Regards,

    Zoe


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.