N
NitinG
Guest
I am trying to track test data for patients across a given time span. There are four different parameters being tracked. I have a table which stores Patient Identification Information, and another table that stores the actual data values for each patient for each test (the four different types of tests are differentiated by a "SampleTypeID" field in the Sample Data table).
I would like to generate a line graph whereby the user can select a patient and a date range, and see the values of all four parameters over time on one graph. I created a query which prompts the user for a Patient ID# and a beginning and end date. This query runs properly and is able to return the expected data when it is run. I am also able to generate "simple" reports from this query that simply list the parameter values for the selected patient across the specified date range. I then tried to use the chart wizard to create a report that would pull the information from this query (after asking the user to select a patient and date range) and output the pertinent information to a line graph.
***Here's the Problem***
After creating the chart in the report using the Chart Wizard, I tried to run the report, and got the following error message: "The Microsoft Jet database engine does not recognize '[Enter Patient ID]' as a valid field name or expression." [Enter Patient ID] is the criteria i have specified in the original query so that the user may select one specific patient record. Do I need to change this to something more "SQL-friendly" so that Jet can work with it? or is there something else i need to do before the report will chart data from my query correctly?
After I click through the first error message, I get a follow-up message that reads in part, "An error occurred while sending data to the OLE server (the application used to create the object). You may have tried to send too much data. If you're creating a chart and the chart is based on a query, modify the query so that it selects less data. If the chart is based on a table, consider basing it on a query instead so that you can limit the data."
I've only populated this database with two patients w/ four data points apiece, so it seems unlikely that i'm overwhelming the system with data. Any help would be greatly appreciated.
I would like to generate a line graph whereby the user can select a patient and a date range, and see the values of all four parameters over time on one graph. I created a query which prompts the user for a Patient ID# and a beginning and end date. This query runs properly and is able to return the expected data when it is run. I am also able to generate "simple" reports from this query that simply list the parameter values for the selected patient across the specified date range. I then tried to use the chart wizard to create a report that would pull the information from this query (after asking the user to select a patient and date range) and output the pertinent information to a line graph.
***Here's the Problem***
After creating the chart in the report using the Chart Wizard, I tried to run the report, and got the following error message: "The Microsoft Jet database engine does not recognize '[Enter Patient ID]' as a valid field name or expression." [Enter Patient ID] is the criteria i have specified in the original query so that the user may select one specific patient record. Do I need to change this to something more "SQL-friendly" so that Jet can work with it? or is there something else i need to do before the report will chart data from my query correctly?
After I click through the first error message, I get a follow-up message that reads in part, "An error occurred while sending data to the OLE server (the application used to create the object). You may have tried to send too much data. If you're creating a chart and the chart is based on a query, modify the query so that it selects less data. If the chart is based on a table, consider basing it on a query instead so that you can limit the data."
I've only populated this database with two patients w/ four data points apiece, so it seems unlikely that i'm overwhelming the system with data. Any help would be greatly appreciated.
