thx tav29, unfortunately im in report builder and i dont think there is such a "feature".

hi tav29.   no calcs in the report.   yes, i ran what you suggested.   also, i saw the underlying data so im reluctant to try other algebraic solutions.   my boss is...

i finally got this darn thing to run in chunks of dates.   right from openquery.    not ideal but since they have an index on date, i tried it and...

• This reply was modified 5 months, 1 week ago by stan.
• This reply was modified 5 months, 1 week ago by stan.

i tried an ado .net source.   Not saying i did it right but i picked odbc driver from the list of driver choices.    ssis definitely saw my dsn but...

thx all.   going thru ssis via lined server is consistent with the architecture we use on everybody else (25 other erps, im just the messenger).

but as a last resort, later,...

hi tav29, i ran with your recommended alternative calc.   same error.  same calc.

hi tav29.  SSRS is giving an error ive seen once or twice before ...  something about divide by zero and cant get next row.  but if i run the view...

• This reply was modified 5 months, 1 week ago by stan.

hi tav29.   i noticed it ISNT cache because in the cache properties of the report it said to always pick the latest results.

so i narrowed again and focused on one...

thx phil we didnt use datasets in etl.   its all talk/pontificating.   and i'd be more prone to trying pentaho etc than doing that or  reinventing some pretty well established  wheels...

thx Ed.   That was useful to me.  We also stood up ssas on a vm as part of a dev sql server.   But are convinced separating duties between the engine...

thx phil i believe that custom setting was ssrs automatically setting it (the rt click on report) .

none of my objects is wider than the body but my textbox heights...

• This reply was modified 6 months, 2 weeks ago by stan.

rendering in ssrs still has that wide look with no border.   hitting print layout in ssrs looks right.   saving to pdf is much better now in that watermark is still...

• This reply was modified 6 months, 2 weeks ago by stan.

thx, i will try changing that.   and post back here.

appreciated eddie.   we do it "my way" everywhere else at my company at no extra cost and without any problems.    "my way" is really best practice across the industry. ...

red shows background image.   2nd image is other properties pane of report that you get by rt clicking the report region.