The situation is, We have a set of queried numbers that would normally go in a group, but since it would be in a column group and destroy the formatting, I've had to do some work arounds. Namely, the only thing that works is storing them as a parameter with available values (pulled from a query), and set to Internal. I tried SubString in the query, but it forces a tag around each returned value, and I cant get rid of them! And we cant have that crap on the report. I dont understand why that was implemented. However, when previewing the subreport, I get "The 'ParamName' parameter is missing a value.' Can anyone help me with this? I just really want to be able to return these queried fields as =join(Parameters!ParamName.Value, ", ")

bump. I'm still needing help. It's completely holding us up. The issue comes from the header only passing an ID to the subreport. Each time the subreport is repeated (the entire subreport is a group because of this), we wanna display each BOLNumber, aka the parameter, on a section of the subreport, but only display the info for a single specific BOLNumber on that detail row.

Bump, still cant resolve this. However I must restate the problem: It's no longer in the subreport, but the main report. Basically requirements are : 1. Cant use groups; a. Because this needs to be done horizontally, column groups would be required, and we cant use those because it throws off our formatting. 2. Must return any and all values returned from the original query for the BOLNumber. This can be between 1-5 rows, so we need 1-5 values. 3. The main reports query is designed to NULL all of the BOLnumbervalues we need from that table as designed. a. Thus, I tried a second dataset. This is odd, as it needs to aggregate a value from a separate dataset == First(BOLNUM, "Dataset2"). We obviously need more than the first... 4. Thus where im at. It's inherently dependant on the only parameter, shipment number, to find the shipment id's to populate the BOLNUmbers. I wanted to use, then, a multivalue internal param to store these after given the shipment number and then use a JOIN(BOLNUMBER, ", ") In the expression box.

Bump, still cant resolve this. However I must restate the problem: It's no longer in the subreport, but the main report. Basically requirements are : 1. Cant use groups; a. Because this needs to be done horizontally, column groups would be required, and we cant use those because it throws off our formatting. 2. Must return any and all values returned from the original query for the BOLNumber. This can be between 1-5 rows, so we need 1-5 values. 3. The main reports query is designed to NULL all of the BOLnumbervalues we need from that table as designed. a. Thus, I tried a second dataset. This is odd, as it needs to aggregate a value from a separate dataset == First(BOLNUM, "Dataset2"). We obviously need more than the first... 4. Thus where im at. It's inherently dependant on the only parameter, shipment number, to find the shipment id's to populate the BOLNUmbers. I wanted to use, then, a multivalue internal param to store these after given the shipment number and then use a JOIN(BOLNUMBER, ", ") In the expression box.

Hi TheTurdFerguson, Thanks for your post. According to your description, you would like to retrieve the BOLNUMBER based on the specified shipment number, and then join the BOLNUMBER together, and show it on your report. If so, firstly, you can retrieve the data you want to use as one dataset, and then take use of the lookupset function to retrieve all the BOLNUMBER using shipment number, and then take use of join function to join the returned BOLNUMBER together. You can refer to the expression below: =Join(LookupSet(Fields!ShipmentNumber.Value, Fields!ShipmentNumber.Value, Fields!BOLNUMBER.value, "DatasetName"),,) Thanks, Bill Lu Bill Lu TechNet Community Support

Hi TheTurdFerguson, Thanks for your post. According to your description, you would like to retrieve the BOLNUMBER based on the specified shipment number, and then join the BOLNUMBER together, and show it on your report. If so, firstly, you can retrieve the data you want to use as one dataset, and then take use of the lookupset function to retrieve all the BOLNUMBER using shipment number, and then take use of join function to join the returned BOLNUMBER together. You can refer to the expression below: =Join(LookupSet(Fields!ShipmentNumber.Value, Fields!ShipmentNumber.Value, Fields!BOLNUMBER.value, "DatasetName"),,) Thanks, Bill Lu Bill Lu TechNet Community Support