Great !! Thank you !

mister.magoo (11/19/2013)

---

...and you can't have a single report with a parameter for A,B,C etc?

If Not, you can create the report with the parameter as a hidden parameter with a default...

lynns (11/19/2013)

---

It appears as if Fields!Month.Value is a text string, since it is sorting alphabetically. Do you have a corresponding date field which would allow you to pull the...

Thanks !! That works !

Good question !

These are all the stores that have registered with our company in that month, year.

Hey Sean ,

The query you have gives a solution like this :

NameErrorCount(IdswithErrorCodes)

AB2 39,40

CD0 ...

Sure !! I guess you didnt miss read it . I edited my question 🙂

Hey ! Thank you...

J Livingston SQL (5/20/2013)

---

maybe something along these lines

SELECT Product.ProductId, COUNT([Transaction].transactionId)

FROM Product LEFT OUTER JOIN

...

@jeff : The databases are on two different servers.

@Phil : Thank you ! . I will check the queries.

Hi Sean

The solution I was looking for is something like this :

SELECT

p.ProductID,

Dept1ProdCount = COUNT(CASE WHEN t.ProductSoldInDept1 = p.ProductID THEN 1 END),

Dept2ProdCount = COUNT(CASE...

Hi Sean !

Thank you once again for trying to help me out .

I actually figured out the solution to the problem.

I did not do a good job of posting...

Thats great ! Thank you ! It works !

Hi Sean,

Thank you for your reply. This is the second time you are helping me out.

I actually see that there is...

Hey I found a solution that works !

select top 1 CONVERT(varchar(1000), FilestreamcolumnName, 0) from Tablename;

This was easy.

Please do let me know if you think there is a better...