thx jo, that is good to know and from what ive seen , the most plausible explanation so far.   i dont know that i'll spend the money to know for...

thx lisa, yep that was the first thing i did.  I set up a separate , temp / workaround copy of the reports without a reference to the offending fields. ...

i just remembered phil, if i remember correctly, the concept of directories isnt available under workspaces.   at least not with pro licenses and maybe no deeper than one level with...

thx steve.

good question phil.    i think my company is averse to putting them up there right now because of 1) the variety of erp's sourcing those reports , 2) the...

thx steve, it appears this post went off track with power query discussions.

anyway something occurred to me the other day.   i forget what its called but there is /was a...

thx Lisa, sorry for the delay, i just got back.

i got the same error embedding the query , ie not using a shared dataset.

the whole thing is pretty complex especially...

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 6 months, 2 weeks ago by stan.
• This reply was modified 6 months, 2 weeks 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 6 months, 3 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...