hexagon logo
Register Sign in
  • Replies 17 replies
  • Subscribers 9 subscribers
  • Views 400 views
  • Users 0 members are here
Options
Related

Automate Generating Reports

acgarcia
Good Morning:

I've searched the forum but didn't find what I was looking for. Is there a way to automate generating reports in datapage? In know you can save queries with a specific date range. I can just update the date range for what i'm looking for. My problem is that the tolerances for the features are different. 0.001-0.015". From my experience, with using a saved query, it doesn't keep individual tolerances. So all features are 0.001 or 0.005 or 0.010 and so on.
Parents
  • Everything is stored in the database DP querys it's data from, even the stuff you delete. Connect to the database you created in DP via Visual Studio you can download for free and read up on TSQL... you'll be querying anything and everything straight into your spreadsheet without ever touching DP. You still need a DP license, fyi.

    It takes me less than 10min to setup a report WITH RANGES (min/max) instead of single values with a custom function in excel just write it once and copy/paste function viola done, forever! Updating your Job# cell will query data for that job number. This is a small example of what you can do.
    ...


    Dude, I wonder if you can check something. Using Visual Studio to connect to the database, is it possible to adjust things like the MMC/RFS tags, or to modify bonus tolerance in a way that actually updates the values?

    For reference, if you import a TP dimension that has MMC set, the value that DataPage uses to calculate bonus tolerance (for reporting TP tolerance on the report) is the value that it receives on import. It will not update the bonus tolerance calculated on the report (changing the TP tolerance based on the feature MMC) if you change the values though the Data Editor tab. And DataPage techs confirmed that this is how it was programmed to function, and as usual, it will not be changed, because the DataPage people don't give a fk about their customers.
Reply
  • Everything is stored in the database DP querys it's data from, even the stuff you delete. Connect to the database you created in DP via Visual Studio you can download for free and read up on TSQL... you'll be querying anything and everything straight into your spreadsheet without ever touching DP. You still need a DP license, fyi.

    It takes me less than 10min to setup a report WITH RANGES (min/max) instead of single values with a custom function in excel just write it once and copy/paste function viola done, forever! Updating your Job# cell will query data for that job number. This is a small example of what you can do.
    ...


    Dude, I wonder if you can check something. Using Visual Studio to connect to the database, is it possible to adjust things like the MMC/RFS tags, or to modify bonus tolerance in a way that actually updates the values?

    For reference, if you import a TP dimension that has MMC set, the value that DataPage uses to calculate bonus tolerance (for reporting TP tolerance on the report) is the value that it receives on import. It will not update the bonus tolerance calculated on the report (changing the TP tolerance based on the feature MMC) if you change the values though the Data Editor tab. And DataPage techs confirmed that this is how it was programmed to function, and as usual, it will not be changed, because the DataPage people don't give a fk about their customers.
Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement