Query results and SSRS Report results not appearing the same?
-
Hello all,
I have a very curious issue, and am wondering if anybody would have an idea of where to else to look.
The report I am producing is a two level grouped report, showing transactions and errors that may occur on transactions. When I run the query (Mapics DB2) that supports the report independently, I get the following values for the Potential Duplicate Scan transactions.
When the report is run, the following is displayed.
Formula for Potential Duplicate Scans column: =Iif(Fields!POTENTIAL_DUPLICATE_SCAN.Value > 0, "YES", "")
Things I have tried (with no change in view):
1) Ran the report with the same query from my query engine (eliminating the query parameters from causation).
2) Validated grouping.
3) Validate formula.
4) Cleared sorting and validated values.
Does anyone have any other ideas as to how to resolve this issue?
Thanks,
Steve
-
Considering that your images don't seem to tie anything together, this is very difficult to tell you anything. What is the SQL you are running. What is the Sample data? What are the groupings you have on your tablix? CAn you provide consumable sample data, your SQL and a sample .rdl?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
I figured out the issue. The query in the code bahind was was missing 2 characters (it is about a 13,000 character query). Should have been a stored procedure, but I took over someone else's process.
Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply