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...

This is...

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...

Since the question clearly states:

use could use:

where DatePart(m, ) IN (1,3,4,5,7,8)

OR is not used, so since they BOTH aren't...

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...

Thanks!

The Total and Available lines are being returned by the query, so they end up being in...

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...

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...

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...

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...

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...

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...

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...

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...

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...