Forum Discussion

timazarj's avatar
timazarj
Helper II
1 year ago
Solved

local Processing Error Paginated Report

Hi,

I am developing a paginated report using a power bi semantic data model as a source and defining a date range (expiration date) parameter. The properties of the parameters are:
- FromLinesExpirationDate: Data Type: Date/Time    Default Value: No default value  Available Value: None
- ToLinesExpirationDate: Data Type: Date/Time    Default Value: Format((Parameters!ToLinesExpirationDate.Value),"yyyy-MM-dd")   Available Value: None

And on the dataset properties:
-FromLinesExpirationDate: =Format((Parameters!FromLinesExpirationDate.Value),"yyyy-MM-dd")

-ToLinesExpirationDate:=Format((Parameters!ToLinesExpirationDate.Value),"yyyy-MM-dd")

But when I tried to run, I received this error:
"An error occurred during local report processing."

Details: "Exception of type 'Microsoft.ReportingServices.ReportProcessing.ReportProcessingException' was thrown.
----------------------------
An error occurred during local report processing."

 

Please advise me.

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi timazarj ,
    According to your description, the default value of ToLinesExpirationDate is set to Format((Parameters!ToLinesExpirationDate.Value), “yyyy-MM-dd”), which seems to reference itself. This may cause problems. Try removing the default value expression for ToLinesExpirationDate and then run the report. Also the default value of Format will be is of type string, which doesn't match the datetime type you are quoting. If the parameters are not required, make sure your dataset query can handle null values. If they are required, make sure you provide a valid date before running the report.

    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

3 Replies

  • Kedar_Pande's avatar
    Kedar_Pande
    Super User
    1 year ago

    Fix Parameters:

    FromLinesExpirationDate: No default value.
    ToLinesExpirationDate: Set to =Today() or no default value.

     

    Dataset Properties:

    Remove Format function, use:

    FromLinesExpirationDate: =Parameters!FromLinesExpirationDate.Value
    ToLinesExpirationDate: =Parameters!ToLinesExpirationDate.Value


    If this helped, a Kudos 👍 or Solution mark would be great!🎉
    Cheers,
    Kedar Pande
    Connect on LinkedIn

    • timazarj's avatar
      timazarj
      Helper II
      1 year ago

      Thank you, but it's not working:

       I tried both Today() and no default value for  ToLinesExpirationDate, but received this error
      Query (1, 88) DAX comparison operations do not support comparing values of type Date with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.
      ----------------------------
      Query execution failed for dataset 'ToLinesExpirationDate'.
      ----------------------------
      An error has occurred during report processing.
      ----------------------------
      An error occurred during local report processing.

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi timazarj ,
        According to your description, the default value of ToLinesExpirationDate is set to Format((Parameters!ToLinesExpirationDate.Value), “yyyy-MM-dd”), which seems to reference itself. This may cause problems. Try removing the default value expression for ToLinesExpirationDate and then run the report. Also the default value of Format will be is of type string, which doesn't match the datetime type you are quoting. If the parameters are not required, make sure your dataset query can handle null values. If they are required, make sure you provide a valid date before running the report.

        Best regards,
        Albert He

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly