hexagon logo
Register Sign in
  • Replies 17 replies
  • Subscribers 9 subscribers
  • Views 340 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.

    $B$4 = Part#
    $M$4 = Job#
    "D"&$B24&"% = D10% = D10_1 thru D10_4
    "DF" = Dimensions extension for diameter from a True Position dimension command 

    =PERSONAL.XLSB!QuerySQL($B$4,$M$4,"D"&$B24&"%","DF")


    pulls D10.DF (Dimension #10) from 20 pcs
    Excel Spreadsheet:










    10 pg.1, Zone F.7 Diameter 4X Ø.129 +.005/-.001 THRU 0.139 0.119 .1291 - .1297

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.

    $B$4 = Part#
    $M$4 = Job#
    "D"&$B24&"% = D10% = D10_1 thru D10_4
    "DF" = Dimensions extension for diameter from a True Position dimension command 

    =PERSONAL.XLSB!QuerySQL($B$4,$M$4,"D"&$B24&"%","DF")


    pulls D10.DF (Dimension #10) from 20 pcs
    Excel Spreadsheet:










    10 pg.1, Zone F.7 Diameter 4X Ø.129 +.005/-.001 THRU 0.139 0.119 .1291 - .1297

Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement