Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Webfocus vs. Crystal Reports

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Webfocus vs. Crystal Reports
 Login/Join
 
Member
posted
Hi,
i'm new at Webfocus i've been using it for about 3 months now and never used Crystal Reports. i would like your opinion
on Developer Studio vs. Crystal Reports.
i appreciate your feedback.
tami


WebFOCUS 7.6.0
Windows
Output: Excel, HTML and PDF.
 
Posts: 15 | Registered: October 10, 2007Report This Post
Virtuoso
posted Hide Post
Both quite similar as far as the GUI goes. Crystal makes it a little easier to add graphics, lines, boxes and a few other niceties as far as report organization. To me there are two overwhelming differences: One is that Crystal is basically an SQL-based tool whereas WF is more. And the underlying use of the FOCUS language is far more powerful, but still allows for those used to SQL to use it. Also the scripting language (Dialogue Manager) available in WF, although not available in a GUI, extends WF's capabilities DRASTICALLY - especially with using &variables. There's a couple of cents worth--


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Master
posted Hide Post
welcome to the group Tami K!
Could you be more specific about what you need out of your reporting/BI software, or what industry you're in? That may help taylor an answer better suited to your needs.

This issue has come up for a client of mine recently as well, so I'm thinking that a write up may be of help to many folks.

I was a Crystal Reports / .NET Developer in a previous job. The difference between the two technologies is very different.

The drawbacks of Crystal...
Crystal Reports is a *fairly* static reporting system on it's own, with little olap-type functionality, unless you integrate your reports with a programming language such as .NET. Very few users will create their own reports using the crystal reports development tool, it's more of a developer-level job and reactive reporting. Business Objects, who bases their entire Business Intelligence tool off of crystal reports is a different ballgame than plain old crystal reports.

When it comes to creating reports, you have more control with crystal as far as form layout, but it takes longer to build the reports. At the summit of my career I honestly felt like I could churn out any report in Crystal in less than an hour as long as I had detailed enough specs. In webfocus, creating a report can take seconds with a stylesheet. It's an incredible feature that would benefit a Crystal developer.

Crystal is touted to be a "business intelligence" tool, but I don't see that happening on it's own. There's packages that encapsulate the reporting software that make it an actual BI tool, rather than a simple replacement for a spreadsheet, such as the Crystal Xcelsius product. We did all of our development using .NET and it took a group of four to meet the demand of a publicly-held 300 location restaurant. It took us over six weeks to build a reportcaster like ASP program that wasn't as customizable.

The advantages...
Crystal reports is better documented and more widely used than Webfocus. Doing a simple google search 3,940,000 results were given for developing in crystal reports versus only 229,000 for developing in webfocus. The majority of documentation for webfocus, I've found, is within the informationbuilders.com domain and focal point. This, in my experience, is very frustrating when I started into webfocus. Sometimes you simply don't know the term you're looking for.
Almost all Visual Basic programmers have used Crystal at some point. Again, it is integrated with Microsoft very well. Also note, many pseudo-report-developers and 'power users' are used to MS Access reporting, which acts like a sort of stripped down version of Crystal.

Crystal reports can run on any machine, does not require a server or any real configuration once you point it to your database, you're done. I've had a 10 employee logistics company client who used a postgres database on windows and crystal reports to handle all of their reporting. Their single license for Crystal Reports was around $500.

The most frustrating thing you'll find with webfocus is that the report painter is not a what-you-see-is-what-you-get developer. In crystal, you can specify a fields location down to the pixel and it has some real advantage in the desktop publishing arena. It took me, at novice level, nearly a month to build an invoice template in webfocus using the grid, and it still never ended up looking perfect.

If you think of MIS software as a toolbox, and grab the right tool for the job at hand then you're best off.


Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
 
Posts: 611 | Registered: January 04, 2007Report This Post
Expert
posted Hide Post
Two comments.

Darin, in 76x there is a 'GUI' for Dialogue Manager available in the Procedure Viewer. The reason I put it in quotes is because you actually need a working knowledge of DM to use it as you have to know where to put the DM statements in your code.

Jason,

Your comments are excellent, thorough, and well thought out. However, it is important to also note that WebFOCUS is a highly scalable tool that can run on a number on different platforms and manage lots of data sources and large amounts of data with native adapters vs. ODBC. We should not compare the products based on the developer tool alone.

You made a good point about the BI aspects. At this company, WF is a BI tool, not a TS tool, and the developers are business people not IT programmers.

So, Tami, enjoy!!! You are now part of a special club.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Expert
posted Hide Post
I echo Miss Ginny...
Comparing WF to Crystal is like buying a car based on the radio buttons ...
You may be real comfy if you can handle the music system without taking your eyes off the road, but what do you do when you need to kick it in to passing gear, and you've only got 4 cylinders.
Crystal is a real nice tool, but its a honda civic. Now, you've got a saturn 5 rocket. Enjoy it.

This message has been edited. Last edited by: susannah,




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Virtuoso
posted Hide Post
Crystal was given for free by many platform sellers. The ownership was two years ago bought by Business Objects.
If you want to compare the functionality on all levels I agree with Susannah, it's not the proper comparison. Honda civic?? it's not even a car, I would think of a bike....(but I'm dutch, we see bikes everywhere)




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Virtuoso
posted Hide Post
Interesting someone here who was a big Crystal person and now loves WebFocus compared it to a Honda Civic and a Cadillac. The Civic might get you where you going..but you have no power to get on the Freeway...and no comfort and Style.
By the way...I travel 75 miles round trip to get to work daily...so I own a Civic..the new ones aren't the little boxes they used to be
and it gets 38 miles a gallon...so I'm not styling....but with gas prices the way they are..I'm smiling a bit...I have a spoiler on it for a little style Wink


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
<Shane>
posted
Comparing WebFOCUS to Crystal Reports isn't really comparing apples to apples. It's like comparing Microsoft Access to Oracle. Crystal Reports isn't the full BI solution like WebFOCUS is. To do a better comparison, compare WebFOCUS to Cognos or Business Objects. However, I doubt you'll get too many supporters of the latter 2 on this forum.

Shane
 
Report This Post
Expert
posted Hide Post
moi aussi. i had a civic all summer and loved that zippy little sucker ... but the first day i got my 6 cylinders back, was i happy.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Member
posted Hide Post
Thank you everyone for your input on this.
I now have a better understanding.
tami


WebFOCUS 7.6.0
Windows
Output: Excel, HTML and PDF.
 
Posts: 15 | Registered: October 10, 2007Report This Post
Master
posted Hide Post
I'm in Kansas, so I'm not really sure what to say about a comparison of a civic or what a '6-cylinder' is. Now, if you want to compare Ford, Chevrolet or Dodge trucks then maybe I'd be able to keep up with the conversation. Wink

As I stated before there's a different tool for each job. I'm never going to advise a small business to consider purchasing something like webfocus when I can build a simple ms access database to handle their reporting needs.


Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
 
Posts: 611 | Registered: January 04, 2007Report This Post
Virtuoso
posted Hide Post
But then if you're a small business you could probably get a single license for Dev Studio and still use WF to take care whatever reporting needs you have with access to multiple data sources. Even small offices seldom have a single data source. You don't need the full WF-Server-available-to-the-world-via-the-internet to do WebFOCUS reporting.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Expert
posted Hide Post
excel still goes a long way!




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Expert
posted Hide Post
quote:
excel still goes a long way!

Yes, all the way to the 65535th row .... and then where? Wink

Also, you Guys ought to appreciate your very low "gas" prices. Ours is currently topping the equivalent of $2.10 a litre (note the correct spelling! Wink) Oh, and "petroleum" is a liquid, so how can you call it "gas"? Razzer (Yes, I know it's an abbreviation of gasoline)

Prarie, I applaud you amongst your fellow country folk on having a vehicle that does more than 12 mpg (esp. in Texas!). The sooner more people act that way the better the environment!! BTW, that "spoiler" you mention is actually a handrail for when it breaks down! Cool

T

This message has been edited. Last edited by: Tony A,



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Expert
posted Hide Post
quote:
... with access to multiple data sources ...

but of course you would need to ensure that the data adapter licences required to access those data sources are in place!! Does DS come with any adapters at all?

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Expert
posted Hide Post
quote:
Does DS come with any adapters at all?


For a DS standalone environment, you would get FOCUS, flat, and could get away with ODBC. The number of adapters in the full WebFOCUS are based on a license key for the reporting server, which in no way tells you which ones you can use just how many. There is no such key for the embedded server that comes with Dev. Studio. So if you can get to the data source with ODBC, you'll be in like Flynn.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Guru
posted Hide Post
although access comes in for some stick its actually a great solution for a small enterprise or a place with a small amount of records; i think WebFOCUS is head and shoulders above access in what you can do with it (it is a 4gl Language and not a Database after all) but would struggle to sell it to a small enterprise for whom ms access would be more than enough.

excel is a pain in that it caps at 65,000 rows but the alternatives (at the time i used it) which offered up to a million rows (the works equiv i believe don't quote me) were very unstable and i went back to struggling with Excels' row limit almost immediately...it was a no brainer- i wonder if 6 years later the competitors have sorted this.

ironically one of the things that got me initially excited about WF was the excel integration. Big Grin


Developer Studio 7.64
Win XP
Output: mostly HTML, also Excel and PDF

"Never attribute to malice that which can be adequately explained by stupidity." - Heinlein's Razor
 
Posts: 285 | Location: UK | Registered: October 26, 2007Report This Post
Virtuoso
posted Hide Post
Actually for a standalone environment, you get access to any supported data source you want and as many as you can use. But it can only be accessed from that one box where DS is installed. There is no "adapter" licensing for DS standalone.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Expert
posted Hide Post
you know, nubi, that row limit has been increased in excel 2007 to some astronomical number .. some 'everyone needs 2gig in their desktops' kind of number...




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Guru
posted Hide Post
quote:
Originally posted by susannah:
you know, nubi, that row limit has been increased in excel 2007 to some astronomical number .. some 'everyone needs 2gig in their desktops' kind of number...


thats great stuff, kind of expected but good they have sorted it-


Developer Studio 7.64
Win XP
Output: mostly HTML, also Excel and PDF

"Never attribute to malice that which can be adequately explained by stupidity." - Heinlein's Razor
 
Posts: 285 | Location: UK | Registered: October 26, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Webfocus vs. Crystal Reports

Copyright © 1996-2020 Information Builders