Gekko (5/28/2008)

---

I am rather new to SSRS and feel dumb asking this question, but here it goes.

I have a report that lets users select 1 to Many months of...

If I export to a pdf, it also does not have the barcodes in the report.

The report does print out correctly from VS.

Hello again...

As you can see, posting XML strings is stripping everything out.

I've recoded this to build the string in a more complex method. Hopefully, it will post okay.

This code, when...

In my "casual" testing, XML datasets up to about 1000...

If you're not using the function in the beginning article, I don't know what...

Yes, the RaisError raises an error. In Preview mode, you'll see the xml...

The following code (based off of your query) works for me. Note that I build the XML string by hand, but your XML string should look similiar.

[Code]

declare @C XML

set @C...

As far as your XML code goes, I don't see anything wrong with what you're doing.

I'd really like to see the XML string that's being passed to the report.

How about...

Is everything is spelled the same?

Well, can you:

1. Post the code...

I think I found your problem (at least I hope so)...

you are calling:

=Code.ReturnXML(Parameters!C.Value,"C","CUSTOMER","CUSTOMER_NUMBER")

and in the procedure you are going:

INNER JOIN

@C.nodes('/C/Customer') as m(item) on (CS.CUSTOMER_NUMBER) = m.item.value('Customer_Number[1]','integer')

I just ran a test,...

lklein (5/8/2008)

---

ok - adding the code.Return... enable it to run - however with no results.

Is this right for in my sp

C=my parameter name

Customer=label

Customer_Number=int value

INNER JOIN

@C.nodes('/C/Customer') as m(item) on (CS.CUSTOMER_NUMBER) =...

try changing that to =Code.ReturnXML(...)

bo (5/8/2008)

---

Thank you for your posting, it is very helpful. Just want to point out when setting the return value of the function to the dataset parameter, it needs...

david (5/8/2008)

---

What if the user doesn't choose any values because they don't want to filter the report on this parameter? I believe this solution would return no data to the...

Daniel Durrans (5/8/2008)

---

Maybe I have missed something or you are talking about a totally different thing but when I use a multi-select in SSRS I just use the parameter like...