Dataset 'Company' Failling: Query execution failed for dataset 'Company'

Kinetic ERP
, ,
1

I am working on a report with two calculated datasets. This report also is pulling two baq’s (one for a drop down list selection and another for the data). This report works perfectly fine in BAQ Report Designer but when in standard report style so I can utilize the drop down list of the reports, it is not working.

Its not the ssrs report to me because it works in the BAQ Report Designer pulling the information.

Any ideas?

Error Example:
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset ‘Company’. —> System.Data.SqlClient.SqlException: Invalid object name ‘Company_(bitcode)’.

2

What do you mean by “in standard report style”, like you have published it to the menu or ?

3

Sorry for the confusion, from what I have seen in kinetic there is a BAQ Report Designer and a Report Style.

I am using Report Style and that is the one having issues, BAQ Report designer is working for the same report.

1 Like
4

You mean you are trying to run it from the preview screen (generate form)? I don’t think that works for BAQ reports. If it works in the baq report designer the next step is to put it on the menu and run it from there.

5

Sorry for my poor explanation of the situation it’s been a couple days of troubleshooting so it’s hard to give a short summary.

I will just leave where I am at right now.

So, I have created a BAQ, this BAQ has calculated fields as well (if that changes the situation at all).

I tried to make a report for a BAQ Report Designer and a standard report style.

The BAQ Report Designer Worked, when using that same RDL file in report style it did not work. So, I wanted to start over in the report style by having another report generated. No matter what I do it will not delete the report for the report style even when starting from scratch. I need to use the report style or what I’m calling “Non BAQ Report Builder Report” in kinetic browser, because I need the user to be able to utilize a drop-down list for the report being utilized. Everything is working besides having the proper report working and definitions, but I can’t grab or find the proper ones because its constantly erroring out unfortunately.

Sorry for all the confusion and delayed response.

6

Its either or. You either use the baq report designer or Rdd/report style. The only time you would use the report style screen AFTER creating the report in the baq report designer is if you want to add a second report style for the same baq report. Once you create the report in the baq report designer then that’s it. Go put it on the menu.

2 Likes