Report multiplying expressions by 4

CarlSankey — Mon, 18 Sep 2023 13:27:52 GMT

have a paginated report that for some reason multiplies the expressions by 4.

the other direct links to the data are correct.

every expression is multiplied by exactly 4 and this ahs happened several times, and is always 4.

It doesn't do this all the time.

The steps to reproduce it are Open the report and set the parameters

I am unable to reproduce this error.

the person that is ahving the issue only has it once in a while and cannot replicate it themselves.

they are using a MAC and Firefox to view the Paginated report.

the other strange thing is that the expressions have been rewritten and they still get multiplied on the odd occasion.

Any ideas why this might be happening?

Re: Report multiplying expressions by 4

d_gosbell — Wed, 26 Jun 2024 00:59:18 GMT

This is not likely to be an issue with expressions. If I had to guess I'd say there is probably some issue with the data source and joins in your queries.

This is an overly simplistic example, but If you did something like join Orders to Customers using the Customer lastname field and you had 4 customers with a surname of "Smith" then and order for Smith would be repeated 4 times. So it could be a particular set of parameter values causing this issue

topic Report multiplying expressions by 4 in Report Server

Report multiplying expressions by 4

Re: Report multiplying expressions by 4