Skip to main content
Solved

Report Designer - Create Date Parameter

  • January 24, 2023
  • 6 replies
  • 572 views

Forum|alt.badge.img

Hi, I am currently trying to create a custom report which shows AR Payments. One of the report parameters I want to create is a From Date and a To Date parameter which lets us filter the database for payments based on the given dates.

 

I have created the following parameter in the build schema of the report

 

The parameter is then used to compare the date values of a DateTime column like so:

 

 

The report is saved to the server, and the parameters show up as expected however if we were to set a date in the parameter:



The following error appears:

 

Best answer by Naveen Boga

Hi, @naufal58  Error is related to the conversion issue.

 

The system is trying to convert the Date to Bool, which is causing this issue. Can you please provide the ViewName like below and verify?

 

=Report.GetFieldSchema('ARRegister.DocDate')
 

​​

View original
Did this topic help you find an answer to your question?

6 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3410 replies
  • Answer
  • January 24, 2023

Hi, @naufal58  Error is related to the conversion issue.

 

The system is trying to convert the Date to Bool, which is causing this issue. Can you please provide the ViewName like below and verify?

 

=Report.GetFieldSchema('ARRegister.DocDate')
 

​​


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 18 replies
  • January 24, 2023

Hi, Naveen. Thanks so much for the reply.

I’ve tried setting the view name as suggested.

 

However, the error still occurs.
 

 


lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 595 replies
  • January 25, 2023

Hi @naufal58 ,

Is the user defined field (ARRegister.usracnmClear...) a date field?  Based on the error message my guess is that it might be boolean.


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 18 replies
  • January 26, 2023

Hi Laura, thanks for the reply. Yes, the custom field I created is of the datetime data type. 


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 18 replies
  • January 30, 2023

Hi all, thanks so much for the replies, it was very helpful. I was so desperate so I just recreated the report. Same parameters, same filters, same tables, same relationship, all of it was the same and for some reason the new report works fine.


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3410 replies
  • January 30, 2023

Great @naufal58  I’m glad that I helped you with this.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings