#Value  [SOLVED]

Questions and Answers asked by users to users, about how others use Jet Reports.

For additional "how to" information, please visit our online Knowledge Base https://jetsupport.jetreports.com/hc/en ... ofessional
Forum rules
The Jet Reports Community forums are not a guaranteed support medium. Official support for Jet Reports is available only through the support desk at http://support.jetreports.com. Staff responses to posts on the forum are not guaranteed.
veronikach
Posts: 3
Joined: Tue May 16, 2017 6:51 am

#Value

Postby veronikach » Wed May 17, 2017 6:11 am

Hello,

in one report I have this problem. Till yesterday it worked, but today I can see only #Value.
Some information about report are in apendix.
Other reports are OK.

Any idea?

Thanks,

Veronika
Attachments
Jet report.png
Jet report2.png
Jet report2.png (11.08 KiB) Viewed 213 times

User avatar
HPDeskJet
Jet Reports Certified Professional
Posts: 441
Joined: Wed May 26, 2010 3:40 pm

Re: #Value

Postby HPDeskJet » Wed May 17, 2017 7:57 am

When you select the cell which is displaying #VALUE! and then click the DEBUG button on the Jet ribbon, what additional details are displayed?
-HP
_______________________
Jet 2015 Certified Trainer

veronikach
Posts: 3
Joined: Tue May 16, 2017 6:51 am

Re: #Value

Postby veronikach » Fri May 19, 2017 4:54 am

Hello, thanks for aswering me.
You can see it in picture.

THX!
Attachments
Jet report 3.png
Jet report 3.png (7.56 KiB) Viewed 203 times

User avatar
HPDeskJet
Jet Reports Certified Professional
Posts: 441
Joined: Wed May 26, 2010 3:40 pm

Re: #Value

Postby HPDeskJet » Fri May 19, 2017 1:10 pm

That's a fascinating error message (and not one that I have NOT seen before).

Here is what I found about the error:

https://blog.sqlauthority.com/2007/05/1 ... ansaction/

Pinal Dave is one of the best authorities on the Web that I have seen when it comes to SQL Server.

If the issue continues to happen, I can only assume that some process somewhere has a perpetual lock on something needed as part of your query.

I hope that helps.
-HP
_______________________
Jet 2015 Certified Trainer

veronikach
Posts: 3
Joined: Tue May 16, 2017 6:51 am

Re: #Value  [SOLVED]

Postby veronikach » Mon May 22, 2017 5:59 am

Hello,
thanks for the answer.

Now I know, what was the problem: limit :-)

You can see it in pictures.

Veronika
Attachments
jet report4.jpg
jet report5.png


Return to “How do I?”

Who is online

Users browsing this forum: No registered users and 1 guest