SSRS - Adding a New Parameter to Job Traveler

Kinetic ERP
1

I added a new Report Parameter called NewPgPerResource to the JobTrav - ReportParam Data View. I wired the column to a prompt on Job Traveler screen. I added the new column to the JobTrav.RDL for RptParameter query as well as added as a query field.

However, I’m getting the error the column doesn’t exist. What am I forgetting? In the olden days I would set the parameter on the adapter when submitting to Agent.

Any help appreciated!

2

I haven’t used parameters in a RDL like that before, but you may need to add the field in the parameters section of the dataset properties. You added the field to the query and fields, but there is also a parameters section below that. Sometimes dataset changes need a save/close/upload/download (superstition) cycle to work properly.

3

Thank you for responding, Nate. Here’s some screenshots – I tried your suggestion as well. Redownloaded, saved and reuploaded.

AddReportParam
AddReportParam1526×796 37.9 KB

WiredToJobTrav
WiredToJobTrav1891×987 59.6 KB

RptParam_DS
RptParam_DS1309×706 71.1 KB

RptParam_Field
RptParam_Field1129×816 48 KB

4

Hello Donna,

Were you able to figure out the error message you were getting? I am having the same issue.

5

I found what was causing the issue. For the newly added BAQ parameter the report data definition criteria mapping was missing the Control Type, Control Name, and Control Data Type values. After populating them the error message disappeared.

image
image1806×833 91 KB

6

Hi, Mike. Sorry just saw your notes. I had not resolved it. I will try your solution. Thank you!

7

No worries.
Now I have another issue, the date parameter is displaying as
CureDate_P: “2000-01-01T00:00:00”.
I will create a new topic for this.

8

I resolved the date format issue also. Just changed the BAQ parameter date format to {datetime}.

image
image537×494 10.9 KB