hmmm, well ive done it as a calculated field and it seems to be working fine. So ill see how it goes.

Thanks for the fomat information and thanks for your...

Ah I figured it out. source number 3 is if the report has been exported.

You dont know by any chance how to show which format it was exported in ??

Thanks

R

Thats strange Ive tested it a couple of times and it shows me '4' for either creating a snapshot or Viewing an exsiting one.

But I managed to get round it,...

Thanks, that gets me a little further, but it shows me a 4 if the users has either created a snapshot and viewed the snapshot. I just need to know...

I have found that I can change the format of the field by changing it in report builder 2. It is just in report builder1 that I can not change...

Its ok, I figured it out, I was just not entering the correct value within the paramters.

Thanks

There isnt that much data, put Im not sure how to do Crosstab queries.

Ive had a google on how to create them but they are all for summing number values...

I know after looking at it for ages I feel relieved.

But it is still would be a problem if i wanted to use this code as a field on the...

thanks, the reason I needed it as a field was so I could group, but I found if I can create a group by an expression, so I added the...

How would I convert it to string, Ive tried var(Field) and char(field) to no avail.

sorry another update, I just deleted the parameters of the subreport and now it is not giving me an error but a value.

But I dont feel this is right when...

Thanks, looking at that link you gave me, I added the subreport to another report with no parameter and it worked fine!

So its looks like there is something wrong with...

rkaria (1/12/2011)

---

Thanks for the quick repsonse.

I alerady mentioned in the first post that the sub report runs fine on its own, the field one the subreport returns values.

Im new to...

Thanks for the quick repsonse.

I alerady mentioned in the first post that the sub report runs fine on its own, the field one the subreport returns values.

Im new to BIDS...

sorry forgot to include the error message again 🙂

" error subreport can not be displayed"