Search results for query: *

Hi All, re: Failed to retrieve data from the database. Details HY000:unknown error (7) [Database Vendor Code: 7 ] I have a report I have developed that works well as it currently stands. It is using a SQLite3 ODBC driver and was created with CR 2011. The report currently refreshes to approx...

Hi All, We are looking to print a side by side graph for a monthly value compared to the same month last year. This has been completed based on two change of fields (formulas for the year and month of the date field we are graphing), our issue is we want the data labels for each riser to...

Hi Gordon, I figured it out. I sorted the data by read date descending and created a redim preserve on the read type. Then I created a formula with the redim preserve startswith 'ES, ES, ES, ES,' and used it to suppress the undesirables. Thanks, Paul

Hi Gordon, The query worked like a charm. I had to rewrite it for SQLLITE which uses LIMIT N after the order by instead of TOP N in the select, but worked the same none the less. It's not my favorite syntax. I now have a different environment to apply this concept to. It's a Visual FoxPro dbf...

Thanks Gordon! I will try that.

correct Peter, I would only need to see estimate estimate estimate estimate for the last four read dates. we could disregard as soon as one of the last four consecutive reads was not an estimate. Skip: the balance of the fields are negligible as I can pull every column as long as I...

Hi All, Help! I have a report that is required to capture 4 consecutive read types. For example; There are three read types, there could be more but we only care about estimate reads in this case. Actual Read Estimate Final Each reading date will have one read type assigned. I need to...