JavaScript - Web Services and Dynamic HTML

Few days ago I did a study of how a dynamic browser based client software can be, below is some findings related to usage of "Web Service" and Update of ListBox dynamically:

[Access of Web Service by using JavaScritp]
http://www.daniweb.com/forums/thread145927.html
http://msdn.microsoft.com/en-us/library/bb263974(VS.85).aspx

[Change content of HTML page dynamically]
http://dev.aol.com/accessibility/bestpractices/selectlist

Crystal Report - Grouping and Page Width

Below is an example of using "Group" feaure of Crystal Report Wizard. The example show that the first two fields are related to the group while remained fields are related to each record of the group.

However, this kind of grouping is done in client station instead of Server (based on Query result of SQL command), and will have performance issue if there are a large number of records.

According to user manual of Crystal Report 2008, chapter 6, it is possible to change width of a page (in function "Page Setup") so that information of large number of fields can be displayed properly. However, seems this feature is missing in the build-in Crystal Report tools of Visual Studio 2008.

Crystal Report - Query in Server

Try to use Crystal Report in these few days. Below is an example of passing parameter to a SQL command to ensure the query is done in server side.

There is no significant different in performance while "where" is used instead of "on".

However, if using "Selection Formula --> Record", all records will be send to client station before records selection and it will cause serious performance downgrade if number of records is large.