Now my rdlc report is only generating blank rows with multiple pages. I already set my Dataset in Datasources and completed each step process. I even tested it using preview...

I found a workaround this time to bypass the parsing error message. I pasted my query from MYSQL workbench to SRSS query builder, omiting those errors and tried to preview...

Here is the latest Error that occurred:

Thanks for the response, I already followed your changes but still getting the error

I can't seem to find the line code where...

It might be that we need to format the date to remove the time component?

ok tried it, but returns an error again