In your documentation for report builder and wp data tables, it says to create variables when you create a report. The variables are ${X}. During the process, you link this report to a table you create in wp data tables.
How does the report builder know which column is ${X}.
Since you are creating a report from the related table, the information sent to the variables is defined by you and the report will only pull what you tell him to pull. You won't be able to put an unrelated variable into the report and expect results.
Please have a look at our documentation on how to prepare templates for more detailed information on how to prepare variables as well
I created a table. it has two fields. the first field is due date which is a date. origin header is duedate. The second field is title of invention which is a string. origin header is titleofinvention.
I created the attached template.
for the duedate, I could get it to pull the data from the table if I used ${duedate.total}.
I could not get it to pull the data from the table if I used ${duedate.all}. Actually, it sent back an error code. I also could not get it to pull the data from the table if I used ${duedate}. The downloaded template just inserted ${duedate}.
For the title of invention, I was unable to get it to pull the date. I tried all three variants. ${titleofinvention}, ${titleofinvention.all}, ${titleofinvention.total}.
Since both of these are string columns you wouldn't be able to use variables for float and integer columns .total
Can you please tell us more about the error you get when you use this variable ${duedate.all} can you provide us with a screenshot?
Can you share the source file used to create the table so we can try and recreate the issue on our end? Do you have a link to the front end where we can test the described behavior?
In your documentation for report builder and wp data tables, it says to create variables when you create a report. The variables are ${X}. During the process, you link this report to a table you create in wp data tables.
How does the report builder know which column is ${X}.
Hi James
Since you are creating a report from the related table, the information sent to the variables is defined by you and the report will only pull what you tell him to pull. You won't be able to put an unrelated variable into the report and expect results.
Please have a look at our documentation on how to prepare templates for more detailed information on how to prepare variables as well
https://wpreportbuilder.com/documentation/create-template-for-wordpress-report-builder/
Do let us know if you need further assistance.
thank you.
different question.
I created a table. it has two fields. the first field is due date which is a date. origin header is duedate. The second field is title of invention which is a string. origin header is titleofinvention.
I created the attached template.
for the duedate, I could get it to pull the data from the table if I used ${duedate.total}.
I could not get it to pull the data from the table if I used ${duedate.all}. Actually, it sent back an error code. I also could not get it to pull the data from the table if I used ${duedate}. The downloaded template just inserted ${duedate}.
For the title of invention, I was unable to get it to pull the date. I tried all three variants. ${titleofinvention}, ${titleofinvention.all}, ${titleofinvention.total}.
Please help.
Hi James
Since both of these are string columns you wouldn't be able to use variables for float and integer columns .total
Can you please tell us more about the error you get when you use this variable ${duedate.all} can you provide us with a screenshot?
Can you share the source file used to create the table so we can try and recreate the issue on our end? Do you have a link to the front end where we can test the described behavior?