Author Topic: Wildcard Reports  (Read 3171 times)

0 Members and 1 Guest are viewing this topic.

Offline jmerchTopic starter

  • Premier Member
  • *****
  • Posts: 2297
  • Country: us
  • Gender: Male
Wildcard Reports
« on: Mar 02, 2018, 16:22:19 PM »
I thought I had this bookmarked but can't find it.

What is the magical way to create a report and when it's ran it asks the user for what to filter? I know it involves placing certain wildcard text in the Filter portion of the field. Then when you run the report, a dialog box pops up and asks the user to enter data, then produces the report filtering that data. Can anyone point me to this?

TIA!
Intel i7-6700K @ 4 GHz - 32GB RAM - NVidia Quadro M5000 - W10x64 - MEP & FABRICATION 2014/2017 - NAVIS 2017 - REVIT 2017.1

Offline Darren Young

  • Premier Member
  • *****
  • Posts: 2081
  • Country: us
  • Gender: Male
    • BIM There Done That.
Re: Wildcard Reports
« Reply #1 on: Mar 02, 2018, 16:24:16 PM »
Never knew this was possible.

Offline jmerchTopic starter

  • Premier Member
  • *****
  • Posts: 2297
  • Country: us
  • Gender: Male
Re: Wildcard Reports
« Reply #2 on: Mar 02, 2018, 16:31:50 PM »
1. Wow, I will take that as a compliment. I figured you had this whole software down from A to Z :) ha ha...
2. Get ready to learn, b/c I just found it!

In your report, whatever field you're going to ask the user to filter, go to the Filter tab and select the field, equals, and some type of name easy for the user inside the carrots. Example:

Item Custom Data Field "Manufacturer" = <Manufacturer>

**Subsequently, you can make the equals sign any of the available signs..I just found out**
« Last Edit: Mar 02, 2018, 16:35:41 PM by jmerch »
Intel i7-6700K @ 4 GHz - 32GB RAM - NVidia Quadro M5000 - W10x64 - MEP & FABRICATION 2014/2017 - NAVIS 2017 - REVIT 2017.1

Offline davidratx

  • Premier Member
  • *****
  • Posts: 1401
  • Country: us
  • Gender: Male
Re: Wildcard Reports
« Reply #3 on: Mar 02, 2018, 16:52:53 PM »
1. Wow, I will take that as a compliment. I figured you had this whole software down from A to Z :) ha ha...
2. Get ready to learn, b/c I just found it!

In your report, whatever field you're going to ask the user to filter, go to the Filter tab and select the field, equals, and some type of name easy for the user inside the carrots. Example:

Item Custom Data Field "Manufacturer" = <Manufacturer>

**Subsequently, you can make the equals sign any of the available signs..I just found out**

You just blew my head up!
David Ronson
TDIndustries Director of Construction Technologies
Windows 10 - Revit - AutoCAD - CADmep - ESTmep - CAMduct - GTP Stratus

Offline jmerchTopic starter

  • Premier Member
  • *****
  • Posts: 2297
  • Country: us
  • Gender: Male
Re: Wildcard Reports
« Reply #4 on: Mar 02, 2018, 16:55:56 PM »
You too?! Dam, I'm on a roll! ha ha ha.
Intel i7-6700K @ 4 GHz - 32GB RAM - NVidia Quadro M5000 - W10x64 - MEP & FABRICATION 2014/2017 - NAVIS 2017 - REVIT 2017.1

Offline jmerchTopic starter

  • Premier Member
  • *****
  • Posts: 2297
  • Country: us
  • Gender: Male
Re: Wildcard Reports
« Reply #5 on: Mar 02, 2018, 17:01:11 PM »
Before I forget, when the dialog box pops up, you can use an asterisk * as a wildcard to ignore the filter and it will show everything. In testing this, it works with "equals" filters but in my current case I have two fields for the user to enter that instead of "equals", uses greater than and if I enter * in both, it won't report, but I can enter it in one or the other and it will apply it there.
Intel i7-6700K @ 4 GHz - 32GB RAM - NVidia Quadro M5000 - W10x64 - MEP & FABRICATION 2014/2017 - NAVIS 2017 - REVIT 2017.1

Offline Darren Young

  • Premier Member
  • *****
  • Posts: 2081
  • Country: us
  • Gender: Male
    • BIM There Done That.
Re: Wildcard Reports
« Reply #6 on: Mar 02, 2018, 18:05:12 PM »
1. Wow, I will take that as a compliment. I figured you had this whole software down from A to Z :) ha ha...
2. Get ready to learn, b/c I just found it!

In your report, whatever field you're going to ask the user to filter, go to the Filter tab and select the field, equals, and some type of name easy for the user inside the carrots. Example:

Item Custom Data Field "Manufacturer" = <Manufacturer>

**Subsequently, you can make the equals sign any of the available signs..I just found out**

Freak'n awesome. Wonder if this works on the Revit side.


Offline davidratx

  • Premier Member
  • *****
  • Posts: 1401
  • Country: us
  • Gender: Male
Re: Wildcard Reports
« Reply #7 on: Mar 02, 2018, 18:06:27 PM »
Freak'n awesome. Wonder if this works on the Revit side.

It does
David Ronson
TDIndustries Director of Construction Technologies
Windows 10 - Revit - AutoCAD - CADmep - ESTmep - CAMduct - GTP Stratus

Offline VirtualPilot

  • Premier Member
  • *****
  • Posts: 6735
  • Country: us
  • Gender: Male
Re: Wildcard Reports
« Reply #8 on: Mar 05, 2018, 14:15:25 PM »
LOL WHAT? I need to experiment with this!
Santos Cedeno
Pre-Production Mgr - DIXIE Metal Products

Offline edsharp

  • Full Member
  • ***
  • Posts: 241
  • Country: us
  • Gender: Male
Re: Wildcard Reports
« Reply #9 on: Mar 05, 2018, 16:28:49 PM »
Ditto

  thinking of practical uses...but it does work as advertised
 

Offline jcravens

  • Full Member
  • ***
  • Posts: 149
  • Country: us
  • Gender: Male
    • http://www.leecompany.com
Re: Wildcard Reports
« Reply #10 on: Mar 06, 2018, 18:21:45 PM »
Nice. That is killer.
Josh Cravens
Database / Software Configuration Manager
jcravens@leecompany.com
Franklin, TN 37067

Offline DJT

  • Senior Member
  • ****
  • Posts: 318
  • Country: us
  • Gender: Male
Re: Wildcard Reports
« Reply #11 on: Mar 07, 2018, 16:42:30 PM »
Thanks for the Tip. I just used the wildcard to filter out in my reports what has been spooled and what hasn't.
Thanks DJ Live Life like there is no Tomorrow and Thank God for everyday
2018, 2019, 2020, 2021 CADmep, 2019, 2020, 2021 REVIT

Offline cnash

  • Premier Member
  • *****
  • Posts: 1383
  • Country: us
  • Gender: Male
    • William R. Nash Companies
Re: Wildcard Reports
« Reply #12 on: Mar 07, 2018, 19:25:03 PM »
Does this only work for Custom Data Fields? (disclaimer: I have not tested this yet)
Christopher Nash
Operations Software & Process Manager
William R. Nash, LLC.

Offline DJT

  • Senior Member
  • ****
  • Posts: 318
  • Country: us
  • Gender: Male
Re: Wildcard Reports
« Reply #13 on: Mar 07, 2018, 19:38:55 PM »
I just used it with "Item Spool Name." I wanted to filter out what was spooled from what wasn't spooled. My filter was "item Spool Name contains *" to included. If an item has a spool name it is selecting it and including it in the report.
Thanks DJ Live Life like there is no Tomorrow and Thank God for everyday
2018, 2019, 2020, 2021 CADmep, 2019, 2020, 2021 REVIT