× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



SQL Server Express include SQL Server Reporting Services (SSRS).

SQL Server Express does not include SQL Server Analysis Services (SSAS) or SQL Server Integration Services (SSIS).

Craig Pelkie

----- Original Message ----- From: "Vern Hamberg" <vhamberg@xxxxxxxxxxx>
To: "RPG programming on the IBM i / System i" <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, August 03, 2010 5:12 PM
Subject: Re: Pictures in a report?


Alan

Does SQL Server Express come with Report Writer? Or is that one of the
things you DON'T get? :-)

Vern

On 8/3/2010 7:04 PM, Alan Campin wrote:
Better solution than all of that. Don't use the AS/400 as a report writer.
If you have SQL Server, just create a report in SQL Server Report Writer
pulling the data from the AS/400 (I use stored procedures written in RPG to
pull the data).

RPG is such a waste to write reports. I especially like Sql Server Report
Writer for writing reports because almost all shops have it and the result
is web document that you can link to and you get a nice look GUI report with
minimal effort.

If you don't have the report writer it worth it to just buy a standard
edition of SQL Server (A few hundred dollars) just for the report writer.

The only reports I write on the AS/400 are like auditing or something and I
just write records to a file and use the STRQM to write the report.

On Tue, Aug 3, 2010 at 5:39 PM, Booth Martin<booth@xxxxxxxxxxxx> wrote:


Would a Third Way be of interest?

For all of the energy you have in it already you could have published
the report to an intranet site, where they could view it at their
leisure. Then, if they happened to want it printed out, they could
print from the browser. That way, they get color too.

I have also used the same solution, except writing the report.html to an
ifs directory instead of a web server, and them mapping that directory
to the user's PC.

Just a thought. (By the way, when I used those solution it resolved a
whole lot of intramural political problems too. It was a big win all
the way around.)



On 8/3/2010 7:01 PM, James H. H. Lampert wrote:

I've just gone partway through the AFP Utilities Tutorial on our V6 box.

I now have an overlay, and a spool file of that overlay, but no apparent
way to see what it looks like.

Tried sending it to myself as a PDF, using MMAIL. Ended up with an error
message out of MMAIL, and a malformed PDF that was undisplayable.

I also looked at the customer's box. They don't have a QAFP library.

Definitely weird.

--
JHHL

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.



--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.