crystal reports viewers, crystal reports schedulers, view crystal reports, report analyzers, burst reporting, report scheduler
 
view crystal reports, rpt viewer, crystal reports viewers, crystal reports schedulers, report analyzers, burst reporting, report scheduler
desktop viewer, crystal reports viewers, crystal reports schedulers, report analyzers, burst reporting, report scheduler

Crystal Reports Tools: Improve Performance While Saving Time and Money

cView SQL: Process SQL commands against a database
  Resources  
Best sellers:
cView
Report Analyzer
cViewSERVER
 ReCrystallize
 


Articles:
 Administration
Advanced
Basic
 Crystal eNL
Database
Financial
Problems Solved

 Books:
CR Books
Database Books
Developer Books
 
Tools:
Analyzers
Bestsellers
CR Schedulers
CR UFLs
CR Viewers
DataBase Tools
Graphics
International
Mail UFLs
ReCrystallizePro


Add'l:
About us
Contact Us
cViewSUITE Ppt
Support
 

CrystalReports
on Steroids

 cViewSQL is a powerful database utility that gives you the ability to process SQL commands against a database.

 cViewSQL connects to a database using an ODBC connection. It can process SQL statements in that database. It supports ODBC compliant database (e.g. MS-Access, SQL-Server, Oracle, MS-SQL).

cViewSQL: Process SQL commands against a database, SQL command processing in databases, file import, file export, csv export, html reports, exception reports, bulk updates, sql server, odbc reports, mysql reports, upload mysql, download mysql, mysql data extracts, oracle reports, upload oracle, download oracle, oracle data extracts, database tools, database utilities, export csv, database extracts, cviewsql, database update, table update, update oracle, update access, update sql, sequel, create table, strip duplicates, data scrubbing, automatic upload, automatic update, automatic delete, exception email, database management

Pricing | Buy Now
It's easy to run! You can manually run cViewSQL from the user interface or from a command line, scheduled in a BAT file. Or, you can schedule it in our cViewMANAGER or cViewSERVER report schedulers.

cViewSQL includes four basic processes. Combine these with the other functions, and you have a a combined tool that can:

  • Create your database
  • Load data from an external source
  • Update selected records
  • Send you the results as a file attachment to an email.

cViewSQL empowers you to do such things as:

  • Execute an SQL command against the database.
  • Execute a series of SQL commands that are in an external text file.
  • Upload a text file into a database table.
  • Export from the database to a text file, tab delimited file or XML file.
  • Generate an HTML page from the data.
  • Delete data
  • Update data
  • Create tables
  • Create a temporary summary table
  • Copy tables from one ODBC data source to another
  • Process a text file that contains multiple SQL commands
  • Process an action query on MS-Access databases
  • Export data from your cViewSQL system to send to another cViewSQL user
  • Recognize duplicate values and remove them prior to the upload into the database.
  • Process a SQL update or delete in the database.

But, don't stop there. Using cViewSQL, you can also:

  • Process a series of SQL commands from a text file. This works really well with our DISK Output User Function Library. Use a the functions in a crystal report to generate some SQL update statements--then process the file with cViewSQL .
  • Generate an HTML or XML page on your Web server with the latest database values.
  • Generate CSV or Tab delimited text fields, to transfer the data into another system.
  • Upload CSV or Tab delimited fields into a database table.
  • Email an exception report to you each day as an HTML message.
  • Run a Crystal Report to identify some data that need fixing. Use our Disk Output user function library to write the SQL update statements to fix those records and process them automatically using a cViewSQL command.
  • Place multiple CSV files in a folder, and have them all process and upload values into the database.
  • Create a cViewSQL task that extracts specific data from a database and saves it as a XML file on your Web server.

This functionality is more than just reporting from your data. It allows you to modify the data and of course requires the appropriate permissions for your database environment.

cViewSQL replaces two of our previous products (cViewODBCopy and cViewDBUpdate), plus it adds major extra functionality. You can run cViewSQL from the desktop application, or using a command line. You can automate cViewSQL with our cViewMANAGER or cViewSERVER schedulers.