Paul Morris-1011726 (4/10/2012)

---

I have a set of reports that I am trying to consolidate into a single report using a drop down list for filtering.

There are only 3 values:

Printing =...

Thanks. That worked. I knew I was over thinking it.

themangoagent (4/17/2012)

---

My query runs within 2 seconds using Management Studio, but when I put that query into a report in Visual Studio, the report won't run.

Here's what the query looks...

just found that last blank page solution.

In the Report Properties, there's an option called ConsumeContainerWhite. Select TRUE and the last page is gone.

I found a solution when I was wanting to display an 'x' number of records on each page.

Dont know if this is what you're looking for but here it is.

Create...

Instead of data going like this

Col1.......Col2.......col3

data1.....data4.....data7

data2.....data5.....data8

data3.....data6.....data9

I'm loking for this:

Col1........col2.......col3

data1......data2.....data3

data4......data5.....data6

data7......data8.....data9

From what my manager explained to me, this is called a Avery label format.

I saw that and tried it, but didnt display what I wanted. Not sure why...

Thanks for the reply. This is what I did after I posted the question.

I made a huge IIF statement in the textbox:

IIF(Parameters!Percentage.Value = "0.50", "50",

IIF(Parameters!Percentage.Value = "0.51", "51",

and so...

If anyone is interested in a solution. Here goes:

I used a statement called a Row/Partition within the select statement in my view. This is what I used:

ROW_NUMBER() OVER(PARTITION BY Contact_NameID,...

I thought the same thing but that...

I solved my own question. This is what I did.

So I created a parameter called StartPageNumber.

In the report footer, I created an expression:

=Parameters!PageNumStart.Value + Globals!PageNumber - 1

This allow you to...

Awesome thanks. I've been creating too many reports lately, didnt think about making a case statement. Thanks!

After review the code, I got it working the way I wanted it.

To resolve the issue with blank spaces within the name and addresses, I created an expression with a multiple IIF expressions. I tested it and it works as I want...

Will this raise any of textboxes that are below the "empty" space?

Thanks!