WayneS

Forum Replies Created

Viewing 15 posts - 5,566 through 5,580 (of 5,588 total)

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

Andy Warren (5/8/2008)
That works let you let RS execute the query, but you can't just pass it to the proc that way, sees it as one big string, not discrete...
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:35 pm

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

lklein (5/8/2008)
I get an error - Next control variable does not match For Loop control variable 'sParamItem' should I be customizing any of the function in the code property?
This is...
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:31 pm

#812653
RE: T-SQL query

webrunner (5/2/2008)
I agree. But I think the English phrasing should be: "The condition should not use either the IN or the OR operators." Or, alternatively, "The condition should use...
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 2, 2008 at 7:14 pm

#810386
RE: T-SQL query

Since the question clearly states:
The condition should not use both IN and OR operators.
use could use:
where DatePart(m, ) IN (1,3,4,5,7,8)
OR is not used, so since they BOTH aren't...
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 2, 2008 at 5:07 am

#809988
RE: How do you get/pass multi-value parameter to a drill-through report.

I generally do the totals that way also, but this report specified having an "Available" after the "Total". The Total does not include the available. It seemed easier to have...
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

April 22, 2008 at 11:07 am

#805641
RE: How do you get/pass multi-value parameter to a drill-through report.

Ben Sullins (4/22/2008)
Great Job!
Is your 'Total' line in the footer section of the table?
Thanks!
The Total and Available lines are being returned by the query, so they end up being in...
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

April 22, 2008 at 9:16 am

#805586
RE: How do you get/pass multi-value parameter to a drill-through report.

In case this can help anyone else, here's my solution
In the Report Properties | Code section:
Public Sections as String
Public Function SectionList(Section as String) As String
If (Section <> "Total") and (Section...
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

April 22, 2008 at 8:56 am

#805576
RE: sql errors

All of the fields referenced in the select that are not already part of an aggregrate function need to be in the group by clause (or include them in an...
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

April 22, 2008 at 7:02 am

#805484
RE: How do you get/pass multi-value parameter to a drill-through report.

I think I'm onto something, but I'm having a problem.
In RptA, I've added a hidden parameter: Sections (default="")
I then added some custom code:
Public Function SectionList(Section as String, ByRef Sections as...
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

April 21, 2008 at 4:21 pm

#805235
RE: Is it possible to print a report without displaying it?

Ben Sullins (4/21/2008)
Nice work around...
Wayne,
Just wondering here, why would a user want to print a report without first viewing it? I would think that they would at least want to...
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

April 21, 2008 at 3:34 pm

#805226
RE: How do you query a report to determine if it will print in portrait or landscape?

It's the DEFAULT page settings that all show 8.5x11; I can't find available properties for the report page settings.
The reports view / print as designed (portrait / landscape).
My work-around is...
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

April 21, 2008 at 3:30 pm

#805223
RE: Is it possible to print a report without displaying it?

What I ended up doing:
1. Render the report as a PDF, saving it to a file.
2. Start a process that launches Adobe Acrobat Reader with the print command line option.
I...
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

April 21, 2008 at 2:14 pm

#805196
RE: How do you query a report to determine if it will print in portrait or landscape?

Ben Sullins (4/17/2008)
May I ask why?
Okay...
I've developed a form in C# with the ReportViewer control.
Depending on which method you call, it launches different reports.
Some are portrait, some landscape.
I want...
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

April 21, 2008 at 1:56 pm

#805189
RE: Is it possible to print a report without displaying it?

This looks very interesting. But it also looks like it only works for networked printers?
It sure would be nice if there was a way to just print to the user's...
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

April 16, 2008 at 6:52 am

#803053
RE: Problem setting parameters with ReportViewer

Okay, I got it working.
It should have been:
Microsoft.Reporting.WinForms.ReportParameter[] Param = new Microsoft.Reporting.WinForms.ReportParameter[1];
WayneS (4/14/2008)
I'm not a C# expert either... 🙁
this gets me the error:
Syntax error, bad array declarator. To declare a...
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

April 14, 2008 at 12:11 pm

#802219

Viewing 15 posts - 5,566 through 5,580 (of 5,588 total)