MartyConnelly
martyconnelly at shaw.ca
Mon Jul 19 13:41:20 CDT 2004
SQL Reporting Services works with SQL Express Beta with some known bugs
using encrypted data.
Microsoft has a few 1 hour webcasts
TechNet Webcast: Microsoft SQL Server Reporting Services Technical
Overview - Level
Part 1
http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032255670&Culture=en-US
Part 2
http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032255691&Culture=en-US
Overview Architecture
http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032255609&Culture=en-US
There is a new book out that covers SQL 2005 may not be printed yet
Hitchhikers Guide to SQL Reporting Services by Addison
How to import reports from Microsoft Access to Reporting Services
http://support.microsoft.com/?kbid=834306
You could try this limited freeware ASP report tool works with SQL 2000
http://www.apexsql.com/index_asprpt.htm
Introduction to SQL Server 2000 Reporting Services
By Mike Gunderloy
http://www.developer.com/db/article.php/3323401
I tried to get into my local "Honest John's" downtown last week couldn't
get near the bar. We had been invaded by
half the ship's crew from the "Abraham Lincoln" carrier.
Jim Lawrence (AccessD) wrote:
>Thanks for all the information.
>
>I was hoping to go around the third-party printer options. VBxxx lack of
>report support has been the principle reason why I have had to avoid many
>applications designs in this environment. Many client bulk at the extra
>costs and we end up settling for Access.
>
>Does SQL Reporting server work with SQL Express?
>
>That code snippet is just great...I will try it out soon.
>
>I owe you a beer; we should get together sometime as you are a local yokel,
>from Gods-Country and partake in a few brew.
>
>Thanks again
>Jim
>
>-----Original Message-----
>From: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of
>MartyConnelly
>Sent: Saturday, July 17, 2004 1:16 PM
>To: dba-sqlserver at databaseadvisors.com
>Subject: Re: [dba-SQLServer] Some quick install notes and warnings on
>SQLExpress2005
>
>
>
>Two non-Crystal Reports or Accutate alternatives:
>Latest version of crystal 9.0 is server based and consequentially pricey
>
>1. ActiveReports (DataDynamics): VB people rave about this report
>writer. The designer is incredibly intuititive (if you've used Access
>you will be right at home in this designer). Imports Access Reports
>Price $499 or $1299 Pro
>
>http://www.datadynamics.com/Products/ProductOverview.aspx?Product=ARNET
>
>2. XtraReports (DevExpress): This product is pretty new, and is still
>rough around the edges, but it is less expensive than ActiveReports
>(especially considering that you get an End User Designer with the basic
>product, while you have to buy the Pro version of ActiveReports for the
>same feature). I have found the designer not quite as nice/intuitive as
>ActiveReports, but still very nice, and one can be productive with it
>once getting the hang of how the product is put together.
>Price $199 or $399 with source code
>
>http://www.devexpress.com/?section=/products/NET/XtraReports
>
>
>
>MartyConnelly wrote:
>
>
>
>>There is a new data grid control with vb.net express.
>>
>>You could use SQL Reporting Services, there is a wizard to upgrade
>>Access reports to SQL Service.
>>
>>Or if you want just local reporting with vb.net and you have Access
>>installed you can use Access Reports.
>>Here is some code that should run under vb.net to print locally,
>>preview or email report.
>>
>>You will need the Access mdb to test against.
>>You may have to modify the Access database and play with to get print
>>menu selection
>>working properly.
>>It has a menu toolbar to direct to various printers or email
>>
>>'http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm
>>' Acesss97 example With ms-access interface hidden:
>>
>>And here is the method to call it.
>>I tested this with another Access program but should work with VB.
>>
>>You can even remove the Access Key Icon or set to your own
>>in the upper corner, can't remember how but have done it.
>>
>>
>>
>>Option Compare Database
>>Option Explicit
>>Private Const SW_SHOWMAXIMIZED = 3
>>Private Const SW_SHOWNORMAL = 1
>>Private Const SW_HIDE = 0
>>Private Declare Function apiSetForegroundWindow Lib "user32" _
>> Alias "SetForegroundWindow" _
>> (ByVal hWnd As Long) As Long
>>Private Declare Function apiShowWindow Lib "user32" _
>> Alias "ShowWindow" _
>> (ByVal hWnd As Long, ByVal nCmdShow As Long) As Long
>>Sub test()
>>'http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm
>>' Acesss97 example With ms-access interface hidden:
>>Dim accRpt As Access.Application
>>Set accRpt = CreateObject("Access.Application")
>>With accRpt
>>.Application.OpenCurrentDatabase ("C:\WordVBA\Kallal Word Merge Easy
>>Samples\WordMerge22\WordMerge22.mdb")
>>.Application.DoCmd.Maximize
>>.Application.Visible = True
>>Call apiSetForegroundWindow(.hWndAccessApp)
>>'Call apiShowWindow(.hWndAccessApp, SW_SHOWNORMAL)
>>Call apiShowWindow(.hWndAccessApp, SW_SHOWMAXIMIZED)
>>' Call apiShowWindow(.hWndAccessApp, SW_HIDE)
>>' .Application.DoCmd.OpenForm "frmDefaultPrinterList"
>>'displays the custom toolbar named CustomToolbar in all Microsoft
>>Access windows that become active:
>>
>>.Application.DoCmd.ShowToolbar "Rides Print", acToolbarYes
>>'DoCmd.ShowToolbar
>>.Application.DoCmd.OpenReport "Contacts", Access.AcView.acViewPreview
>>'Set the focus to MSACCESS
>>'alternate method
>>'Dim lngAcc As Long
>>' lngVal = FindWindow("OMain", ByVal 0&)
>> ' lngAcc = SetFocusAPI(lngVal)
>>'must close form to exit second app 'acReport=3;acObjStateOpen=1
>>
>> Do While .SysCmd(acSysCmdGetObjectState, acReport, "Contacts") =
>>acObjStateOpen
>> DoEvents
>> Loop
>>.Quit acQuitSaveNone
>>
>>'MsgBox "Print"
>>End With
>>Set accRpt = Nothing
>>End Sub
>>
>>
>>
>>
>>Jim Lawrence (AccessD) wrote:
>>
>>
>>
>>>Hi Marty:
>>>
>>>Fine piece of investigation.
>>>
>>>I was just about to install SQL Empress on my 2003XP server, one with
>>>SQL
>>>2000/EM and would have lost the manager. I wondering if there is a work
>>>around as I was hoping to have an application put together using
>>>Access2003
>>>or VB.Net and SQL Express, by the end of the summer.
>>>
>>>Looks like that will not be possible for a while.
>>>
>>>I guess if the application is assembled, using SQL2000, the table
>>>structure/SP etc.. should be portable to SQL Express, on a XP box and
>>>Express.
>>>
>>>A little off topic:
>>>
>>>I have been trying to find some info on reporting capabilities of
>>>VB.Net...does it have any or does it require a third-party product
>>>like VB6?
>>>Has anyone worked or found a good site with code related to extending
>>>VB.Net
>>>grid capabilities?
>>>
>>>Any suggestions will be appreciated.
>>>Jim
>>>
>>>-----Original Message-----
>>>From: dba-sqlserver-bounces at databaseadvisors.com
>>>[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of
>>>MartyConnelly
>>>Sent: Saturday, July 17, 2004 8:48 AM
>>>To: dba-sqlserver at databaseadvisors.com
>>>Subject: [dba-SQLServer] Some quick install notes and warnings on SQL
>>>Express2005
>>>
>>>
>>>SQL Express 2005 is Yukon and replacement for MSDE. However, like
>>>MSDE, SQL
>>>Express does not have any administrative interfaces. Review the
>>>installed
>>>documentation and its own BOL to learn more about SQL Express. They are
>>>supposed to bring out a Beta EM, backward compatible with MSDE.
>>>
>>>Some notes I have picked up that may help.
>>>
>>>1-------------------------------------------------
>>>SQL Express can't run on XP Home, so what is the purpose?
>>>
>>>One of the purposes for SQL Express is deployment with
>>>applications instead of JET. Now the software companies
>>>involved have to force their clients to buy XP Pro????
>>>Arrrghhhh!
>>>
>>>There are rumors you may be able to modify TCP ports to get around this.
>>>
>>>System Requirements for Express
>>>
>>>http://lab.msdn.microsoft.com/express/sysreqs/
>>>
>>>2 --------------------------------------------------
>>>FAQ: Installing SQL Express side by side with SQL 2000 Enterprise
>>>Manager
>>>seems to break EM. It is still broken when You uninstall Express.
>>>SQLDMO9 is
>>>culprit.
>>>
>>>http://blogs.msdn.com/sqlexpress/archive/2004/07/04/172956.aspx
>>>http://blogs.msdn.com/sqlexpress/archive/2004/07.aspx
>>>
>>>3 -------------------------------------------
>>>I noticed that the DTS Runtime will not be included. In Access, you
>>>get the
>>>DTS Runtime when you install MSDE. Does this mean that DTS will not be
>>>available in Access?
>>>
>>>Currently, I use DTS to interact with SQL Server databases hosted at
>>>ISPs.
>>>It is a quick and easy solution to use the DTS Wizard to upload data
>>>from
>>>the Access database to the SQL Server database using bulk insert. I
>>>would
>>>hate to see that go away.
>>>
>>>4 -------------------------------------------------
>>>SQL Server Express does not have any connection limits. 4GB max size
>>>It doesn't install any test databases but there is a sample pubs
>>>database
>>>script install from download pages.
>>>I think you can install side by side with MSDE but you will break EM
>>>
>>>5.--------------------------------------------------
>>>SQL Server 2000 Reporting Services fails after installing SQL Server
>>>2005
>>>Fix here
>>>http://blogs.msdn.com/sqlexpress/archive/2004/07/07/175820.aspx
>>>
>>>--------------------------------------------------------------------
>>>Welcome to the Visual Web Developer 2005 Express Edition Beta Guided
>>>Tour
>>>
>>>http://beta.asp.net/GuidedTour/s2.aspx
>>>
>>>Beta Private newsgroup -- good for problems
>>>
>>>microsoft.private.sqlserver2005.express
>>>
>>>
>>>
>>>
>http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&sl
>
>
>>>cid=us
>>>
>>>
>>>Express overview
>>>
>>>
>>>
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/
>
>
>>>sseoverview.asp
>>>
>>>
>>>--
>>>Marty Connelly
>>>Victoria, B.C.
>>>Canada
>>>
>>>
>>>
>>>_______________________________________________
>>>dba-SQLServer mailing list
>>>dba-SQLServer at databaseadvisors.com
>>>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>>>http://www.databaseadvisors.com
>>>
>>>_______________________________________________
>>>dba-SQLServer mailing list
>>>dba-SQLServer at databaseadvisors.com
>>>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>>>http://www.databaseadvisors.com
>>>
>>>
>>>
>>>
>>>
>>>
>
>--
>Marty Connelly
>Victoria, B.C.
>Canada
>
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>
>
>
--
Marty Connelly
Victoria, B.C.
Canada