SmartDecimal & client RDL reports

ajj3085 posted on Tuesday, May 01, 2007

HI,

I have a smart decimal, similar to the smartdate, and I'm trying to display the value of the smart decimal in a reporting services client report.  Currently its simply returning #Error, although I'm not sure why.

Any ideas?

david.wendelken replied on Tuesday, May 01, 2007

ajj3085:

HI,

I have a smart decimal, similar to the smartdate, and I'm trying to display the value of the smart decimal in a reporting services client report.  Currently its simply returning #Error, although I'm not sure why.

Any ideas?

I'm assuming youv'e verified that the input data is ok, and that SmartDecimal works correctly outside the RDL environment.

I haven't tried using BOs in reporting services yet, but I'm curious if you are having the same problem with SmartDate?

Could it be a presentation width problem, in that the display width isn't wide enought to display?  

ajj3085 replied on Tuesday, May 01, 2007

Yes, prior to getting the report, it is being displayed on the screen.  The same BOs that are being displayed are used as the reports datasource.

I haven't used smartdate in these reports at all yet, but I imagine it would be a problem.  I don't think its a width problem, because it would simply be clipped from what I could see.

david.wendelken replied on Tuesday, May 01, 2007

It's possible that the RDL file cannot find the business object library.  Depending upon your setup, it might be running on a totally different computer from the database or the webserver.

ajj3085 replied on Tuesday, May 01, 2007

Hmm, it could be that is the case.  Part of me would be suprised, because the report is actually embedded into the business object library.  Part of me wouldn't be though.. i'll see if I can't get it to find the assemblies.

ajj3085 replied on Wednesday, May 02, 2007

I ran into issues where Csla wasn't trusted, so rather than trying to figure out what else I must do to make the report see Csla, I found a workaround.

If I add .ToString in the expression, I can get the value fine.  Using CDec, I can convert that value so that the report can format it.  Finally, I needed the Iif statement to simply return an empty string if ToString returns the empty string.