ieuga : Messages : 115-145 of 523

Hello,

I have been working with Crystal 10 since March, so I can't speak for
every feature.  Most of the report upgrades will upgrade with a
simple save.  I discovered that the SQL Queries cannot be edited in
Crystal 10.  You may need to rework some reports to get around this
limitation before you upgrade the report.  There are probably some
3rd Party tools, but I haven't found one.

I noticed that sub-reports run much slower in 10 than 8.5.  I some
cases, I could change the main report and sometimes I had to learn to
live with it.

If you have Non-Expandable users running "compiled" report feature
from 7.0, 8.0 & 8.5, you need to find another solution.  This has
been dropped. The Report Manager inside Expandable is great but you
need a license seat to run the reports.

Enterprise Manager will let you web deploy reports but it gets
expensive quickly.  Buying Crystal reports for every one is not
cheap. There are quite a few 3rd Party Viewers available that do a
good job.

From a non-techical perspective, you need to create a stategy for
reports.  Crystal 8.5 still runs quickly and works well outside
Expandable. But, you have to keep the versions separate.  Once it is
saved in Crystal 10, you can't open it in 8.5.  Will you convert
everyone over to Crystal 10 or will you continue to use some areas
with 8.5?  Be prepared with the right licenses.

...wc

--- In ieuga@yahoogroups.com, "Cheryl Brown" <cbrown@...> wrote:
>
> Hi Jenelle,
>
> There was no response from the user group, but I called and talked
with Expandable Support.  According to the person I spoke with, for
most reports it will be enough to open the report in Crystal 10 and
then save it.  However, some tables have changed, so there may be
some reports that will need editing for that reason.  Also, we have
some reports that use old functions that were available only in
earlier versions of Crystal, so we may need to make changes on
those.  However, I'm hoping that we'll just be able to move the old
dll for that function into the appropriate folder and continue to use
it (as we did when we moved to Crystal 8.5).
>
> I hope that helps!
>
> Cheryl
>
> ________________________________
>
> From: ieuga@yahoogroups.com on behalf of Jenelle Zapico
> Sent: Mon 9/17/2007 5:02 AM
> To: ieuga@yahoogroups.com
> Subject: RE: [ieuga] Upgrading Expandable and Crystal Reports 10
>
>
>
> Cheryl:  We are going to be doing the same upgrade after the first
of October.  We also have many Crystal reports to upgrade to Crystal
10.  I was wondering if you got any responses to your email?  Thanks
in advance for any info you can share.
>
>
>
> Jenelle Zapico
>
> Austin Semiconductor Inc.
>
> 512-719-7265
>
>
>
> From: cbrown.aurora [mailto:cbrown@...]
> Sent: Friday, September 07, 2007 12:45 PM
> To: ieuga@yahoogroups.com
> Subject: [ieuga] Upgrading Expandable and Crystal Reports 10
>
>
>
> We are getting ready to upgrade Expandable to version 8.1.3 from
8.1.1.
> We are using a lot of Crystal reports, and I'm wondering if anyone
has
> had problems with their existing reports not working with Crystal
10 or
> not working with Expandable version 8.1.3? Any input as to your
> experience with this (either good or bad) is greatly appreciated.
>
> Thanks,
> Cheryl Brown
> 916-941-6079
>
>
>
______________________________________________________________________
> This e-mail has been scanned by MCI Managed Email Content Service,
using Skeptic(tm) technology powered by MessageLabs. For more
information on MCI's Managed Email Content Service, visit
http://www.mci.com.
>
______________________________________________________________________
>

#116

From: "Cheryl Brown" <cbrown@...>
Date: Mon Sep 17, 2007 6:56 pm
Subject: RE: Re: Upgrading Expandable and Crystal Reports 10

cbrown.aurora

Thanks Bill.

-----Original Message-----
From: ieuga@yahoogroups.com [mailto:ieuga@yahoogroups.com] On Behalf Of wc_gurusome
Sent: Monday, September 17, 2007 11:48 AM
To: ieuga@yahoogroups.com
Subject: [ieuga] Re: Upgrading Expandable and Crystal Reports 10

Hello,

I have been working with Crystal 10 since March, so I can't speak for
every feature. Most of the report upgrades will upgrade with a
simple save. I discovered that the SQL Queries cannot be edited in
Crystal 10. You may need to rework some reports to get around this
limitation before you upgrade the report. There are probably some
3rd Party tools, but I haven't found one.

I noticed that sub-reports run much slower in 10 than 8.5. I some
cases, I could change the main report and sometimes I had to learn to
live with it.

If you have Non-Expandable users running "compiled" report feature
from 7.0, 8.0 & 8.5, you need to find another solution. This has
been dropped. The Report Manager inside Expandable is great but you
need a license seat to run the reports.

Enterprise Manager will let you web deploy reports but it gets
expensive quickly. Buying Crystal reports for every one is not
cheap. There are quite a few 3rd Party Viewers available that do a
good job.

From a non-techical perspective, you need to create a stategy for
reports. Crystal 8.5 still runs quickly and works well outside
Expandable. But, you have to keep the versions separate. Once it is
saved in Crystal 10, you can't open it in 8.5. Will you convert
everyone over to Crystal 10 or will you continue to use some areas
with 8.5? Be prepared with the right licenses.

...wc

--- In ieuga@yahoogroups.com, "Cheryl Brown" <cbrown@...> wrote:
>
> Hi Jenelle,
>
> There was no response from the user group, but I called and talked
with Expandable Support. According to the person I spoke with, for
most reports it will be enough to open the report in Crystal 10 and
then save it. However, some tables have changed, so there may be
some reports that will need editing for that reason. Also, we have
some reports that use old functions that were available only in
earlier versions of Crystal, so we may need to make changes on
those. However, I'm hoping that we'll just be able to move the old
dll for that function into the appropriate folder and continue to use
it (as we did when we moved to Crystal 8.5).
>
> I hope that helps!
>
> Cheryl
>
> ________________________________
>
> From: ieuga@yahoogroups.com on behalf of Jenelle Zapico
> Sent: Mon 9/17/2007 5:02 AM
> To: ieuga@yahoogroups.com
> Subject: RE: [ieuga] Upgrading Expandable and Crystal Reports 10
>
>
>
> Cheryl: We are going to be doing the same upgrade after the first
of October. We also have many Crystal reports to upgrade to Crystal
10. I was wondering if you got any responses to your email? Thanks
in advance for any info you can share.
>
>
>
> Jenelle Zapico
>
> Austin Semiconductor Inc.
>
> 512-719-7265
>
>
>
> From: cbrown.aurora [mailto:cbrown@...]
> Sent: Friday, September 07, 2007 12:45 PM
> To: ieuga@yahoogroups.com
> Subject: [ieuga] Upgrading Expandable and Crystal Reports 10
>
>
>
> We are getting ready to upgrade Expandable to version 8.1.3 from
8.1.1.
> We are using a lot of Crystal reports, and I'm wondering if anyone
has
> had problems with their existing reports not working with Crystal
10 or
> not working with Expandable version 8.1.3? Any input as to your
> experience with this (either good or bad) is greatly appreciated.
>
> Thanks,
> Cheryl Brown
> 916-941-6079
>
>
>
__________________________________________________________
> This e-mail has been scanned by MCI Managed Email Content Service,
using Skeptic(tm) technology powered by MessageLabs. For more
information on MCI's Managed Email Content Service, visit
http://www.mci.com.
>
__________________________________________________________
>

#117

From: "ted_sturr" <ted_sturr@...>
Date: Wed Sep 19, 2007 1:33 pm
Subject: Re: Upgrading Expandable and Crystal Reports 10

ted_sturr

This thread actually caused some confusion in-house for us so I
thought I would reply to everyone.

You only need a copy of Crystal 10 to manage the internal reports
within Expandable.  For reports managed outside of Expandable you are
still able to manage those reports with 8.5.  Because of licensing
and familiarity and the number of custom reports we use, this is the
way we manage things for our Crystal reports.  We have a seperate
network folder were we maintain our reports in Crystal 8.5.

Also as a side note.  For those of you who are using SalesLogix or
have Crystal XI R2.  We have been able to edit and maintain the
Crystal 10 reports with this version.  I actually prefer using
Crystal XI over Crystal 10 because it seems more stable. If they
would only give us the ability to edit the SQL statement things would
be great.  This is not officially supported by Expandable and I have
to put in the caveat that you use this option at your own risk - but
as I said, I haven't had a problem yet.

Ted Sturr
Palomar Medical
--- In ieuga@yahoogroups.com, "wc_gurusome" <wm.cowley@...> wrote:
>
> Hello,
>
> I have been working with Crystal 10 since March, so I can't speak
for
> every feature.  Most of the report upgrades will upgrade with a
> simple save.  I discovered that the SQL Queries cannot be edited in
> Crystal 10.  You may need to rework some reports to get around this
> limitation before you upgrade the report.  There are probably some
> 3rd Party tools, but I haven't found one.
>
> I noticed that sub-reports run much slower in 10 than 8.5.  I some
> cases, I could change the main report and sometimes I had to learn
to
> live with it.
>
> If you have Non-Expandable users running "compiled" report feature
> from 7.0, 8.0 & 8.5, you need to find another solution.  This has
> been dropped. The Report Manager inside Expandable is great but you
> need a license seat to run the reports.
>
> Enterprise Manager will let you web deploy reports but it gets
> expensive quickly.  Buying Crystal reports for every one is not
> cheap. There are quite a few 3rd Party Viewers available that do a
> good job.
>
> From a non-techical perspective, you need to create a stategy for
> reports.  Crystal 8.5 still runs quickly and works well outside
> Expandable. But, you have to keep the versions separate.  Once it
is
> saved in Crystal 10, you can't open it in 8.5.  Will you convert
> everyone over to Crystal 10 or will you continue to use some areas
> with 8.5?  Be prepared with the right licenses.
>
> ...wc
>
> --- In ieuga@yahoogroups.com, "Cheryl Brown" <cbrown@> wrote:
> >
> > Hi Jenelle,
> >
> > There was no response from the user group, but I called and
talked
> with Expandable Support.  According to the person I spoke with, for
> most reports it will be enough to open the report in Crystal 10 and
> then save it.  However, some tables have changed, so there may be
> some reports that will need editing for that reason.  Also, we have
> some reports that use old functions that were available only in
> earlier versions of Crystal, so we may need to make changes on
> those.  However, I'm hoping that we'll just be able to move the old
> dll for that function into the appropriate folder and continue to
use
> it (as we did when we moved to Crystal 8.5).
> >
> > I hope that helps!
> >
> > Cheryl
> >
> > ________________________________
> >
> > From: ieuga@yahoogroups.com on behalf of Jenelle Zapico
> > Sent: Mon 9/17/2007 5:02 AM
> > To: ieuga@yahoogroups.com
> > Subject: RE: [ieuga] Upgrading Expandable and Crystal Reports 10
> >
> >
> >
> > Cheryl:  We are going to be doing the same upgrade after the
first
> of October.  We also have many Crystal reports to upgrade to
Crystal
> 10.  I was wondering if you got any responses to your email?
Thanks
> in advance for any info you can share.
> >
> >
> >
> > Jenelle Zapico
> >
> > Austin Semiconductor Inc.
> >
> > 512-719-7265
> >
> >
> >
> > From: cbrown.aurora [mailto:cbrown@]
> > Sent: Friday, September 07, 2007 12:45 PM
> > To: ieuga@yahoogroups.com
> > Subject: [ieuga] Upgrading Expandable and Crystal Reports 10
> >
> >
> >
> > We are getting ready to upgrade Expandable to version 8.1.3 from
> 8.1.1.
> > We are using a lot of Crystal reports, and I'm wondering if
anyone
> has
> > had problems with their existing reports not working with Crystal
> 10 or
> > not working with Expandable version 8.1.3? Any input as to your
> > experience with this (either good or bad) is greatly appreciated.
> >
> > Thanks,
> > Cheryl Brown
> > 916-941-6079
> >
> >
> >
>
______________________________________________________________________
> > This e-mail has been scanned by MCI Managed Email Content
Service,
> using Skeptic(tm) technology powered by MessageLabs. For more
> information on MCI's Managed Email Content Service, visit
> http://www.mci.com.
> >
>
______________________________________________________________________
> >
>

#118

From: Jonathan Borden <jborden@...>
Date: Tue Sep 18, 2007 3:16 pm
Subject: Is anyone using Crystal XI?

silvermustan...

http://www.businessobjects.com/products/reporting/crystalreports/viewer/en/default.asp?extcmp=07q3_am_dev_sepnews_5

I was wondering if anyone was using crystal reports XI? This seams like a great price for it. Also it seams like there is now a Free downloadable report viewer you can install with crystal XI to share your reports with other issues and avoid some licensing fees.

From: Business Objects [mailto:businessobjects@...]
Sent: Tuesday, September 18, 2007 6:47 AM
To: Jonathan Borden
Subject: DeveloperLink - Inside: CR from $99, Conf info, Free Viewer and more

To view this email as a Web page, use this link.

DEVELOPERLINK
Illuminating your Crystal Reports & Business Objects applications

DEVELOPER CONFERENCE AT INSIGHT: OCT 15-16, 2007
A companion event to the Business Objects Insight Americas Users Conference, our Developer Conference will give you an exclusive opportunity to explore the next release of Crystal Reports and expand your knowledge of the latest Business Intelligence solutions.
» Reserve your seat now!

LAST CHANCE | UPGRADE CRYSTAL REPORTS FOR $99!
Until September 28 2007,
upgrade from a previous
version of Crystal Reports
to the current Developer
editions for only $99*.
Or purchase Crystal Reports
new for $395* ($200* savings).
» Find out more.

*Price in US Dollars

BUSINESS OBJECTS WEB SERVICES SDK | AN OVERVIEW
This 60 minute webinar presented by Robert Horne, Developer Evangelist with Business Objects, will describe which Web Services are available with each release of BusinessObjects Enterprise (up to BOE XI R2 SP2) and the advantages and disadvantages of using the Web Services SDK. A feature breakdown of each Web Service and comparisons to the BusinessObjects Enterprise SDK will also be covered.
» Access it here.

CRYSTAL REPORTS AND .NET
Creating Custom Reports for DotNetNuke using Crystal Reports
Eric Landes, a writer for ASP Alliance published the following 3 articles around creating custom Crystal Reports for DotNetNuke websites.
» Part 1 - A brief overview of DotNetNuke, including table structure and basic SQL statements.
» Part 2 - This article will focus on creating reports for forums and access reports.
» Part 3 - This article shows how to create custom Crystal Reports for blogs and for portal statistics.

Crystal Reports for Visual Studio 2005 Service Pack Beta
The Crystal Reports for Visual Studio 2005 Service Pack 1 Beta focuses on increasing the overall quality of the existing product features and maintaining a high level of compatibility with Visual Studio 2005 Service Pack 1 and Windows Vista.
» Access it here.

CRYSTAL REPORTS FOR ECLIPSE CORNER
An Introduction to Eclipse for Visual Studio Users
An article by Genady Beryozkin, an IBM Software Developer, for developers who are new to Eclipse and have previously been using Visual Studio for some time. The main differences between Eclipse and Visual Studio will be presented.
» Find out more.

CRYSTAL XCELSIUS DASHBOARD SAMPLES
Access these custom dashboards that show how Xcelsius can provide deeper insight into your data and company's performance.
» Digital Project Management Report
» Financial Benchmarking Dashboard
» Workforce Analytics Dashboard

DESIGN REPORTS THAT PRINT CONSISTENTLY
A whitepaper discussion on exactly how Crystal Reports handles the formatting, placement and printing of the many objects that exist in reports, and how to print them consistently across different PC's.
» Find out more.

ISV INFORMATION RESOURCES
Embedding Crystal Xcelsius into Custom Applications
A 67 minute webinar presented by Katryn Cheu, OEM Sales Consultant at Business Objects, where you will learn:
» Which Xcelsius features to leverage within a custom application
» Which data connectivity option goes best with your solution's architecture
» Demonstration of a Crystal Xcelsius sample application
» Access it here.

Transforming Unstructured Text into Actionable Data with Business Objects Inxight
The acquisition of Inxight gives Business Objects customers clear understanding of what business value is trapped in access to unstructured data sources. A 60 minute webinar presented by Mikel Morrow, Sr Account Manager Channels, Business Objects. In this session, you will learn:
» How the Components add structure to Unstructured data
» What the components can do out of the box
» How they can show complex relationships between data elements
» Access it here.

KBASES
How to export to PDF or RTF in Crystal Reports.
» Access it here.

How to prompt for a table using a parameter with a command object.
» Access it here.

DEVELOPER AND DIAMOND COMMUNITY LINKS
» Diamond Developer Community
Access a wealth of developer resources.

» .NET area on Diamond
Access product details and resources.

» Eclipse area on Diamond
Download Crystal Reports for Eclipse and access product details and resources.

» Java area on Diamond
Access Java technical resources.

» Developer Getting Started Area
Find the latest getting started developer resources.

» Crystal Xcelsius area on Diamond
Enhance your Crystal Xcelsius skills with getting started resources, tips and tricks, best practices, and more.



CRYSTAL REPORTS SERVER TRIAL CRYSTAL REPORTS 30 DAY TRIAL CRYSTAL XCELSIUS 30 DAY TRIAL



DOWNLOAD THE CRYSTAL REPORTS VIEWER NOW!



FOR CRYSTAL REPORTS XI: » Buy Online » Compare Pricing and Availability from qualified resellers » Call us direct: 1-888-333-6007 FOR CRYSTAL REPORTS SERVER XI AND BUSINESSOBJECTS XI: » Call us direct: 1-800-704-9765 » For reseller information, call 1-888-866-2366

This email was sent to: [jborden@...]

Take yourself off this list.

Reply | Messages in this Topic (2)

#119

From: Somchai Moy <moysomchai@...>
Date: Wed Sep 19, 2007 9:51 pm
Subject: Avalara Sales Tax Software - AvaTax - Tax Solver

moysomchai

Hello all:

Does anyone here use the sales tax software by Avalara Tax? They are also known as AvaTax or one of their products is Tax Solver.

I would like to talk you and get your feedback on the software.

Regards,

Somchai Moy

(949) 461-3314 ext 2176

Boardwalk for $500? In 2007? Ha!
Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games.

Reply | Messages in this Topic (1)

#120

From: "Jenelle Zapico" <jzapico@...>
Date: Wed Sep 19, 2007 2:06 pm
Subject: RE: Re: Upgrading Expandable and Crystal Reports 10

JAM6300

Just a side note, We at Austin Semiconductor are getting ready to upgrade to 8.1.3 so we have inquired about Crystal XI. Expandable came back to me yesterday and said that they are looking at having it in 8.4 “hopefully” by the end of the year.

Jenelle Zapico

ERP Manager

Austin Semiconductor, Inc

512-719-7265

From: ted_sturr [mailto:ted_sturr@...]
Sent: Wednesday, September 19, 2007 8:34 AM
To: ieuga@yahoogroups.com
Subject: [ieuga] Re: Upgrading Expandable and Crystal Reports 10

This thread actually caused some confusion in-house for us so I
thought I would reply to everyone.

You only need a copy of Crystal 10 to manage the internal reports
within Expandable. For reports managed outside of Expandable you are
still able to manage those reports with 8.5. Because of licensing
and familiarity and the number of custom reports we use, this is the
way we manage things for our Crystal reports. We have a seperate
network folder were we maintain our reports in Crystal 8.5.

Also as a side note. For those of you who are using SalesLogix or
have Crystal XI R2. We have been able to edit and maintain the
Crystal 10 reports with this version. I actually prefer using
Crystal XI over Crystal 10 because it seems more stable. If they
would only give us the ability to edit the SQL statement things would
be great. This is not officially supported by Expandable and I have
to put in the caveat that you use this option at your own risk - but
as I said, I haven't had a problem yet.

Ted Sturr
Palomar Medical
--- In ieuga@yahoogroups.com, "wc_gurusome" <wm.cowley@...> wrote:
>
> Hello,
>
> I have been working with Crystal 10 since March, so I can't speak
for
> every feature. Most of the report upgrades will upgrade with a
> simple save. I discovered that the SQL Queries cannot be edited in
> Crystal 10. You may need to rework some reports to get around this
> limitation before you upgrade the report. There are probably some
> 3rd Party tools, but I haven't found one.
>
> I noticed that sub-reports run much slower in 10 than 8.5. I some
> cases, I could change the main report and sometimes I had to learn
to
> live with it.
>
> If you have Non-Expandable users running "compiled" report feature
> from 7.0, 8.0 & 8.5, you need to find another solution. This has
> been dropped. The Report Manager inside Expandable is great but you
> need a license seat to run the reports.
>
> Enterprise Manager will let you web deploy reports but it gets
> expensive quickly. Buying Crystal reports for every one is not
> cheap. There are quite a few 3rd Party Viewers available that do a
> good job.
>
> From a non-techical perspective, you need to create a stategy for
> reports. Crystal 8.5 still runs quickly and works well outside
> Expandable. But, you have to keep the versions separate. Once it
is
> saved in Crystal 10, you can't open it in 8.5. Will you convert
> everyone over to Crystal 10 or will you continue to use some areas
> with 8.5? Be prepared with the right licenses.
>
> ...wc
>
> --- In ieuga@yahoogroups.com, "Cheryl Brown" <cbrown@> wrote:
> >
> > Hi Jenelle,
> >
> > There was no response from the user group, but I called and
talked
> with Expandable Support. According to the person I spoke with, for
> most reports it will be enough to open the report in Crystal 10 and
> then save it. However, some tables have changed, so there may be
> some reports that will need editing for that reason. Also, we have
> some reports that use old functions that were available only in
> earlier versions of Crystal, so we may need to make changes on
> those. However, I'm hoping that we'll just be able to move the old
> dll for that function into the appropriate folder and continue to
use
> it (as we did when we moved to Crystal 8.5).
> >
> > I hope that helps!
> >
> > Cheryl
> >
> > ________________________________
> >
> > From: ieuga@yahoogroups.com on behalf of Jenelle Zapico
> > Sent: Mon 9/17/2007 5:02 AM
> > To: ieuga@yahoogroups.com
> > Subject: RE: [ieuga] Upgrading Expandable and Crystal Reports 10
> >
> >
> >
> > Cheryl: We are going to be doing the same upgrade after the
first
> of October. We also have many Crystal reports to upgrade to
Crystal
> 10. I was wondering if you got any responses to your email?
Thanks
> in advance for any info you can share.
> >
> >
> >
> > Jenelle Zapico
> >
> > Austin Semiconductor Inc.
> >
> > 512-719-7265
> >
> >
> >
> > From: cbrown.aurora [mailto:cbrown@]
> > Sent: Friday, September 07, 2007 12:45 PM
> > To: ieuga@yahoogroups.com
> > Subject: [ieuga] Upgrading Expandable and Crystal Reports 10
> >
> >
> >
> > We are getting ready to upgrade Expandable to version 8.1.3 from
> 8.1.1.
> > We are using a lot of Crystal reports, and I'm wondering if
anyone
> has
> > had problems with their existing reports not working with Crystal
> 10 or
> > not working with Expandable version 8.1.3? Any input as to your
> > experience with this (either good or bad) is greatly appreciated.
> >
> > Thanks,
> > Cheryl Brown
> > 916-941-6079
> >
> >
> >
>
__________________________________________________________
> > This e-mail has been scanned by MCI Managed Email Content
Service,
> using Skeptic(tm) technology powered by MessageLabs. For more
> information on MCI's Managed Email Content Service, visit
> http://www.mci.com.
> >
>
__________________________________________________________
> >
>

______________________________________________________________________
This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com.
______________________________________________________________________

#121

From: "iwvdominique" <7domino@...>
Date: Fri Sep 21, 2007 9:38 pm
Subject: Re: Is anyone using Crystal XI?

iwvdominique

I have been using Crystal XI for over a year with SQL tables and it
works fine for me but It is not used with Expandable.  As Ted_sturr
already said, it is not yet supported by Expandable but it seems that
you can maintain the crystal 10 reports with it.

I believe the report viewer is in Beta stage right now.  I tested it
and it does not seem to support all crystal features yet.  It allows
you to read pre-generated .rpt only.  You cannot refresh a report.  It
is the same approach as Adobe's PDF viewer.
It will be useful when you want to send a .rpt to someone in its
original format i.e. not in Excel or pdf.  The end user will be able
to download the viewer for free and see the groups tree and drill-down
on it.
There are other solutions out there for less than $50. where you can
view and refresh .rpt.  I did not try those.-
There is my grain of salt - Dominique


--- In ieuga@yahoogroups.com, Jonathan Borden <jborden@...> wrote:
>
> I was wondering if anyone was using crystal reports XI?  This seams
like a great price for it.  Also it seams like there is now a Free
downloadable report viewer you can install with crystal XI to share
your reports with other issues and avoid some licensing fees.
>
http://www.businessobjects.com/products/reporting/crystalreports/viewer/en/defau\
lt.asp?extcmp=07q3_am_dev_sepnews_5
>
>
>
> ________________________________
> From: Business Objects [mailto:businessobjects@...]
> Sent: Tuesday, September 18, 2007 6:47 AM
> To: Jonathan Borden
> Subject: DeveloperLink - Inside: CR from $99, Conf info, Free Viewer
and more
>
> To view this email as a Web page, use this
link<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BcDR0E\
u>.
>
[http://bobjects.com/email_imp/americas07/920R/images/header2.jpg]<http://prefer\
ences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BPd0El>
>
>
>
>
>
>
> DEVELOPERLINK
> Illuminating your Crystal Reports & Business Objects applications
>
> DEVELOPER CONFERENCE AT INSIGHT: OCT 15-16, 2007
> A companion event to the Business Objects Insight Americas Users
Conference, our Developer Conference will give you an exclusive
opportunity to explore the next release of Crystal Reports and expand
your knowledge of the latest Business Intelligence solutions.
> > Reserve your seat
now!<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BcDT0E\
w>
>
> LAST CHANCE | UPGRADE CRYSTAL REPORTS FOR $99!
>
[http://bobjects.com/email_imp/americas07/920R/images/99box.jpg]Until
September 28 2007,
> upgrade from a previous
> version of Crystal Reports
> to the current Developer
> editions for only $99*.
> Or purchase Crystal Reports
> new for $395* ($200* savings).
> > Find out
more.<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BcC50\
EQ>
>
> *Price in US Dollars
>
> BUSINESS OBJECTS WEB SERVICES SDK | AN OVERVIEW
> This 60 minute webinar presented by Robert Horne, Developer
Evangelist with Business Objects, will describe which Web Services are
available with each release of BusinessObjects Enterprise (up to BOE
XI R2 SP2) and the advantages and disadvantages of using the Web
Services SDK. A feature breakdown of each Web Service and comparisons
to the BusinessObjects Enterprise SDK will also be covered.
> > Access it
here.<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BcC60\
ER>
>
> CRYSTAL REPORTS AND .NET
> Creating Custom Reports for DotNetNuke using Crystal Reports
> Eric Landes, a writer for ASP
Alliance<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BZ\
rZ0Ef>
published the following 3 articles around creating custom Crystal
Reports for DotNetNuke websites.
> > Part
1<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BcC70ES>
- A brief overview of DotNetNuke, including table structure and basic
SQL statements.
> > Part
2<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BcC80ET>
- This article will focus on creating reports for forums and access
reports.
> > Part
3<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BcDA0Ed>
- This article shows how to create custom Crystal Reports for blogs
and for portal statistics.
>
> Crystal Reports for Visual Studio 2005 Service Pack Beta
> The Crystal Reports for Visual Studio 2005 Service Pack 1 Beta
focuses on increasing the overall quality of the existing product
features and maintaining a high level of compatibility with Visual
Studio 2005 Service Pack 1 and Windows Vista.
> > Access it
here.<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BcDB0\
Ee>
>
>
> CRYSTAL REPORTS FOR ECLIPSE CORNER
> An Introduction to Eclipse for Visual Studio Users
> An article by Genady Beryozkin, an IBM Software Developer, for
developers who are new to Eclipse and have previously been using
Visual Studio for some time. The main differences between Eclipse and
Visual Studio will be presented.
<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BZra0Em>
>
<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BZra0Em>>
Find out
more.<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BcDC0\
Ef>
>
> CRYSTAL XCELSIUS DASHBOARD SAMPLES
> Access these custom dashboards that show how Xcelsius can provide
deeper insight into your data and company's performance.
>
<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BZrO0EU>>
Digital Project Management Report
<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BcDD0Eg>
> > Financial Benchmarking Dashboard
>
<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BcDE0Eh>>
Workforce Analytics
Dashboard<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0B\
cDF0Ei>
>
> DESIGN REPORTS THAT PRINT CONSISTENTLY
> A whitepaper discussion on exactly how Crystal Reports handles the
formatting, placement and printing of the many objects that exist in
reports, and how to print them consistently across different PC's.
> > Find out
more.<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BcDG0\
Ej>
>
> ISV INFORMATION RESOURCES
> Embedding Crystal Xcelsius into Custom Applications
> A 67 minute webinar presented by Katryn Cheu, OEM Sales Consultant
at Business Objects, where you will learn:
> > Which Xcelsius features to leverage within a custom application
> > Which data connectivity option goes best with your solution's
architecture
> > Demonstration of a Crystal Xcelsius sample application
> > Access it
here.<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BcDU0\
Ex>
>
> Transforming Unstructured Text into Actionable Data with Business
Objects Inxight
> The acquisition of Inxight gives Business Objects customers clear
understanding of what business value is trapped in access to
unstructured data sources. A 60 minute webinar presented by Mikel
Morrow, Sr Account Manager Channels, Business Objects. In this
session, you will learn:
> > How the Components add structure to Unstructured data
> > What the components can do out of the box
> > How they can show complex relationships between data elements
> > Access it
here.<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BcDI0\
El>
>
> KBASES
> How to export to PDF or RTF in Crystal Reports.
> > Access it
here.<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BcDV0\
Ey>
>
> How to prompt for a table using a parameter with a command object.
> > Access it
here.<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BcDK0\
En>
>
> DEVELOPER AND DIAMOND COMMUNITY LINKS
> > Diamond Developer
Community<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0B\
ANr0E3>
> Access a wealth of developer resources.
>
> > .NET area on
Diamond<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BDE\
a0Ef>
> Access product details and resources.
>
> > Eclipse area on
Diamond<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BHL\
b0Er>
> Download Crystal Reports for Eclipse and access product details and
resources.
>
> > Java area on
Diamond<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BKK\
W0Ei>
> Access Java technical resources.
>
> > Developer Getting Started Area
<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BXaa0ET>
> Find the latest getting started developer resources.
>
> > Crystal Xcelsius area on
Diamond<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BZr\
O0EU>
> Enhance your Crystal Xcelsius skills with getting started resources,
tips and tricks, best practices, and more.
>
>
>
>
>
>
>
>
>
> CRYSTAL REPORTS SERVER
TRIAL<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BcDL0\
Eo>
>
> CRYSTAL REPORTS 30 DAY
TRIAL<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BcDM0\
Ep>
>
> CRYSTAL XCELSIUS 30 DAY
TRIAL<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BcDN0\
Eq>
>
>
>
>
>
>
>
>
>
>
> DOWNLOAD THE CRYSTAL REPORTS VIEWER
NOW!<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BcDO0E\
r>
>
>
>
>
>
>
>
>
>
>
> FOR CRYSTAL REPORTS XI:
>
> > Buy
Online<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BcDP\
0Es>
>
> > Compare Pricing and Availability from qualified
resellers<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0B\
cDQ0Et>
>
> > Call us direct:
> 1-888-333-6007
>
> FOR CRYSTAL REPORTS SERVER XI AND BUSINESSOBJECTS XI:
>
> > Call us direct:
> 1-800-704-9765
>
> > For reseller information, call 1-888-866-2366
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Contact
Us<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0Oqm0Eg>
| RSS
Feeds<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BQgp0\
Eh>
|
Careers<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BQg\
q0Ei>
| My
Profile<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0yoH\
0Ej>
|
Newsletter<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0\
BS40E1>
| Privacy
Policy<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BQgs\
0Ek>
| Terms of
Use<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0c2c0En>
>
> This email was sent to: [jborden@...]
>
> Take yourself off this
list<http://preferences.businessobjects.com/cgi-bin24/DM/y/hgJT0KbPW70KfM0BS50E2\
>.
>
> Copyright (c) 2007 Business Objects SA, 3030 Orchard Parkway, San
Jose, CA 95134 USA
> All Rights Reserved
>
>
>
>
>
>
>
>
>
>
>
>
[http://preferences.businessobjects.com/cgi-bin24/flosensing?y=gJT0KbPW70KfM0Bo]
>

Reply | Messages in this Topic (2)

#123

From: "Cheryl Brown" <cbrown@...>
Date: Tue Oct 9, 2007 8:43 pm
Subject: RE: Upgrading Expandable and Crystal Reports 10

cbrown.aurora

Thank you Jenelle. It’s good to hear that your upgrade went well.

So you’re saying that there have been problems with the reports that are delivered with Expandable? That’s useful to know. I expected that new report files that were already tested with Crystal 10 would be delivered with the 8.1.3 upgrade.

Thanks,

Cheryl

-----Original Message-----
From: ieuga@yahoogroups.com [mailto:ieuga@yahoogroups.com] On Behalf Of Jenelle Zapico
Sent: Tuesday, October 09, 2007 6:15 AM
To: ieuga@yahoogroups.com
Subject: RE: [ieuga] Upgrading Expandable and Crystal Reports 10

Cheryl: We upgraded to 8.1.3 and Crystal 10 this past weekend. It went better that I expected. IT had some issues with the install process but that was generated by our last IT guy not the Expandable upgrades. The any issues so far have been with the reports and the new tables. Users come across reports that now generate errors and I go in and run them in Crystal and they are okay. Only one has had a problem that did not fix easily ICRCWP. Cycle count worksheet by part and I have asked Expandable for help with this one. The issues have been minimal.

Good luck

Jenelle

From: Cheryl Brown [mailto:ieuga@yahoogroups.com] On Behalf Of Cheryl Brown
Sent: Monday, September 17, 2007 11:30 AM
To: ieuga@yahoogroups.com
Subject: RE: [ieuga] Upgrading Expandable and Crystal Reports 10

Hi Jenelle,

There was no response from the user group, but I called and talked with Expandable Support. According to the person I spoke with, for most reports it will be enough to open the report in Crystal 10 and then save it. However, some tables have changed, so there may be some reports that will need editing for that reason. Also, we have some reports that use old functions that were available only in earlier versions of Crystal, so we may need to make changes on those. However, I'm hoping that we'll just be able to move the old dll for that function into the appropriate folder and continue to use it (as we did when we moved to Crystal 8.5).

I hope that helps!

Cheryl

From: ieuga@yahoogroups.com on behalf of Jenelle Zapico
Sent: Mon 9/17/2007 5:02 AM
To: ieuga@yahoogroups.com
Subject: RE: [ieuga] Upgrading Expandable and Crystal Reports 10

Cheryl: We are going to be doing the same upgrade after the first of October. We also have many Crystal reports to upgrade to Crystal 10. I was wondering if you got any responses to your email? Thanks in advance for any info you can share.

Jenelle Zapico

Austin Semiconductor Inc.

512-719-7265

From: cbrown.aurora [mailto:cbrown@aurora.com]
Sent: Friday, September 07, 2007 12:45 PM
To: ieuga@yahoogroups.com
Subject: [ieuga] Upgrading Expandable and Crystal Reports 10

We are getting ready to upgrade Expandable to version 8.1.3 from 8.1.1.
We are using a lot of Crystal reports, and I'm wondering if anyone has
had problems with their existing reports not working with Crystal 10 or
not working with Expandable version 8.1.3? Any input as to your
experience with this (either good or bad) is greatly appreciated.

Thanks,
Cheryl Brown
916-941-6079

#124

From: "Ruth Updegraff" <rupdegraff@...>
Date: Fri Oct 12, 2007 9:07 pm
Subject: WinBatch Monthend routines

hamrgraf

There is an example from 2001 on the ieuga website – but does anyone have a CURRENT WinBatch script for running month end?

Ruth Updegraff

Mgr Business Process and System Development

(408)496-2269

#125

From: "Cheryl Brown" <cbrown@...>
Date: Fri Oct 12, 2007 9:10 pm
Subject: RE: WinBatch Monthend routines

cbrown.aurora

Hi Ruth,

What version of Expandable are you on?

Cheryl Brown

916-941-6079

-----Original Message-----
From: ieuga@yahoogroups.com [mailto:ieuga@yahoogroups.com] On Behalf Of Ruth Updegraff
Sent: Friday, October 12, 2007 2:07 PM
To: ieuga@yahoogroups.com
Subject: [ieuga] WinBatch Monthend routines

There is an example from 2001 on the ieuga website – but does anyone have a CURRENT WinBatch script for running month end?

Ruth Updegraff

Mgr Business Process and System Development

(408)496-2269

#126

From: george popovich <takamine94539pop@...>
Date: Sun Oct 14, 2007 4:16 pm
Subject: Re: WinBatch Monthend routines

takamine9453...

Hi Ruth! Miss working with you. Cheers, George P.

Ruth Updegraff <rupdegraff@...> wrote:

There is an example from 2001 on the ieuga website � but does anyone have a CURRENT WinBatch script for running month end?

Ruth Updegraff

Mgr Business Process and System Development

(408)496-2269

Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos more.

#127

From: "ted_sturr" <ted_sturr@...>
Date: Tue Nov 20, 2007 8:04 pm
Subject: ESI 8.13

ted_sturr

I am working on an article about upgrading to Expandable 8.1.3 for the
next newsletter. I was wondering how many of you have upgraded to
Expandable 8.3? If you have not upgraded yet, what are you waiting
for / concerned about?

Thank you.

Ted

#128

From: "Jim Seymour" <jim@...>
Date: Wed Nov 21, 2007 10:19 pm
Subject: Re: ESI 8.13

jdseymour

--- In ieuga@yahoogroups.com, "ted_sturr" <ted_sturr@...> wrote:
> I am working on an article about upgrading to Expandable 8.1.3 for the
> next newsletter. I was wondering how many of you have upgraded to
> Expandable 8.3? If you have not upgraded yet, what are you waiting
> for / concerned about?

We just completed the upgrade to 8.1.3 last week.  Our previous
upgrade was all the way back in February of 2006 when we went to 8.1.1.

The reason we waited so long was because the upgrade process is (to be
blunt) a PITA.

If Expandable made the process as easy as Microsoft's Service Packs,
I'd almost certainly apply patches as soon as they come out.

Plus, the requirement to buy a new copy of Crystal Reports annoyed us,
which added to the delay.

#129

From: Jan.l.young@...
Date: Mon Nov 26, 2007 5:44 pm
Subject: Re: ESI 8.13

jan_l_young

I haven't upgraded as I need to purchase a newer version of Crystal and
just haven't had time to get my purchase req. completed.
Jan
SKF Condition Monitoring
(858) 496-3422

              sentto-15370873-1
              27-1195589051-Jan
              .l.young=SKF.com@                                          To
              returns.groups.ya         ieuga@yahoogroups.com
              hoo.com                                                    cc

              11/20/07 12:04 PM                                     Subject
                                        [ieuga] ESI 8.13

              Please respond to
              ieuga@yahoogroups
                    .com











  I am working on an article about upgrading to Expandable 8.1.3 for the
  next newsletter. I was wondering how many of you have upgraded to
  Expandable 8.3? If you have not upgraded yet, what are you waiting
  for / concerned about?

  Thank you.

  Ted

#130

From: Jan.l.young@...
Date: Tue Nov 27, 2007 4:10 pm
Subject: Fw: Expandable Users Group downgrading ideas wish list

jan_l_young

Below is a request from one of my users.  Has anyone else created something
similar to what he is requesting or has another work around for this?

Thanks,
Jan
SKF Condition Monitoring
jan.l.young@...
(858) 496-3422
----- Forwarded by Jan L Young/SDG/SKF on 11/27/07 08:11 AM -----

              Greg S
              Johnston/SDG/SKF
                                                                         To
              11/26/07 04:28 PM         Jan L Young/SDG/SKF@SKF
                                                                         cc

                                                                    Subject
                                        Expandable Users Group downgrading
                                        ideas wish list









Hi Jan,
When we process downgrading ECOs, a significant amount of time is spent
identifying the unique BOM components that can be downgraded along with the
"Parent" model number/part number.  For every part number, you must drill
down through all levels of the BOMs and search the "where used" to
determine if that part is only used on this model and can therefore be
added to the affected items on the ECO.  Once you have identified all the
unique parts, you then must check stock status, look for any open purchase
orders and open sales orders.  Then you have to determine the material
value for all items being scrapped and add that to the ECO.
We could realize a siginicant time savings if there was a query that
searched through the BOMs, performed a where used, and if the part was only
used on that assembly, would then populate a list of those unique items.
Then, the query output would create a table that included the stock,
supply, and demand quantities.
Then, of course, it would add up all the scrap dollars and give you a
total.  This then could be imported into Agile and create the affected
items list.
For complex product BOMs, this would save many hours of manual work.
  Anyway, that is what I want for Christmas.......
Thanks,
Greg

Reply | Messages in this Topic (1)

#131

From: "jkoch_work" <jkn@...>
Date: Thu Nov 29, 2007 8:28 pm
Subject: Making Expandable Read Only - very old version

jkoch_work

My company is converting from an ancient Expandable 5.3 DOS based
system over to SAP.   I've been asked to figure out how to make the
Expandable system "read only".

I received advice from Expandable, but this was based on newer
versions and doesn't seem to apply to 5.3.    The advice is below:

"All of the Expandable Programs Acronyms have the 3rd character as a
significant character.  i.e. I's = inquiries, E's= editors, R's are
reports."

"So to freeze you data, from the Rights Editor.  Main Menu, go to
System/Security/Rights Editor.  Remove all of the check marks for
Run, Add, Delete, Modify from all programs which have a T or U as the
3rd Character.  Remove the check mark from the Add, Delete, Modify
for all programs which have I, E or R as the 3rd character.  So for
these programs you will only have the Run checked."

We don't have a rights editor - but I can assign passwords in XXEPW.

I'm not sure the 3rd character rule applies to the older version of
Expandable - some seem to follow and others don't.

I've currently got 9,000+ passwords in the system.

Unfortunately, we don't have an Expandable admin or anyone who knows
the system.   I'm tackling it because I used to run an Epicor Dataflo
system for years before we converted to SAP...

If you've got any advice at all... please!

Thank you!

John Koch-Northrup
Vansco Electronics
jkoch@...

#132

From: <wm.cowley@...>
Date: Fri Nov 30, 2007 1:30 pm
Subject: RE: Making Expandable Read Only - very old version

wc_gurusome

John,

For inquiry, you can add a password for the editor but do not add the password for the “File” in XXEPW. Example: Add a password to the Parts Master Editor (ICEPM). You can make it “ESI”. To change data, you would need a matching password “ESI” for the file (ICFPM). You will not need to add this password. Add passwords for all editors, reports and inquiries. For Read-Only you would not add passwords to Transactions or Utilities (third digit is “T” or “U”).

I hope that helps…wc

Wm.Cowley

wc@...

From: ieuga@yahoogroups.com [mailto:ieuga@yahoogroups.com] On Behalf Of jkoch_work
Sent: Thursday, November 29, 2007 12:28 PM
To: ieuga@yahoogroups.com
Subject: [ieuga] Making Expandable Read Only - very old version

My company is converting from an ancient Expandable 5.3 DOS based
system over to SAP. I've been asked to figure out how to make the
Expandable system "read only".

I received advice from Expandable, but this was based on newer
versions and doesn't seem to apply to 5.3. The advice is below:

"All of the Expandable Programs Acronyms have the 3rd character as a
significant character. i.e. I's = inquiries, E's= editors, R's are
reports."

"So to freeze you data, from the Rights Editor. Main Menu, go to
System/Security/Rights Editor. Remove all of the check marks for
Run, Add, Delete, Modify from all programs which have a T or U as the
3rd Character. Remove the check mark from the Add, Delete, Modify
for all programs which have I, E or R as the 3rd character. So for
these programs you will only have the Run checked."

We don't have a rights editor - but I can assign passwords in XXEPW.

I'm not sure the 3rd character rule applies to the older version of
Expandable - some seem to follow and others don't.

I've currently got 9,000+ passwords in the system.

Unfortunately, we don't have an Expandable admin or anyone who knows
the system. I'm tackling it because I used to run an Epicor Dataflo
system for years before we converted to SAP...

If you've got any advice at all... please!

Thank you!

John Koch-Northrup
Vansco Electronics
jkoch@vansco-morton.com

#133

From: "jkoch_work" <jkn@...>
Date: Mon Dec 3, 2007 8:33 pm
Subject: Re: Making Expandable Read Only - very old version

jkoch_work

Thank you to Bill, Bill, and Jan for your advice and help (especially
Bill H. for 'fixing' our password file) .   We have our system cutover
to SAP and the old Expandable DOS system appears to be locked down to
read only.  I added a password fo one program this morning - XXUDSP -
in order to clear hung users.

So far it's working great.

I can't thank you enough.

John

#134

From: "Jon Heiner" <Jon@...>
Date: Tue Dec 11, 2007 3:33 am
Subject: SQL query to Expandable from within an Excel macro

jonbroad2000

To give us a real time look at parts availability when we enter an order, I have written an Excel macro in Visual Basic (VBA) to explode a bill of materials and compare the lowest level to the parts in our inventory. To do this, I access the Expandable data base with an SQL inquiry.

I am trying to find a way for this to run automatically, without someone having to start the SQL query and then start the macro. The only way I have thought of so far is to run the SQL query from within the VBA macro. I know this is possible, but have not figured out how to write the connection string, which would look something like:

ConString = "ODBC;DSN = [some sort of code for Expandable data base type]....."

1) Does anyone have experience with how to do this, or an alternative way to automatically run SQL and a macro from Excel?

2) Is there anyone else who would like to be able to tell at time of order whether enough raw materials are in inventory to build the product? It is possible that Expandable could be persuaded to add this feature to a future release if it is a common concern.

Thanks,

Jon Heiner
Proteus Industries

#135

From: "Emily Tsang" <etsang@...>
Date: Wed Dec 12, 2007 9:05 pm
Subject: RE: Expandable automatic time-out of inactive users

capejewels888

We have a problem with Expandable users neglecting to logout at the end of their session. This ties up licenses that are unused and unavailable to other users. The expandable password timeout feature only activates a password prompt when activity resumes. It does not free up the license.

Has any one devised a clever script to determine when a specific user ID has been inactive?

And then perhaps an even more diabolical scrip that logs that user ID out after a specified inactive period and frees the license for other users?

And if so, how did the users feel about getting logged out for inactivity?

Regards,

Jennifer

#136

From: "Jenelle Zapico" <jzapico@...>
Date: Wed Dec 12, 2007 10:20 pm
Subject: RE: RE: Expandable automatic time-out of inactive users

JAM6300

Hi, this is Jenelle at Austin Semiconductor. Unfortunately I was never that creative. The users must have gotten tired of me telling them over the intercom “If you are not currently using Expandable, please log off.” That happened quite regularly at first, but I bet it has been at least a year since I have had to make that announcement. I know this isn’t any help but thought I would respond anyway.

Good luck,

Jenelle

From: Emily Tsang [mailto:etsang@...]
Sent: Wednesday, December 12, 2007 3:06 PM
To: ieuga@yahoogroups.com
Cc: Jennifer Shaw
Subject: [ieuga] RE: Expandable automatic time-out of inactive users

We have a problem with Expandable users neglecting to logout at the end of their session. This ties up licenses that are unused and unavailable to other users. The expandable password timeout feature only activates a password prompt when activity resumes. It does not free up the license.

Has any one devised a clever script to determine when a specific user ID has been inactive?

And then perhaps an even more diabolical scrip that logs that user ID out after a specified inactive period and frees the license for other users?

And if so, how did the users feel about getting logged out for inactivity?

Regards,

Jennifer

#137

From: "Steve Schott" <steveschott@...>
Date: Wed Dec 12, 2007 10:24 pm
Subject: RE: RE: Expandable automatic time-out of inactive users

steve2468_98

http://www.autocloseidle.com/

Jennifer,

We use a program called Autocloseidle. It is cheap and works well closing expandable sessions as well as other applications after a period of inactivity. It is client server based and allows you to monitor and set longer times for power users and short times for occasional users which helps with the complaining. You just have to remember to install it on new users when you set them up.

Hope that helps!

Steve Schott

Comark

-----Original Message-----
From: ieuga@yahoogroups.com [mailto:ieuga@yahoogroups.com]On Behalf Of Emily Tsang
Sent: Wednesday, December 12, 2007 4:06 PM
To: ieuga@yahoogroups.com
Cc: Jennifer Shaw
Subject: [ieuga] RE: Expandable automatic time-out of inactive users

We have a problem with Expandable users neglecting to logout at the end of their session. This ties up licenses that are unused and unavailable to other users. The expandable password timeout feature only activates a password prompt when activity resumes. It does not free up the license.

Has any one devised a clever script to determine when a specific user ID has been inactive?

And then perhaps an even more diabolical scrip that logs that user ID out after a specified inactive period and frees the license for other users?

And if so, how did the users feel about getting logged out for inactivity?

Regards,

Jennifer

#138

From: "Emily Tsang" <etsang@...>
Date: Thu Dec 13, 2007 12:38 am
Subject: RE: RE: Expandable automatic time-out of inactive users

capejewels888

Steve , this sounds like just the ticket.

Was it difficult to set up? Perhaps would you be willing to give us pointers on best practices you have learned along the way?

Thanks,

Jennifer

-----Original Message-----
From: ieuga@yahoogroups.com [mailto:ieuga@yahoogroups.com]On Behalf Of Steve Schott
Sent: Wednesday, December 12, 2007 2:25 PM
To: ieuga@yahoogroups.com
Cc: Jennifer Shaw
Subject: RE: [ieuga] RE: Expandable automatic time-out of inactive users

Jennifer,

We use a program called Autocloseidle. It is cheap and works well closing expandable sessions as well as other applications after a period of inactivity. It is client server based and allows you to monitor and set longer times for power users and short times for occasional users which helps with the complaining. You just have to remember to install it on new users when you set them up.

http://www.autocloseidle.com/

Hope that helps!

Steve Schott

Comark

-----Original Message-----
From: ieuga@yahoogroups.com [mailto:ieuga@yahoogroups.com]On Behalf Of Emily Tsang
Sent: Wednesday, December 12, 2007 4:06 PM
To: ieuga@yahoogroups.com
Cc: Jennifer Shaw
Subject: [ieuga] RE: Expandable automatic time-out of inactive users

We have a problem with Expandable users neglecting to logout at the end of their session. This ties up licenses that are unused and unavailable to other users. The expandable password timeout feature only activates a password prompt when activity resumes. It does not free up the license.

Has any one devised a clever script to determine when a specific user ID has been inactive?

And then perhaps an even more diabolical scrip that logs that user ID out after a specified inactive period and frees the license for other users?

And if so, how did the users feel about getting logged out for inactivity?

Regards,

Jennifer

#139

From: "Steve Schott" <steveschott@...>
Date: Thu Dec 13, 2007 3:08 am
Subject: RE: RE: Expandable automatic time-out of inactive users

steve2468_98

There is not much to it. You install the main control on a server and the clients on all the users PC's. You can set the timeout value for each user. From the admin, you can view how long someone has been idle and also force them off manually (no more mass emails, phone calls or announcements over the PA). There is an option that we don't use which allows clients to bump off the longest idle client if they can't get on. We also disable the ability of the admin to interact with the client screen - it is not required to close an Expandable session. The only lesson we learned was to make sure you set super-users like finance who may run a month end report which takes hours to either never expire or to very long timeouts. For the casual user like an engineer or operator who logs on, does a query, and forgets to log off, it is terrific. Here are the features right off their web site.

Features and benefits:

Monitors only the application in question, not other applications activities.
Shows users names, computers names, and the idle time for each user.
Centrally manage all users.
Most options can be specified per user.
The idle time shown is accurate to the nearest second under typical network conditions(no cable, disconnect from Internet problems).
Closes the user's application remotely by a single click.
Closes the most unused copy of an application remotely by a single click.
Clients see a clock like icon in the task bar and the time remaining before closing the application.
Allows users to manually notify the administrator in case they can't login.
If enabled, users can close the most unused application directly, without the network administrator intervention.
Allows the administrator to see the user's screen and interact with the application remotely to respond to any validation dialogs.
Remotely update Auto Close Idle software without visiting each computer.
Works with Windows 2000 and 2003 Terminal Servers, with or without Citrix.

-----Original Message-----
From: ieuga@yahoogroups.com [mailto:ieuga@yahoogroups.com]On Behalf Of Emily Tsang
Sent: Wednesday, December 12, 2007 7:38 PM
To: ieuga@yahoogroups.com
Cc: Jennifer Shaw
Subject: RE: [ieuga] RE: Expandable automatic time-out of inactive users

Steve , this sounds like just the ticket.

Was it difficult to set up? Perhaps would you be willing to give us pointers on best practices you have learned along the way?

Thanks,

Jennifer

-----Original Message-----
From: ieuga@yahoogroups.com [mailto:ieuga@yahoogroups.com]On Behalf Of Steve Schott
Sent: Wednesday, December 12, 2007 2:25 PM
To: ieuga@yahoogroups.com
Cc: Jennifer Shaw
Subject: RE: [ieuga] RE: Expandable automatic time-out of inactive users

Jennifer,

We use a program called Autocloseidle. It is cheap and works well closing expandable sessions as well as other applications after a period of inactivity. It is client server based and allows you to monitor and set longer times for power users and short times for occasional users which helps with the complaining. You just have to remember to install it on new users when you set them up.

http://www.autocloseidle.com/

Hope that helps!

Steve Schott

Comark

-----Original Message-----
From: ieuga@yahoogroups.com [mailto:ieuga@yahoogroups.com]On Behalf Of Emily Tsang
Sent: Wednesday, December 12, 2007 4:06 PM
To: ieuga@yahoogroups.com
Cc: Jennifer Shaw
Subject: [ieuga] RE: Expandable automatic time-out of inactive users

We have a problem with Expandable users neglecting to logout at the end of their session. This ties up licenses that are unused and unavailable to other users. The expandable password timeout feature only activates a password prompt when activity resumes. It does not free up the license.

Has any one devised a clever script to determine when a specific user ID has been inactive?

And then perhaps an even more diabolical scrip that logs that user ID out after a specified inactive period and frees the license for other users?

And if so, how did the users feel about getting logged out for inactivity?

Regards,

Jennifer

#140

From: Jeff Mason <jeffcmason@...>
Date: Wed Dec 19, 2007 5:47 pm
Subject: Canada Customs Invoice

jeffcmason

I am curious if anyone has written a crystal report to generate the Canada Customs Invoice that is now required for all shipments exceeding $1600 US in to Canada. I would love a copy if it's out there?

Thanks

Jeff Mason

RDL

Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.

Reply | Messages in this Topic (1)

#141

From: ieuga@yahoogroups.com
Date: Thu Jan 3, 2008 3:26 pm
Subject: New file uploaded to ieuga

ieuga@yahoogroups.com

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the ieuga
group.

   File        : /SQL/Find Duplicate Credit Card Records.sql
   Uploaded by : ted_sturr <ted_sturr@...>
   Description : Pre 8.1.3 Upgrade - Find Duplicate Credit Cards

You can access this file at the URL:
http://groups.yahoo.com/group/ieuga/files/SQL/Find%20Duplicate%20Credit%20Card%2\
0Records.sql

To learn more about file sharing for your group, please visit:
http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.htmlfiles

Regards,

ted_sturr <ted_sturr@...>

Reply | Messages in this Topic (2)

#142

From: Bob Pearson <expandable4bob2@...>
Date: Fri Jan 4, 2008 5:19 pm
Subject: Re:SQL query to Expandable from within an Excel macro

expandable4bob2

Here is a way to do a SQL Query from within an Excel macro:

Dim qt As QueryTable, connstring, sqlstring

connstring = "ODBC;DSN=ESI;UID=username;PWD=password" 'Need valid SQL username and password

Workbooks.Add

sqlstring = "SELECT ICFSS.STORES_CODE, ICFSS.STOCK_LOCATION, ICFSS.PART_ID, ICFPM.PART_DESC, ICFSS.MO_BEG_QTY, ICFSS.RECEIPTS_MTD, ICFSS.ISSUES_MTD, ICFSS.ON_HAND_QTY, ICFPM.PART_UM, ICFPM.ABC_CODE FROM ICFSS ICFSS, ICFPM ICFPM WHERE ICFSS.PART_ID = ICFPM.PART_ID AND ICFSS.ON_HAND_QTY <> 0 ORDER BY ICFSS.STOCK_LOCATION, ICFSS.PART_ID"

With ActiveSheet.QueryTables.Add(Connection:=connstring, Destination:=Range("A1"), sql:=sqlstring)
    .FieldNames = True
    .Refresh (False)
    .Delete
End With

For Each aw In ActiveWorkbook.Names 'Deletes any External Data link
If InStr(aw.Name, "ExternalData") > 0 Then aw.Delete
Next aw

Bob Pearson

Intevac, Inc.

Looking for last minute shopping deals? Find them fast with Yahoo! Search.

#143

From: "George Whitehill" <george@...>
Date: Fri Jan 4, 2008 5:28 pm
Subject: Problem with Print a document to file on Terminal Server

itsmegw49

Happy New Year everyone,

I have a problem in Expandable when operating in Terminal Server. When I produce a document and try to save it to file, the window does not pop up showing where to save the file to. I am desiring to save a PDF file.

Thank you,

Best regards,

George Whitehill
Advanced Material Solutions
Phone 408-294-0100
Fax 408-291-0194
http://www.amsmrp.com

#144

From: Jonathan Borden <jborden@...>
Date: Fri Jan 4, 2008 5:25 pm
Subject: RE: Problem with Print a document to file on Terminal Server

silvermustan...

Produce a file in which portion of expandable? If you are running a expandable crystal report it is probably the crystal DLLs

From: ieuga@yahoogroups.com [mailto:ieuga@yahoogroups.com] On Behalf Of George Whitehill
Sent: Friday, January 04, 2008 9:28 AM
To: ieuga@yahoogroups.com
Subject: [ieuga] Problem with Print a document to file on Terminal Server

Happy New Year everyone,

Thank you,

Best regards,

George Whitehill
Advanced Material Solutions
Phone 408-294-0100
Fax 408-291-0194
http://www.amsmrp.com

#145

From: Emil Licka <elicka@...>
Date: Fri Jan 4, 2008 5:35 pm
Subject: Re: Problem with Print a document to file on Terminal Server

wi1d_bill

George,
I am attaching instructions that fixes this problem.

Emil

----- Original Message ----
From: Jonathan Borden <jborden@...>
To: "ieuga@yahoogroups.com" <ieuga@yahoogroups.com>
Sent: Friday, January 4, 2008 11:25:13 AM
Subject: RE: [ieuga] Problem with Print a document to file on Terminal Server

Produce a file in which portion of expandable? If you are running a expandable crystal report it is probably the crystal DLLs

From: ieuga@yahoogroups. com [mailto:ieuga@ yahoogroups. com] On Behalf Of George Whitehill
Sent: Friday, January 04, 2008 9:28 AM
To: ieuga@yahoogroups. com
Subject: [ieuga] Problem with Print a document to file on Terminal Server

Happy New Year everyone,

Thank you,

Best regards,

George Whitehill
Advanced Material Solutions
Phone 408-294-0100
Fax 408-291-0194
http://www.amsmrp. com