pietlinden,

Thanks for the suggestion on the Matrix report - this was just what I needed.

As a test, I ran my report in a window that does display the URL, everything on it. When I hover over the link, I can see it and...

That link works; thanks.

One related question. My SSRS report is in a window that doesn't have the URL displayed. So when I click on my link, nothing is...

Thanks MM,

I changed the code and nothing happened when I clicked on the link.

When I viewed the properties of the link, this is what I see:

void(%22window.open('http://system/forms/Summary.aspx?BudgetId=2849','_blank'))

When I remove the %22...

For those who this may help, I ended up creating a second version of the report. And then I passed the comma-delimited values to the second report and rendered...

Another way to think of this is as such: I can pass the variables back to the report; I'm just unable to check the boxes of those variables. ...

I believe this is because each page of the report is rendered as you go through them. If you hit the double arrow to take you to the last...

Thanks so much everyone. Really appreciate the help and the fresh perspectives on my issue. I will not have leading zeros, but it's something good to think about...

Unfortunately, I cannot change the datatype. But that gave me a thought of potentially warehousing the data in that table overnight, and then having that warehoused datatype being varchar(12)....

Sure, here is some dummy data and the query that would provide my expected results:

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#mytable1','U')...

Hi Wayne,

I wanted to pick your brain on this again, instead of creating a new post. Like I said, I am using your solution and it's working great. ...

I figured out what the issue was. The place that we were getting the data from (another system), users were entering in carriage return/line feed combinations while they entered...

Ron and Steve,

Thanks for all of your help. Things have been running perfectly for over two weeks now, when yesterday an issue popped up. The issue occured with...

steveb,

thanks for the thought; I'll add a column (auto incrementing), order by that, in which case that should solve my problem.

Thanks!

This is what you are trying to duplicate:

group 3 footer ="Total Products sold by " & {employeename} & "is: " & count(products_sold),employeename")

you could do something like this:

="Total Products sold...