Thanks a lot found it in some revision material for 70-433, never come across it before.

The following was the answer i needed supplied by a faster moving forum! Problem solved.

Hi,

If you are using, ssrs 2008, then assigning a port is required. You can add a...

Thank you for the clarification, it was interesting to read about how the cattle are fed beer and massaged daily.

Any ideas?

Thanks Jeff your post in that thread is really useful 🙂

Good question and one which Ill need to find the answer to. For the purpose of the example though can we say its the record the lowest userid.

Ill go back...

something like this?

select ref,min(date) as date

into #cte

from jlrownumber

group by ref

select jl.*

from jlrownumber jl

inner join #cte cte

on cte.ref = jl.ref and cte.date = jl.date

I guess this would work if...

benlatham (2/5/2009)

---

That is only regular subscriptions. With data driven subscriptions you...

Bob (2/4/2009)

---

This works....this code if pasted into your parameter expression will change the begdate parameter based on what time of day the report is being ran. This particular one,...

oh, when i look in my system databases...

i got it wrong, missed mssqlsystemresource, mainly because im a 2005 user.

sam (1/8/2009)

---

You cannot suppress the select all option like you said since this is a built in function. What you could do is, go to the data tab, create...

After uninstalling everythign and reinstalling I have now found that everything is working correctly.

Thank you for your help. 🙂

Not sure what happened but its totally broken now. I'm going to reinstall sql server and dot net and try the whole thing again from scratch.

Im using ASP version 2.0.50727 according to this

http://i451.photobucket.com/albums/qq232/jl45RS/aspnetversion.gif

any other ideas?