MAS 90 and MAS 200 – Filename extraction in Crystal Reports

By Brett Zimmerman • October 7th, 2009

In addition to using the “File Path and Name” Special Field in Crystal Reports, have you ever wished you could just show the Filename? You can with this formula:

Mid (Filename ,InstrRev (Filename,”\”) + 1 )

http://tinyurl.com/y8u8gtk

Posted by Brett Zimmerman of The Fitzgerald Group.

Comments(0) Crystal Reports, ERP Tools, FAQ, Sage, Sage MAS 200, Sage MAS 90, The Fitzgerald Group

This website uses IntenseDebate comments, but they are not currently loaded because either your browser doesn't support JavaScript, or they didn't load fast enough.

You must be logged in to post a comment.

« Job Ops standalone Purchase Agent module for MAS90 and MAS200 v4.30 [Sneak Peek] | Home | Reversing a Payroll Check from a closed quarter in MAS 90 »

Need help? Click Here.

Recent Popular Notes

Epicor Earnings Call Wrapup – 7/30/2010

July 30, 2010
by: Wayne Schulz • Epicor, Publishers, Schulz Consulting

90 Minds Consulting On Facebook

July 24, 2010
by: Wayne Schulz • 90minds

Sage MAS 90/200 Quick Tip from Zip: Excel Sheets Separator

What will Sage ERP MAS Intelligence include?

July 9, 2010
by: Beth Bowers • Beth Bowers, Sage MAS 200, Sage MAS 90, Sage MAS 90 Extended Enterprise Suite, add ons, sage business insights intelligence

MAS 90 And The Case Of The Disappearing Single User License – Solved?

July 1, 2010
by: Wayne Schulz • 90minds, News, Sage, Sage MAS 90

Sage MAS 90/200 FYI from Zip: v4.40 Product Update 2 (PU2)

June 24, 2010
by: Brett Zimmerman • Consultant, FAQ, Sage MAS 200, Sage MAS 90, Sage MAS 90 Extended Enterprise Suite, Schulz Consulting, Uncategorized

Using MAS90 and MAS200 Customizer Scripting to show a document related to an inventory item

June 14, 2010
by: Mark Chinsky • Clients First Business Solutions, Sage MAS 200, Sage MAS 90, Uncategorized

MAS90 Gets An Updated Roadmap

July 21, 2010
by: Wayne Schulz • FAQ, Sage MAS 200, Sage MAS 90, Schulz Consulting

Sage MAS 90/200 Quick Tip from Zip: Excel Sheets Separator

What will Sage ERP MAS Intelligence include?

July 9, 2010
by: Beth Bowers • Beth Bowers, Sage MAS 200, Sage MAS 90, Sage MAS 90 Extended Enterprise Suite, add ons, sage business insights intelligence

Sage MAS 90/200 FYI from Zip: v4.40 Product Update 2 (PU2)

June 24, 2010
by: Brett Zimmerman • Consultant, FAQ, Sage MAS 200, Sage MAS 90, Sage MAS 90 Extended Enterprise Suite, Schulz Consulting, Uncategorized

Using MAS90 and MAS200 Customizer Scripting to show a document related to an inventory item

June 14, 2010
by: Mark Chinsky • Clients First Business Solutions, Sage MAS 200, Sage MAS 90, Uncategorized

90Minds member, Clients First holds Spring MAS90/200 User Group-Video Here

June 4, 2010
by: Mark Chinsky • Clients First Business Solutions, Sage MAS 200, Sage MAS 90, Uncategorized, jobops

Review Prior Stories and Articles
- 90minds (5)
  - Consultant Bios (1)
- Dynamics (3)
  - Dynamics AX (1)
  - Dynamics GP (1)
  - Dynamics NAV (1)
  - Dynamics SL (1)
- ERP (10)
  - News (9)
- ERP Tools (11)
  - Crystal Reports (6)
  - FRX Report Writer (1)
  - sage business insights intelligence (2)
- General Technology (4)
- mas90 consultants (58)
  - Alnoor Cassim (1)
  - Beth Bowers (15)
  - Bill Pfahnl (2)
  - Bottom Line Software (1)
  - CG Consulting (1)
  - Clients First Business Solutions (9)
  - DSD Business Systems (6)
  - Ennis (1)
  - Giving Tree Consulting (1)
  - MIS Group (1)
  - Pellum & Associates (1)
  - Quantera Systems (2)
  - Schulz Consulting (15)
  - Service World Computer Center (1)
  - The Fitzgerald Group (9)
  - Warrior Consultant Group (1)
- Publishers (1)
  - Epicor (1)
- Sage (103)
  - add ons (10)
  - Consultant (9)
  - Extended Solutions (6)
  - FAQ (22)
  - MAS 200 Extended Enteprise Suite (7)
  - Master Developers (3)
  - Sage Corporate News (3)
  - Sage FAS (2)
  - Sage MAS 200 (90)
  - Sage MAS 500 (7)
  - Sage MAS 90 (94)
    - jobops (3)
  - Sage MAS 90 Extended Enterprise Suite (14)
- SAP Business One (43)
  - Alerts (11)
  - Customization (27)
  - Financials (5)
  - Formatted Search (14)
  - Import/Export (2)
  - Queries (23)
  - Reporting (15)
  - UDF (User Defined Fields) (2)
  - XL Reporter (3)
- Uncategorized (23)
- Video Content (5)
Hot Topics
90minds boston ca Connecticut Crystal ct Custom Office Extended Solutions Frx maine mas 90 mas 200 mass microsoft new hampshire new jersey New York nh nj ny pa paperless office payroll pennsylvania providence Reporting rhode island ri Sage Sage MAS 90 Sage MAS 90 Sage MAS 200 Sage MAS 200 Sage MAS 500 SAP Business One Schulz Consulting the fitzgerald group Tips Tips and tricks Tricks vermont video VIsual Integrator vt wayne schulz

iCompany Theme by Glitschka Studios • 90 Minds is an independent organization not affiliated or sponsored by any vendor.• All trademarks and company names used within this site are copyright their respective owners. • Information contained on this site is offered as-is with no guarantee that it is the most current or correct information.• You assume all risks of use.•
Contact Us: info@90minds.com• Entire contents (c) 2008 90 Minds and no portion may be re-used in any form without written permission • Technorati Profile

MAS 90 and MAS 200 – Filename extraction in Crystal Reports

Leave a Comment

Review Prior Stories and Articles

Hot Topics