Dallas Fort Worth ASUG

We had a great turnout and got to meet lots of new people. It was great to see Alan Mayer, David Rathbun, and Jon Le.

The ASUG team including Melissa Berg-Baker was ready to discuss new ideas on how to make all the groups even better.

We were able to demonstrate the Report Launch products and present on Migration Best Practices.

11 states and 2 to go

Counted the number of states visited this year. We often drive to the client site with the family so I can limit the time away from the wife and kids. I think last year we did pretty much the same. I was encouraged this year that this type of family centered business should be a part of the company. Another one of our team mates Don did a similar trip to San Diego. The family played in the ocean while he worked and they met up after work. We are mid trip to North Carolina with just that litle state of Tennessee to go. Merry Christmas

Split and Search

Presented at the GBN conference on a way to provide users the way to enter a comma delimited list of values into a prompt and then use a database function to split those values in order to return the list as a table that can be used in joins.

WHERE rs_tb_cms_groups.group_ID IN ( SELECT rs_tb_cms_groups.group_ID FROM @Prompt('Group
Name ','A',{'California','New York'},mono,constrained,not_persistent,))

If anyone wants the full article including the Oracle and SQL server code please contact Kevin McManus at answers@mcmanusconsulting.com

GBN/BOUG Conference 2009 Dallas

Best Business Objects conference I have been to. What as missing in free entertainment was replaced with better content. More in depth training on Xcelsius, Universe Design , web intelligence and Crystal Reports.

Supported Crystal HTML Tags

Question of the Day

The supported HTML tags are:
" html
" body
" div (causes a paragraph break)
" tr (causes only a paragraph break; does not

preserve column structure of a table)
" span
" font
" p (causes a paragraph break)
" br (causes a paragraph break)
" h1 (causes a paragraph break, makes the font bold

& twice default size)
" h2 (causes a paragraph break, makes the font bold

& 1.5 times default size)
" h3 (causes a paragraph break, makes the font bold

& 9/8 default size)
" h4 (causes a paragraph break, makes the font bold)
" h5 (causes a paragraph break, makes the font bold

& 5/6 default size)
" h6 (causes a paragraph break, makes the font bold

& 5/8 default size)
" center
" big (increases font size by 2 points)
" small (decreases font size by 2 points if it's 8

points or larger)
" b
" i
" s
" strike
" u
The supported HTML attributes are:
" align
" face
" size
" color
" style
" font-family
" font-size
" font-style
" font-weight

Question of the day

Here are the product names going back before all the mergers and today.

Company 1: Business Objects - Business Objects 6.X
Company 2: Crystal Decisions - Crystal Enterprise 10
Company 3: Infomersion - Xcelsius

Company: Mergers with BusinessObjects = BusinessObjects
BusinessObjects Enterprise XI (aka BOE XI Release 1)
Content : Crystal + Deski

BusinessObjects Enterprise R2 (aka BOE XI Release 2)
Main Content: Crystal+ Webi + Deski + Xcelsius + Live Office

Company: Acquisition of Business Objects by SAP = SAP BusinessObjects
SAP Business Objects XI 3.X (Currently 3.1 Service Pack 2)
This version is unofficially called ?BusinessObjects XI R3?

Kevin McManus
www.mcmanussoft.com

Collaboration

Two forms of collaboration reviewed

a) Freeform collaboration
box.net
docs.google.com

b) task tracking software,
includes - team collaboration, online calendar, document sharing, and file management

Pretty Simple: great gantt charts
http://www.5pmweb.com/videos/5pm_Quick_Introduction.htm

Very detailed Project Management
http://www.proworkflow.com/PWF_PLUG_time_tracker.cfm

several link with Basecamp and add specialty features

Interesting mind map of tools http://www.mindmeister.com/maps/show_public/12213323

Out plan is to continue a best of breed approach

TimeLaunch
Integrates to Outlook for migrating tasks to your calendar and your calendar to your timesheet
Integrates to Googledocs for client project collaboration
Integrate with Virtual Timecard timesheet system for automated submission, approval process (Timecard integrates with our Quickbooks invoicing already)
Integrates with ReportLaunch for reporting and automated billing in some cases.

Kevin McManus
www.mcmanussoft.com