Hi,

What output are you looking for? TOP is not a function you can use on a join. As Pradeep says, you can use MAX() but then again, it depends on...

Actually Ramon, I'm pretty new to this forum. Perhaps we should stick to the guidelines in Jeff Moden's article.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

regards

Hi Nuts,

Did you drag a line control from your toolbox onto the body of the report, or, did you change the properties settings of the body of the report?

can you be a bit more specific around the structure of your table and the data it contains?

e.g.:

unqKey parentKey value1

1 1...

Hi Vincent

I think the prefTotal value would have to be calculated in the t-sql that returns your dataset. I am not a fan of inline select statements but this is...

Hello,

I think that if you want a static border (one that doesn't move with the list) then you need to place the border outside the list using Line controls...

For the textbox you could use an expression similar to this for the value property of the textbox: iif(IsNothing(first(fieldname1)) = 1, "Please select a parameter!", "")

I'm not 100% sure if...

I spoke to one of my colleagues about the problem here and he pretty much has the same idea.

Execute a stored procedure that checks if a parameter was selected. If...

hmmmm, before you redesign(if need be) your package, you'll need to determine where the duplicates are coming from. This is what will define your package structure. It's pretty difficult to...

You could possibly do one of the following:

1. set one of the parameters to have a default value(thereby eliminating the fact that a user might forget to select one)

2. ...

Hi arup_kc, is your report running from a cube?