When I say do the crosstab (or pivot) in the dataset I suppose thinking back on it that most of the reports I've done that way have had mostly static...

What did you change on the report? Layout, data definitions etc?

Is there any chance that the other users are seeing a snap shot copy of the report...

I've done things like this in two ways. The first is to just do the cross tab and everything else in the query and use a table to output...

When you made the copy, did you change the datasource? Most Likely it's the Datasource that's prompting for credentials. It was probably setup as windows integrated and it...

I can think of a few ways to do this, some probably better than others. I'd be interested in what works best for you...

I've been part of a group...

The way I typically get around this is by doing the cross tab in the database. Then I just display it in a table. Jeff Moden has a...

OK so on your pallet paper report how do you figure out that there will be x of 7 pallets?

Really the only way to do this would be to create...

perhaps I'm not understanding. Are you just trying to generate a report with 1 of 10 and nothing else on the page? There's no data to drive the...

ok, are the numbers 1,2,3 etc references in your dataset? If so, you already have half of the data you need. Then you could look at the rowcount...

Are you just looking for the page number? I.e. Page 1 of 10 tgo be printed somewhere on the page? This can be done using the Globals Collection......

Is that the URL you are getting or is that what you are typing in the action property? Also depending on if there are any special characters in your...

GabyYYZ (6/11/2010)

---

Hi Steve, I was wondering if you received an email I sent to webmaster@SQLServerCentral.com about an upcoming re-publication of an article I wrote way back? Are articles typically...

POCTOB (6/10/2010)

---

Sometimes you have to give user access to limited number of the reports visible for other group. And if it is only one or two users, I don't see...

While this can be done, I always recommend using security groups as it makes it easier to manage. ...

How do you currently make sure that the London users only get access to the London Reports? I'm guessing it's by security groups?

IF so just add the user to...