Here is an odd one…I need to create an SSRS report that returns no data. The report only contains the data that is input as parameters (of which there are 10)…
How would one create that? Is an empty RDD a thing? How about a BAQ that has no query? I mean, something has to be possible for this…right?
I setup a sample BAQ like this:
select distinct
(1) as [Calculated_mycalc1]
from Ice.ZDataSet as ZDataSet
Add as many calculated fields as you want. You can probably use any of the z tables for this, as long as you don’t include any fields from the tables, and only include calculated fields.
I seem to recall other folks using the z tables for oddball uses like this. I hope this helps!
I figured out how to get the BAQ to run without having to give a table…just have it select the calculated field and you are good to go:
select
(@PartNum) as [Calculated_PartNum]
When I test the BAQ in the BAQ Designer, it works as expected, basically returning whatever value I throw at it. So, I created an RDD, added the BAQ, created the Criteria Set and generated the Criteria Prompt. I went into Report Style and created a report and style, set up the data definition, location, criteria, etc., and then went to test it…
Ice.Baq.Hierarchical.ValidationException: Mandatory parameter values
are not specified for 'F1500303' BAQ: PartNum
How is that possible? There is the Criteria Prompt in the RDD.
And here is the report screen…
Am I forgetting something here? I feel like there is a step that I am simply forgetting.
I would have just used a table that you know has very few records. Like one that stores Company Maintenance values. The select phrase would be your parameters, but use Group By to get just one record.
To resolve this issue, make sure your control name value is assigned within the Report Criteria - report mapping grid
You don’t even need a table.