473,666 Members | 2,264 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Generating reports from database

I'm searching some package that allows to, from a SQL query to a database,
generate and send to printer and screen a report (sales detail, stock
report, etc.).

Somebody is doing something like this? Experiences?

Thank you!

.. Facundo

Jul 18 '05 #1
2 1749
What platform (e.g. Windows/Linux, ...)

On Windows it is nearly impossible to write something better
than Crystal Reports or Active Reports programs. They
are very flexible.

-Larry Bates
"Batista, Facundo" <FB******@uniFO N.com.ar> wrote in message
news:ma******** *************** *************@p ython.org...
I'm searching some package that allows to, from a SQL query to a database,
generate and send to printer and screen a report (sales detail, stock
report, etc.).

Somebody is doing something like this? Experiences?

Thank you!

. Facundo

Jul 18 '05 #2
Larry Bates wrote:
What platform (e.g. Windows/Linux, ...)

On Windows it is nearly impossible to write something better
than Crystal Reports or Active Reports programs. They
are very flexible.


But if you don't already own either of these products, this can be costly.

Check out RPV (www.rpvreport.com). It's a report engine that takes a
more simplistic approach to producing reports than Crystal. For around
$40-$50, you can purchase the product and distribute the runtime to ALL
of your clients royalty free.

I have used RPV from many Python and Ruby apps and it works great.

Jamey
Jul 18 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
1957
by: Ryan | last post by:
We have an MIS system which has approx 100 reports. Each of these reports can take up to several minutes to run due to the complexity of the queries (hundreds of lines each in most cases). Each report can be run by many users, so in effect we have a slow system. I want to seperate the complex part of the queries into a process that is generated each night. Then the reports will only have to query pre-formatted data with minimal...
3
1290
by: Dominic Feron | last post by:
Hello everyone, Here is the situation. I've looked all day about this subject over the net and I'm kinda confused... I was ask to generate, on a daily basis, some XML files from a SQL Server 2000 database. What is the best strategy to perform such a task?
0
268
by: Novice | last post by:
Hi all, I'm a novice VB.NET and VBA programmer and am wondering if there is a tutorial out there on how to create a word document based on data in a database and then return that document to a web user. I'm using Visual Studio .Net 2003 for my IDE I am familiar enough with VBA to be able to write all the code to generate the document, it is just that I'm not certain how to create the word document in memory and not have Office pop-up on the...
3
968
by: Connor T | last post by:
Hi, I wish to generate some relatively simple html reports from my ODBC database. I'm quite happy to write out raw html to a file, but before I do that I just wondered if there is any better solution for creating these reports? I was initially trying to get mailmerged word files working ( After giving up with crystal reports ) , however I have had issues on client's machines
4
2483
gregerly
by: gregerly | last post by:
Hello All, I just wanted to get some input from the experts, what options are available for generating reports using PHP / MySQL. I can easily create HTML reports, but I'm thinking more along the lines of PDF reports, or some other format that is easily generated. Anybody generate PDF reports with PHP? Is it difficult? What custom classes (if any) did you use to create the reports. Thanks in advance, greg
1
1276
by: sreedivya | last post by:
Hi, I am using Crystal Reports with .NET 2.0 for generating reports in my project. My database is SQLSERVER 2000. I want to display list of absentees between 2 given dates. For this I have written a stored procedure like below. CREATE procedure tesk4(@Fromdate DATETIME, @Todate DATETIME) as declare @return BIT
0
1852
by: Aswanth | last post by:
I'm Generating Reports in SSRS-2005.. Previously I got the Data from One Database & Generated Reports.. Now I used to get the Data from Two Different Databases(ie Database-1 & Database-2) & to generate the Reports.. I'm having one Stored Procedure(Get_Data) which will combine Two databases & get the data from them.. It is working fine for Me..(I tested in Sql Server Management Studio).. But it is Not working fine in my Visual Studio.. ...
0
1878
by: Aswanth | last post by:
I'm Working with Asp.Net with C#.. & I'm Generating Reports in SSRS-2005.. Till Now I'm Generating Reports in SSRS-2005 with Stored Procedure.. in Which I'm Generating Reports for One Particular User Details(ie I wrote Stored Procedure for Getting One Users Details).. Now I Want to Generate the Reports for Different Users DYNAMICALLY (Here, I wrote another Stored Procedure which contains UsersID's as Input...
2
1466
by: veer | last post by:
hi i made program in which i am generating the report of a ms-table database it works fine only on my computer and generatin the reports but when i run this exe on any computer the whole programe works fine except generating the report when i click on button which generates the report it shows the error "COULD NOT LOD FILE OR ASSEMBLY 'MICROSOFT.REPORTVIEWER.WINFORMS,VERSION=9.0.0.0, CULTURE=NEUTRAL, PUBLICKEYTOKEN= b03f5f11d50a3a , OR ONE...
0
8355
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8866
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8550
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8638
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6191
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4193
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4365
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2769
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2006
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.