It just means you've got mismatched capitalization for your @Studycode parameter somewhere, i.e. Studycode in one place and studycode in another. I find it's easier to just open the rdl...

The way you've got it written, you're just returning the max(bat_num) for every record you're getting back from your main query.

Try this instead:

Declare @actid VARCHAR(10)

SET @actid ='642584789T'

SELECTd.cust.id,

rtrim(isnull(d.cust_ln,''))+',...

No problem! I've never actually used it, but I was pretty sure it was possible. I tried doing what was stated in the original post and obviously got the same...

While you can't just execute a report in your own browser and copy the URL to send to someone else, you can pass report parameters within a URL using ReportServer.

See...

I believe all you need to do is check the Allow Blank Value/Allow Null Value properties of the parameters for the subreport and you should stop seeing the error -...

I think I understand what you're saying. If you are selecting E.FLDID and also using the count(E.FLDID) in your expressions, you're getting one row per E.FLDID, which means each expression...

I'm not entirely sure I follow what the issue is. Wouldn't you just need to add those fields to your Select and Group By?

Are you sure the code you pasted is the code that you are trying to execute?

The line of code in your error message doesn't appear in the sample code...

That's just Excel making some assumptions about the data type. If you were to open the file in notepad, you'd see your data in the format you are expecting. You...

slimchance99 (8/19/2011)

---

Thanks for the reply.

It is not quite that simple. In your scenario, the user would enter a date as the parameter and would get back all records newer that...

I believe the problem you're having is with where you set the visibility and toggle properties. Instead of setting the properties on the row or cell you want to show/hide,...

I think it's just a bug in BIDS. If you move one of the tasks around, the constraint should reappear.

I'm not certain that this applies to your situation and I'm not sure of the syntax as I've never used the DTUTIL feature, but you should be able to set...

Is it possible that the .csv file your importing isn't formatted correctly?

It looks like the problem tends to start with the Company field, and a lot of companies have...