What are you trying to do exactly (the bigger project).

You cannot use a variable for the db name. It has to be dynamic sql.

Does this work for you?

=VAL(iif(Fields!valuehome.Value>0,Fields!valuehome.Value,"0.00"))

You could also try cdbl instead of val.

Could also be SQL server with Access as front end....

That message is always a cast error or an error in the formula.

Sounds like shared hosting w/o admin access.

Seems to work from my laptop as well... talk about your big bonuses :hehe:.

The bids project can be on a shared drive, accessible from everywhere.

Steve Jones - SSC Editor (1/4/2011)

---

For those of you setting weight goals, I'd discourage that. I think you ought to work on your health, and trying to get to the...

Ninja's_RGR'us (1/5/2011)

---

Hmm, why the heck didn't I think of that???

Yup, just open the trace file, script it out, disable the default trace and run that one of startup and we're...

Hmm, why the heck didn't I think of that???

Yup, just open the trace file, script it out, disable the default trace and run that one of startup and we're done.

ALZDBA (1/5/2011)

---

I must admit I haven't heart of such a setting to controle the file size for the default trace, nor did I search for it in sqlserver.

The easiest way...

cengland0 (1/5/2011)

---

My first exposure to computers was a mainframe using magnetic core...

I don't have bids 2008 here so I can't give you a screenshot nor look arount. AFAIK, the parameters are also available in the same treeview as the datasets.

cengland0 (1/5/2011)

---

I agree. I was programming in the late 70's (not SQL) so I am way older but don't want to...

Then you need to manually add the parameter to the report. In design mode, if you right click under the footer section of the report you should see a...

:w00t: Now you know why I chose Anakin Skywalker...