Well Dixie, I ended up using yours with the idea of incorporating it into the main report 😀

Sorry Seth....

Final version (I didn't include all the Main query):

CASE WHEN EXISTS...

Thanks that did the trick!

I was looking at the query and had a thought... could the issue be that the main query returns multiple rows per user while the subselect only has 1?

I am trying to return a single value per user (the sum of the quantity where the account = <the list>). When I run the query in a seperate dataset,...

I was thinking down that route... was hoping to avoid... I saw some code that you pass in the text, calcs the length and passes back.... Just need to stipulate...

The entire paragraph will always be double space.

Here is one of the expressions for one of the paragraphs:

="REQUEST #" & (Fields!NumCount.Value - 4) & ": " &

"That the bill of...

Thanks everyone for the suggestions and help... Just wanted to post my solution:

I knew that my last value for the row number was going to be 5 times the last...

hmmm now that I am looking more closely (and if I am reading it correctly)

26 = AA

27 = AB but for my purpose it equals BB

28 = AC but for...

That should work Peso... the sequence would very rarely exceed 200. 99.9% will range from 50 - 150.

So comes my rookie question... how would I incorporate that into my report?

Cool my first interesting problem! 😀

So if I may piggy back on this, I have a semi related incrementing issue... I have need for a second counter (sub counter) based...

Thanks Lynn... used the last suggestion and just plugged into query with out doing a function.

Here is the snippet of the query:

replicate(char(64 + ((((ROW_NUMBER() OVER(ORDER BY vle.computename)) - 1)...

OK been attempting to get this working in a function but...

In theory yes but in this particular case they want A, B, C...,AA, BB, CC..., AAA, BBB, CCC....

If interested I could spell out why but figured most folks are not...

thanks Lynn... looks promising based on some quick testing. It does return what I was expecting. Let me incorporate it with what I have and test...

Thanks again!

thanks mister.magoo: kind of get it but that is more due to being novice than anything

bteraberry: that makes since... I never did anything with the value just did the calc......