We are going to purchase an e-commerce software utilizing MS SQL but the
application (and others we have reviewed) does not have many reports that we
wish to have.
My question is, are there any good free or really expensive tools that we
can use to generated reports from SQL database?
Also, is that possible we create our own packing slip directly from SQL?
A little OT - Quite a rant on microsoft.public.sqlserver.olap ...SQL authentication doesn't work for SQL Server to anywhere. ... reports in ADP; but somehow it's not getting traction. ... thru in order to create forms and reports against a database. ... (microsoft.public.access.modulesdaovba)
Re: why>? ...MDB are a useful learning tool ... I used them for several years before moving to SQL.... We've got the most exciting pivotTables anywhere. ... it's each to share reports with others; copy reports; duplicate ... (microsoft.public.excel)
Re: Faircom c-Tree Server vs. Relational DBMS ... Our products were very reliable in terms of how the database...SQL was used for building and upgrading the ... to process reports that take several hours to run. ... what database tools to use) that are dictated by management... (comp.databases)
Re: View or Not Views ...SQL Server use the tempdb database to store temporary results and do the required calculations, but its a per-session "table", and you can't access or use these result directly. ... If you really want to access the database in your reports and you always access aggregated data, then create pre-aggregated tables to store the result and use these tables instead of you 500Gb table. ... (microsoft.public.sqlserver.olap)
Re: Using an MS Access Project with an OLE DB Data Source ... As far as SQL... they can create their own queries and reports.... you can link to both Oracle and SQL Server databases in the same mdb... (microsoft.public.access.externaldata)
