WayneS

Forum Replies Created

Viewing 15 posts - 5,551 through 5,565 (of 5,588 total)

RE: Display Multivalue Parameters in the Report Title

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...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 28, 2008 at 8:59 am

#821239
RE: Having trouble printing barcodes in a report

If I export to a pdf, it also does not have the barcodes in the report.
The report does print out correctly from VS.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 28, 2008 at 8:40 am

#821219
RE: Using XML to pass Multi-Select parameters from SSRS to SQL Server

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...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 12, 2008 at 6:53 am

#813750
RE: Using XML to pass Multi-Select parameters from SSRS to SQL Server

Adriaan Davel (5/9/2008)
Hi Wayne,
Nice one, have you looked at the performance of using the XML joins in your stored procedure?
In my "casual" testing, XML datasets up to about 1000...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 9, 2008 at 6:00 am

#812955
RE: Using XML to pass Multi-Select parameters from SSRS to SQL Server

lklein (5/8/2008)
This is the function in the code section - which is different from the beginning article.
If you're not using the function in the beginning article, I don't know what...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 8, 2008 at 4:43 pm

#812746
RE: Using XML to pass Multi-Select parameters from SSRS to SQL Server

lklein (5/8/2008)
This is so frustrating... yikes - I get an error running that just in design view right?
Yes, the RaisError raises an error. In Preview mode, you'll see the xml...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 8, 2008 at 3:38 pm

#812726
RE: Using XML to pass Multi-Select parameters from SSRS to SQL Server

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...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 8, 2008 at 3:36 pm

#812725
RE: Using XML to pass Multi-Select parameters from SSRS to SQL Server

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...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 8, 2008 at 3:24 pm

#812722
RE: Using XML to pass Multi-Select parameters from SSRS to SQL Server

lklein (5/8/2008)
Dang I wish that were it - it's all caps in both the sp and in the report pieces.
Is everything is spelled the same?
Well, can you:
1. Post the code...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 8, 2008 at 2:42 pm

#812704
RE: Using XML to pass Multi-Select parameters from SSRS to SQL Server

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,...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 8, 2008 at 2:33 pm

#812695
RE: Using XML to pass Multi-Select parameters from SSRS to SQL Server

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) =...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 8, 2008 at 2:13 pm

#812681
RE: Using XML to pass Multi-Select parameters from SSRS to SQL Server

lklein (5/8/2008)
My dataset Parameter code is: =ReturnXML(Parameters!C.Value,"C","Customer","Customer_Number") - C being the name of the multivalue parameter which is defined as string the the parameter details.
try changing that to =Code.ReturnXML(...)
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 8, 2008 at 1:55 pm

#812669
RE: Using XML to pass Multi-Select parameters from SSRS to SQL Server

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...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 8, 2008 at 1:45 pm

#812663
RE: Using XML to pass Multi-Select parameters from SSRS to SQL Server

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...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 8, 2008 at 1:42 pm

#812661
RE: Using XML to pass Multi-Select parameters from SSRS to SQL Server

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...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 8, 2008 at 1:36 pm

#812656

Viewing 15 posts - 5,551 through 5,565 (of 5,588 total)