J Livingston SQL,

Thank you for the link on Using SP!

This is also to sgmunson,

On the question of Crystal, again I thought I answered it.

The end-user enters the year they want...

Ah, yes, I did not know you can use Stored Procedure in Crystal.

As explained, Crystal is linking to a View on the SQL Server.

And was thinking saving the solution as...

Thank you!

Unfortunately I am getting an error. Syntax on GO

I'm using SSMS Express 2014.

? Odd, I did reply to the use of Crystal, also multiple times.

Here it is again,...

sgmunson,

I'm sorry that you feel that way.

If you go to the my originating post, my very first line says View.

Why someone assumes I'm not looking for the solution in a...

sgmunson (8/20/2015)

---

If you need a view, then you can't have a parameter in Crystal that's going to do you any good unless the view ignores date ranges entirely. Are...

sgmunson,

thank you! This is closer than ever! It's producing the results in the detail format ...

Like J Livingston SQL came up with EXCEPT it was in a crosstab format which...

I prefer this format. This result seems only for 2016, like most of the other formulas, it works when it's a specific year but not when it's a range of...

so another way to explain what I've been trying to state, think I'm saying the same thing though ...

need current and future years AND when there is no membership, including...

sgmunson (8/20/2015)

---

Boy are we on two different pages. Why would you need a record for club 5305 that shows 0 memberships? And how does the parameter...

sgmunson (8/20/2015)

---

So how are you determining that my query doesn't do that? Please tell me you are NOT using Crystal Reports to make that verification. If you...

sgmunson,

thanks again ... however that's ONLY reproducing the original number of records in the table.

I have an easy query, which I shared at the beginning that produces this result. It's...

sgmunson,

thanks for trying ... unfortunately it's not completely correct.

it's the same thing, 5305 is NOT showing 0 for 2016.

also, it cannot do the count for this details.

They will "drill-down" to...

ok, here's a snapshot before the changes requested.

You won't see 5305 or 8004 or 1617 b/c these clubs do not...

Unable to at the moment but it's basically like this:

WHEN the end-user enters EndYear 2015:

ClubNo ClubName OtherClubInfoForTheClub NoOfMbrshps Add'lClubInfo

5305...

Hi J Livingston SQL,

I thought I replied to that formula.

Though it looks to display the...