To all who knows more about this than me,
I am making a report in Graphic Tables and am getting an error that reads "Specified records returned no data." I have checked and rechecked the code and am thinking it has something to do with how it is reading with the input. If I am wrong please let me know and if anyone has any ideas again please let me know. I am using User System Data to help make the code a little cleaner looking, and the report is a field density test report.
Thanks for the input,
jwilliams84-nashville
Whenever you get the error "Specified records returned no data" in OUTPUT, it means that no records containing all of the data needed to generate the report were found.
Look at the OUTPUT window DATA SOURCE area. Under the Source File field is a field to pick the individual records you want to include on output. The identifying fields are listed above it. For example, for an ATTERBERG Graph report, this might be "Borehole ID, Depth". These fields are defined for each report in the MAIN tab Key Set property. Both those pieces of data must exist in the project for at least one record, which must also include data for the Independent and Dependent values being graphed. Otherwise the "no data" error will occur.
If you are filtering data with a standard or range filter in the Graph output, the filter may be so restrictive that no record meets its criteria. That is the other common reason you will see the "Specified records returned no data" error.
Mr. Cummings,
There is only one Key Set and it is PointID,, which it is found in the input. As for the independent and dependent values, as of now there is no graph I am just putting in text and all of the inputs are filled in to come up with the calculations. Do I need to have a tab for average diameter and for weight of soil in pounds or can I just make that calculation and conversion be done on the sheet as an output.
Thank You
For all reports, you must plot/output some data in the body of the report from the project database in order for the report to be generated in OUTPUT.
You will eventually be defining some Independent and at least one Dependent values to be reported in the graph report - these can be Expressions (User System Data items, complex expressions or simple data locations or even specific numbers). At that time, you will probably stop getting this error.
In the meantime, you can Preview the Graph report in REPORT DESIGN to check the position, size and color/weight of report elements outside the graph data frame.
I used User System Data to help clean up the formulas used to calculate the output. The output expressions I used are User System Data, calc function, and data locations. I appreciate you getting back to me on this. I pretty much did another report just like this one and it worked fine, just this report wants to give me some trouble.