Excel is the analytical tool of choice for analysts everywhere. Anything we can do to help them use the tools they are familiar with is in everyone's best interest....

I would start by looking at the user you have set up and the configuration of the data source in report manager.

Execution rights to a stored procedure is way more secure than direct read/write access to a table. My understanding is that this is a generally safe construct, but you...

atif saeed khan (8/12/2010)

---

Hi dbowlin!

i have one question, if CallerID is a field with multi-value option and with filled data in it. how wud url be in that case ?...

Although you can use code in the...

=IIF(TR_Typecode = "Retn",Unit_Price * (-1), Unit_Price)

Sorry, I don't have an easy answer for that one.

Good Day, Sunshine!

Are there any negative values that could result in a zero even though it is data you want to show? Are you losing any data by casting as an...

I think a little more explanation is in order.

Security for reports, and security for the stored procedure do not need to be the same. The user set up to...

I don't know if it considered the best way, but it is what I do.

I know there are Pantone to CMYK conversion charts available and I believe there are Pantone to RGB conversion charts available also. However, not all colors will convert exactly....

So you want the selected values of parameter C to be constrained by the A & B parameter? Can't you just add them both to the where clause in...

Nadya Suleman

Vacation......

A lot of people must be on vacation because the post frequency to this forum has dropped dramatically.

I wish I was on vacation too.

🙂