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 4 months, 2 weeks 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 5 months, 3 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 5 months, 4 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.

these are the report props, will show body props separately

thx jeff there is one lower level manager that understands it from an edi standpoint.   Generally speaking edi is more of an immediate gratification app where the hassle of xref...

kind of phil.   their decisions impact their oltp directly.  they dont really think about or understand the impact on a warehouse.

for example, say they have a customer hierarchy.   various bill...

• This reply was modified 6 months ago by stan.