I think it means that a $ - carried over instead of a 0.

Is that an actual expression you set up or a currency format? If it is an...

You may have a lot of white space around your image, try to crop or manipulate the image to reduce the white space.

With regard to your sales turnover issue. If the reports are individualized, try putting together a data driven subscription that queries a db somewhere that holds reasonably accurate employee...

Use the value returned from your PartNo / LotNo selection to alter the output of the dataset for your report appropriately

If @Param = 'PartNo'

Begin

Query to return Part...

Take a look at the report server tables:

ExecutionLogStorage

Subscriptions

You should be able to build your reports right off of them. Beware of relying only on the ExecutionLogStorage, I have seen...

Hoyer

mazzz (3/10/2011)

---

I was in awe when I found out, on New Year's day, that 2011 is the sum of 11 consecutive primes: 2011 = 157 + 163 + 167 +...

syedathariqbal (3/9/2011)

---

Issue with Parallel Period

Hi,

I have a SSRS report, based on Cube, where a table shows information for Employees.

The report has a table.

Col1 - YearMonth, Col2 - Emp_ID, Col3...

conference calls

abbreviate

This link might help:

http://www.mssqltips.com/tip.asp?tip=1145

Right click on the parameter and go to Parameter Properties.

There is an Available Values tab in the dialog box, fill in your query info there.

Add a parameter called Search or something like that. Make its available values based on a dataset:

SELECT 'PartNo' AS Search

UNION

SELECT 'LotNo' AS Search

Then make the query for your report...

I guess my question is, once you have a GUID, what is the point of the other unique columns?

Yes, you would have 2 parameters

First would be the search selector (Partno or Lotno)

Second would be the parameter for either the Part of lot.

The second would have to depend on...