Now that I can search configurator data based on the quote and line, what I need to do in SSRS report designer is to display the ‘InputValue’ value where the ‘InputName’ value equals something like ‘nmbLayers1’ or whatever value I am looking for, onto a text box. Basically, just displaying one value in a specific row. Here is a small portion of what the BAQ is currently showing:
One thing that I thought to do was to make individual calculated fields of each separate field that I am looking for and just taking the value from that. However, it seems like I would run into a similar issue, where I would have to only display a certain row where x column (in this case chkHorizontalBestYield) is not empty.
All that to say, is there an easy way in SSRS report designer to display a value from a row where a different value equals something? If so, what would be the easiest way to do this?
Mr. Taylor: you may want to consider using a separate dataset in SSRS to do a “lookup()” where you provide the QuoteNum and QuoteLine and then use a Lookup() for specific InputParamter.
If you are going to use BAQ Report then just Group by Quotenum and QuoteLine and then ignore the Details (too much info).
If you use an RDD Report then you can make the input parameters a separate Dataset and again use a Lookup()
I am a bit confused on the first part. My BAQ currently has a hard coded quote number and quote line, for easy testing. I will make the quotenum and quoteline be populated with what quote line the user is printing from eventually, but that is for another day. Would I still need to make the lookup() function have the quotenum and quoteline? I tried to make a field have a lookup() function, but that gives me an error when trying to import it into epicor. Where would I put the lookup function?
I would really prefer to stay with BAQ reports, as they seem a lot easier to work with compared to RDD reports. When you say group by QuoteNum and QuoteLine, do you mean to do that in the BAQ itself or somewhere in the SSRS report?
After some trial and error, I might have figured it out. At least with a hard coded quote number and quote line in the BAQ.
I entered in the following expression into a text box: =Max(IIF(Fields!PcInputValue_InputName.Value = "nmbLayers1", Fields!PcInputValue_InputValue.Value, Nothing), "BAQReportResult")
This correctly got me the number “1”, which is exactly what I was looking for. Is something like this best practice?
