Worksheet ...is not valid for Library

(0) Share

Report

Posted on by Kacper.Domagala

Hi ,

I have an issue to link 2 reports. I created the first one and when I try to create the second one I am receiving following error message: "Worksheet ...is not valid for Library". This message error regards the first report. Both reports are save under Library/Public.

Thank you for your support

Kacper

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Kacper,

Do you receive the error when you try to save and upload the document to the MR library or when you run a report that links to one of those Excel documents?

Best regards,

Ludwig

Was this reply helpful? Yes No
Kacper.Domagala 62 on at

Like (0)

Report
Copy link

Link copied!

Hi,

No issue with saving. One of reports will pick up the value from another one and that is the problem.

After creating the first rapport, one of the value needs to be nicked up by the second rapport, and this is necessary for this second rapport to do to be generate at all. That is the moment when an error occurs- when this second rapport generates and when it comes to take a data from the first rapport.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Kacper,

Not sure whether I fully understand how you arranged and linked the reports.

You can possibly have a look at the following post that provides you an example of how MR reports could be linked in AX2012.

dynamicsax-fico.com/.../

If this does not help then please provide some additional details on your report design and how you linked the different reports.

Many thanks,

Ludwig

Was this reply helpful? Yes No
Kacper.Domagala 62 on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig,

I must say that I spend a lot of hours and cannot solve one issue, how to get a special value to the report. Let me describe and show the printscreen of the report I created.

1. This is example of row defintion I created, Yellow marked postion is the value I am missing.

2. This is example of Column definition. Column "B" is crucial.

3. And finaly Tree. The yellow marked line need to landed in Column B - row line 985

4. Now I would like to present finaly the report

Total(Column B) is result of a calculalation of column C+D+E.

1. According to Column defintion how can I get a single value (that is coming from Reporting Tree-yellow marked) to Row definition-line 985 in Calculation coöumn otherwise it will have an impact on the whole report, not only R&D position.

I tried to select directly on "Link to Financial dimension" level but because of the "&" sign that dimension contains, system doesn't allow me to that. I tried to add on "Related formulas/Rows/Unit" but system is not able to generate the report at all.

Another thing is that I am not able to solve following warning

I hope that you have some idea.

Thank you in advance

Br

Kacper

Was this reply helpful? Yes No
Kacper.Domagala 62 on at

Like (0)

Report
Copy link

Link copied!

I would like to add that columns C,D,E contans rules included in Report Tree and the missing value is not a part of them.

I know that is really complicate to explain.

Was this reply helpful? Yes No