SQL Server Business Intelligence

Wednesday, December 22, 2010

PassMark Intel vs AMD CPU Benchmarks - High End

PassMark Intel vs AMD CPU Benchmarks - High End

Intel Core i7 X 995 @ 3.60GHz10,795 NA
Intel Core i7 980X @ 3.33GHz10,458 $999.99*
Intel Core i7 970 @ 3.20GHz9,983 $879.99*
Intel Core i7-2600K @ 3.40GHz9,870 NA
Intel Xeon W3680 @ 3.33GHz9,577 $1,108.16*
Intel Xeon X5680 @ 3.33GHz9,540 $1,689.99*
Intel Xeon X5670 @ 2.93GHz9,151 $1,452.99*
Intel Core i7-2600 @ 3.40GHz9,136 NA
Intel Xeon X5660 @ 2.80GHz8,324 $1,229.99*
AMD Opteron 6176 SE8,203 $1,386.00**
Intel Xeon X5650 @ 2.67GHz8,146 $1,005.99*
Intel Xeon L5640 @ 2.27GHz7,332 $1,016.99*
Intel Core i7 975 @ 3.33GHz7,026 $1,044.49*
Intel Xeon W5590 @ 3.33GHz6,960 $1,719.74*
Intel Core i7 965 @ 3.20GHz6,810 $1,498.95*
Intel Xeon W3570 @ 3.20GHz6,776 $1,105.48**
Intel Core i5-2500 @ 3.30GHz6,715 NA
Intel Xeon W3580 @ 3.33GHz6,714 $1,083.47**
Intel Core i7 880 @ 3.07GHz6,691 $583.00**
Intel Core i7 960 @ 3.20GHz6,671 $569.99*
Intel Core i7 875K @ 2.93GHz6,475 $310.39*
Intel Xeon W5580 @ 3.20GHz6,457 $1,723.39*
Intel Xeon W 570 @ 3.20GHz6,402 NA
Intel Core i5-2400 @ 3.10GHz6,364 NA
Intel Core i7 950 @ 3.07GHz6,331 $294.98*
Intel Xeon X5667 @ 3.07GHz6,294 $1,440.00**
Intel Xeon X3460 @ 2.80GHz6,239 $348.99**
Intel Core i7 940 @ 2.93GHz6,131 $599.99*
Intel Xeon X5677 @ 3.47GHz6,119 $1,663.00**
Intel Core i7 870 @ 2.93GHz6,072 $279.99*
AMD Phenom II X6 1090T6,063 $229.00*
Intel Xeon W3565 @ 3.20GHz6,030 $639.14**
Intel Xeon X3470 @ 2.93GHz5,902 $349.99**
Intel Core i7 930 @ 2.80GHz5,834 $311.91*
AMD Phenom II X6 1100T5,738 $269.99*
AMD Phenom II X6 1075T5,662 $199.99*
Intel Xeon W3550 @ 3.07GHz5,642 $366.49**
Intel Core i7 920 @ 2.67GHz5,557 $389.94*
Intel Core i7 860 @ 2.80GHz5,556 $293.45*
Intel Core i7 S 870 @ 2.67GHz5,554 NA
Intel Xeon X5560 @ 2.80GHz5,484 $1,208.84*
Intel Xeon X3450 @ 2.67GHz5,422 $269.89*
Intel Xeon X5570 @ 2.93GHz5,418 $1,459.99*
Intel Xeon W3540 @ 2.93GHz5,368 $630.74*
Intel Xeon X3440 @ 2.53GHz5,290 $243.49*
Intel Xeon X5550 @ 2.67GHz5,232 $1,004.13*
Intel Xeon X5492 @ 3.40GHz5,223 $1,391.29*
Intel Xeon E5640 @ 2.67GHz5,222 $792.39*
AMD Phenom II X6 1055T5,181 $179.00*
AMD Opteron 61285,147 $275.99*
AMD Phenom II X6 1045T5,121 NA
Intel Core2 Extreme X9750 @ 3.16GHz5,022 NA
Intel Core2 Extreme X9770 @ 3.20GHz4,993 $1,400.00**
Intel Xeon X5482 @ 3.20GHz4,988 $1,279.00**
Intel Xeon W3530 @ 2.80GHz4,960 $332.49*
Intel Xeon X5460 @ 3.16GHz4,884 $1,205.84*
Intel Xeon E5630 @ 2.53GHz4,867 $554.25*
Intel Xeon W3520 @ 2.67GHz4,865 $303.99*
AMD Phenom II X6 1035T4,800 NA
Intel Xeon E5530 @ 2.40GHz4,716 $575.49*
Intel Xeon L3426 @ 1.87GHz4,716 $310.99**
Intel Xeon X5472 @ 3.00GHz4,711 $844.50**
Intel Xeon E5620 @ 2.40GHz4,605 NA
Intel Core2 Quad Q9650 @ 3.00GHz4,602 $329.99*
Intel Core2 Extreme X9650 @ 3.00GHz4,593 $999.00**
Six-Core AMD Opteron 24314,586 $814.81**
Intel Xeon X5450 @ 3.00GHz4,581 $1,009.95*
Intel Core i5 760 @ 2.80GHz4,573 $199.99*
AMD Phenom II X4 9704,530 $184.99*
Intel Xeon X3370 @ 3.00GHz4,515 $353.49*
Intel Core i7 920XM @ 2.00GHz4,420 $1,144.69**
Intel Xeon E5440 @ 2.83GHz4,409 $798.95*
Intel Core i7 940XM @ 2.13GHz4,408 NA
Intel Core2 Quad Q9550 @ 2.83GHz4,366 $274.99*
Intel Xeon E5540 @ 2.53GHz4,362 $806.75*
Intel Xeon E5520 @ 2.27GHz4,340 $411.99*
AMD Phenom II X4 B974,323 NA
AMD Phenom II X4 9654,265 $159.99*
AMD Phenom II X4 B604,230 NA
Intel Xeon X3350 @ 2.66GHz4,228 $316.00**
Intel Core i5 750 @ 2.67GHz4,224 $199.99*
Intel Xeon E5450 @ 3.00GHz4,183 $1,058.95*
Intel Xeon X3360 @ 2.83GHz4,168 $290.99*
Intel Core2 Quad Q9500 @ 2.83GHz4,119 $183.00**
Intel Core2 Quad Q9505 @ 2.83GHz4,115 $238.49*
Intel Xeon E5430 @ 2.66GHz4,103 $537.99*
AMD Phenom II X4 404,070 NA
AMD Athlon II X4 5554,069 NA
AMD Opteron 4170 HE4,057 $183.99*
Intel Xeon X5365 @ 3.00GHz4,038 $999.99*
Intel Core2 Quad Q9450 @ 2.66GHz4,037 $398.95**
AMD Phenom II X4 B554,000 NA
Intel Core2 Extreme @ 2.40GHz3,981 NA
AMD Phenom II X4 9553,941 $144.99*
AMD Phenom II X4 B953,937 $225.00**
Intel Core2 Extreme Q6850 @ 3.00GHz3,885 NA
Intel Xeon E5462 @ 2.80GHz3,851 $498.95*
Intel Core2 Extreme X9775 @ 3.20GHz3,810 $1,747.99*
Intel Core i7 840QM @ 1.87GHz3,809 $579.99*
Intel Core2 Quad Q9400 @ 2.66GHz3,807 $199.99**
Intel Core2 Extreme Q9300 @ 2.53GHz3,785 NA
Intel Xeon X3230 @ 2.66GHz3,777 $323.99**
AMD Phenom II X4 B933,754 NA
Intel Xeon X3330 @ 2.66GHz3,723 $210.49*
AMD Athlon X4 6403,693 NA
Intel Xeon E5420 @ 2.50GHz3,691 $519.95*
AMD Phenom II X4 9403,678 $109.99*
AMD Phenom II X4 B503,667 NA
Intel Core2 Quad Q8400 @ 2.66GHz3,664 $169.99*
Intel Xeon E5507 @ 2.27GHz3,649 $289.99**
Intel Xeon X3430 @ 2.40GHz3,638 $213.99*
Intel Core2 Extreme Q6800 @ 2.93GHz3,633 $1,125.00**
Intel Core i7 740QM @ 1.73GHz3,614 $394.65*
AMD Phenom II X4 B453,604 NA
Intel Xeon X3320 @ 2.50GHz3,601 $222.65*
Intel Core i5 680 @ 3.60GHz3,600 $299.99*
AMD Phenom II X4 9453,600 $135.99*
Intel Core2 Quad Q9300 @ 2.50GHz3,574 $226.99*
Intel Core2 Quad Q8300 @ 2.50GHz3,558 $149.99*
AMD Phenom II X4 840T3,535 NA
AMD Phenom II X4 8203,530 NA
Intel Core i7 820QM @ 1.73GHz3,522 $546.00**
Intel Core i5 655K @ 3.20GHz3,521 $199.99*
AMD Phenom II X4 8303,521 NA
Intel Core2 Extreme @ 2.26GHz3,518 NA
Intel Xeon X5355 @ 2.66GHz3,518 $898.95**
AMD Phenom II X4 B403,510 NA
AMD Phenom II X4 B353,474 NA
AMD Athlon II X4 6403,461 $99.99*
Intel Xeon E5410 @ 2.33GHz3,448 $398.95*
Intel Xeon L5520 @ 2.27GHz3,442 $568.99**
AMD Phenom II X4 9253,424 $129.99*
Intel Core2 Quad Q9100 @ 2.26GHz3,423 $385.89*
AMD Athlon II X4 6453,411 $115.99*
Intel Xeon E5506 @ 2.13GHz3,393 $239.49*
Intel Core2 Quad Q6700 @ 2.66GHz3,376 $798.95**
AMD Phenom II X4 B253,353 NA
AMD Athlon II X4 6353,334 $99.99*
Intel Core i3 560 @ 3.33GHz3,300 $141.99*
AMD Phenom II X4 9203,292 $119.99**
Intel Core i5 661 @ 3.33GHz3,287 $209.99*
AMD Phenom II X4 9103,285 $204.19**
Intel Core2 Quad Q8200 @ 2.33GHz3,260 $229.95*
Intel Core i7 720QM @ 1.60GHz3,259 NA
AMD Athlon II X4 6303,248 $88.99*
AMD Phenom FX-5200 Quad-Core3,239 NA
Quad-Core AMD Opteron 23783,189 $179.00**
Intel Core i5 670 @ 3.47GHz3,171 $299.99*
Intel Core i5 650 @ 3.20GHz3,113 $182.99*
Intel Core i5 660 @ 3.33GHz3,107 $207.99*
AMD Phenom II X4 8103,097 $115.99**
Intel Xeon E5504 @ 2.00GHz3,075 $246.49*
Intel Xeon X3220 @ 2.40GHz3,053 $349.95*
AMD Phenom 9950 Quad-Core3,044 $156.99**
AMD Phenom II X4 8053,030 $173.99**
Intel Core2 Quad Q9000 @ 2.00GHz3,027 $390.35*
Intel Core i7 M 640 @ 2.80GHz3,003 NA
Intel Core i3 550 @ 3.20GHz3,001 $114.99*
AMD Phenom FX-5000 Quad-Core2,981 NA
AMD Athlon II X4 6202,980 $89.00**
AMD Phenom II X4 910e2,978 $191.27*
Intel Core2 Quad Q6600 @ 2.40GHz2,977 $398.95*
AMD Phenom 9850 Quad-Core2,958 $69.99*
AMD Phenom II X4 900e2,945 NA
AMD Phenom II X920 Quad-Core2,937 NA
Intel Xeon E5345 @ 2.33GHz2,902 $798.95**
Intel Xeon E5405 @ 2.00GHz2,893 $254.29*
AMD Phenom II X4 05e2,891 NA
AMD Phenom II X3 7402,866 $88.99**
AMD Athlon II X4 615e2,833 $154.12*
AMD Phenom II X4 905e2,814 $192.48*
AMD Athlon II X3 4502,809 $79.00*
Intel Core i3 540 @ 3.07GHz2,803 $113.99*
AMD Phenom 9750 Quad-Core2,779 $99.00*
Intel Core i5 520 @ 2.40GHz2,777 NA
AMD Athlon II X4 610e2,769 $146.86*
Intel Core i7 620M @ 2.67GHz2,722 $332.00**
AMD Athlon II X3 4452,711 $77.00*
Intel Core i3 530 @ 2.93GHz2,705 $119.99*
Intel Xeon X5260 @ 3.33GHz2,697 $851.00**
AMD Phenom II N950 Quad-Core2,696 NA
Intel Core2 Duo E8600 @ 3.33GHz2,657 $287.99*
Quad-Core AMD Opteron 13562,653 $211.80**
AMD Phenom 9650 Quad-Core2,648 $110.00**
Quad-Core AMD Opteron 23802,640 $391.06**
AMD Athlon II X4 605e2,639 $137.80*
Intel Xeon X3210 @ 2.13GHz2,625 $209.99**
AMD Phenom 9600B Quad-Core2,625 $147.19**
Quad-Core AMD Opteron 13522,620 $135.99**
Intel Core i5 M 460 @ 2.53GHz2,602 NA
AMD Phenom II X3 7202,593 $99.00**
AMD Athlon II X4 6400e2,569 NA
AMD Athlon II X4 600e2,567 $140.67*
AMD Phenom 9550 Quad-Core2,542 $99.97**
AMD Athlon II X3 4402,538 $83.99*
AMD Athlon II X3 4352,536 $75.99**
AMD Phenom II N930 Quad-Core2,514 NA
Intel Core i5 M 580 @ 2.67GHz2,509 NA
Quad-Core AMD Opteron 13542,507 $309.97**
AMD Phenom II X4 B15e2,491 NA
AMD Phenom II X3 B732,489 NA
Intel Core i5 450M @ 2.40GHz2,484 NA
Intel Xeon E5335 @ 2.00GHz2,477 $649.95**
Intel Core i5 540M @ 2.53GHz2,460 $279.99*
AMD Phenom 9750B Quad-Core2,458 NA
AMD Phenom 9600 Quad-Core2,442 $95.00*
AMD Phenom 9450e Quad-Core2,422 $85.00*
Intel Core2 Duo E8500 @ 3.16GHz2,412 $191.05*
AMD Phenom II X3 B752,410 NA
AMD Athlon X3 4402,382 $87.99**
Intel Core i5 M 560 @ 2.67GHz2,372 $270.03*
Intel Xeon E3110 @ 3.00GHz2,367 $181.49*
Intel Core i5 430M @ 2.27GHz2,356 $79.00**
Intel Core i5 520M @ 2.40GHz2,330 $234.99*
AMD Phenom 9350e Quad-Core2,319 $194.99**
Intel Core2 Extreme X9100 @ 3.06GHz2,307 $851.00**
AMD Athlon II X3 4252,306 $60.99*
Intel Core2 Duo T9900 @ 3.06GHz2,294 $530.00**
Intel Xeon E5320 @ 1.86GHz2,292 $398.95**
AMD Phenom 9500 Quad-Core2,290 $89.96**
AMD Phenom II X3 705e2,278 $152.34**
Intel Xeon L5240 @ 3.00GHz2,277 NA
Pentium Dual-Core E6700 @ 3.20GHz2,267 NA
Intel Core2 Duo E8435 @ 3.06GHz2,251 NA
Intel Core2 Duo E8400 @ 3.00GHz2,245 $169.99*
AMD Phenom II X3 7102,242 $90.99**
Intel Core2 T9550 @ 2.66GHz2,235 NA
Intel Core i3 M 380 @ 2.53GHz2,223 NA
Intel Core2 Duo E8700 @ 3.50GHz2,212 NA
AMD Phenom II P940 Quad-Core2,201 NA
Pentium Dual-Core E6600 @ 3.06GHz2,199 $83.34*
Intel Core2 Duo T9800 @ 2.93GHz2,198 $423.89**
Intel Core i3 370M @ 2.40GHz2,196 NA
AMD Phenom 8850B Triple-Core2,195 NA
AMD Athlon II X3 415e2,194 $103.74*
Pentium Dual-Core E5700 @ 3.00GHz2,192 $73.79**
AMD Phenom 9150e Quad-Core2,168 NA
Pentium Dual-Core E6800 @ 3.33GHz2,154 $98.65*
AMD Phenom X4 Quad-Core GP-95002,152 NA
Intel Core2 Duo P9700 @ 2.80GHz2,133 NA
Intel Core i7 640LM @ 2.13GHz2,125 $332.00**
AMD Phenom II N850 Triple-Core2,112 NA
Intel Core2 Duo E7600 @ 3.06GHz2,106 $138.30*
AMD Phenom X3 87502,082 $59.99**
Intel Pentium E6700 @ 3.20GHz2,065 NA
Intel Core2 Duo E8335 @ 2.93GHz2,062 NA
AMD Phenom II X2 5602,060 $99.99*
Intel Xeon W3505 @ 2.53GHz2,058 NA
Intel Core i3 350M @ 2.27GHz2,054 NA
Intel Core2 Duo T9600 @ 2.80GHz2,022 $339.99*
Pentium Dual-Core E6500 @ 2.93GHz2,017 $78.08*
AMD Athlon II X2 2652,017 $69.99*

Internals Viewer for SQL Server

Internals Viewer for SQL Server

Internals Viewer for SQL Server

Internals Viewer for SQL Server

Thursday, October 29, 2009

Crystal Reports for .NET SDK Samples

 clipped from wiki.sdn.sap.com

Crystal Reports .NET SDK Samples

General
Viewing
Database
Parameter
Exporting/Printing
Report Modification

General

Crystal Reports .NET - All Sample Applications
This set includes the following samples:

  • cr_net_sdk_tutorial_samples_en.zip
  • crsdk_net_samples_12.zip
  • NET-CPP2005_CRNET_CR115_Change_Record-Selection-Formula.zip
  • NET-CS-Win_CR12_Creating-Custom-Addins.zip
  • NET-CS_CRNET_CR115_Get_SQL-Query.zip
  • NET-CS2003_RAS-Unmanaged_CR115_Modify_Command-Table-SQL.zip
  • NET-CS2005_CRNET_CR115_Modify_Image-Location.zip
  • NET2003-CS-Web_CRNET_CR115_change_graphic-location.zip
  • NET-Cplus-Win_CRNET_CR115_Get_Viewer-Events.zip
  • NET-CPP-Win2005_CRNET_CR115_view_report.zip
  • NET-CS2005_CRNET_CR115_Set_Viewer-Locale-by-Page.zip

Crystal Reports 2008 .NET SDK Tutorial Samples
This sample contains Visual Studio 2005 Web sample code projects that highlight features of the Crystal Reports .NET SDK, including viewing and exporting reports, filtering data and setting parameters, and connecting to different data sources.

Crystal Reports .NET SDK - Sample Applications from Tutorials
This file contains C# and VB .NET Windows and web sample applications. These samples were built using the tutorials provided in the 'Crystal Reports .NET SDK - Additional Documentation and Tutorials' (cr_net_sdk_additional_en.zip). These sample applications apply to Crystal Reports 9 and 10, and Crystal Reports for Visual Studio .NET 2002 and 2003.

Csharp (C#) Web Sample Applications for use in Microsoft Visual .Net 2002 and Later
This set includes the following samples:

  • csharp_web_accesssubreport.zip
  • csharp_web_adonet.zip
  • csharp_web_discreteparams.zip
  • csharp_web_export.zip
  • csharp_web_rangeparams.zip
  • csharp_web_serverfilereports.zip
  • csharp_web_simplelogonengine.zip
  • csharp_web_simplelogonviewer.zip
  • csharp_web_simplepreviewreport.zip
  • csharp_web_sub_daterange_param.zip
  • csharp_web_subreport_logon.zip
  • cr10_csharp_web_clientprinting.zip

VB.NET (VB) Web Sample Applications for use in Microsoft Visual .Net 2002 and Later.
This set includes the following samples:

  • vbnet_web_adonet.zip
  • vbnet_web_simplelogonengine.zip
  • vbnet_web_simplelogonviewer.zip
  • vbnet_web_export.zip
  • vbnet_web_discreteparams.zip
  • vbnet_web_multirangeparams.zip
  • vbnet_web_rangeparams.zip
  • vbnet_web_simplepreviewreport.zip
  • vbnet_web_sortfields.zip
  • vbnet_web_accesssubreport.zip
  • vbnet_web_subreport_logon.zip
  • vbnet_web_sub_daterange_param.zip
  • vbnet_web_reportpartsviewer.zip

Csharp (C#) Windows Sample Applications for use in Microsoft Visual .Net 2002 and Later
This set includes the following samples:

  • csharp_win_adodotnet.zip
  • csharp_win_classicado.zip
  • csharp_win_dbengine.zip
  • csharp_win_dbviewer.zip
  • csharp_win_DynamicImage.zip
  • csharp_win_dynamic_report_formula.zip
  • csharp_win_export.zip
  • csharp_win_exporttopdf.zip
  • csharp_win_multirangeparam.zip
  • csharp_win_oraclelogoninfo.zip
  • csharp_win_paramengine.zip
  • csharp_win_paramviewer.zip
  • csharp_win_pass_dataset_main_sub.zip
  • csharp_win_printtoprinter.zip
  • csharp_win_rangeparameters.zip
  • csharp_win_serverfilereports.zip
  • csharp_win_sortfields.zip
  • csharp_win_sub_daterange_param_engine.zip
  • csharp_win_subreport_basic.zip
  • csharp_win_subreport_logon.zip
  • csharp_win_viewer_events.zip

VB.NET (VB) Windows Sample Applications for use in Microsoft Visual .Net 2002 and Later.
This set includes the following samples:

  • vbnet_win_adodotnet.zip
  • vbnet_win_changefont.zip
  • vbnet_win_classicado.zip
  • vbnet_win_custompapersource.zip
  • vbnet_win_customviewer.zip
  • vbnet_win_dbengine.zip
  • vbnet_win_dbviewer.zip
  • vbnet_win_dynamicimage.zip
  • vbnet_win_dynamic_report_formula.zip
  • vbnet_win_export.zip
  • vbnet_win_exporttopdf.zip
  • vbnet_win_multirangeparam.zip
  • vbnet_win_oraclelogoninfo.zip
  • vbnet_win_paramengine.zip
  • vbnet_win_paramviewer.zip
  • vbnet_win_pass_dataset_main_sub.zip
  • vbnet_win_printtoprinter.zip
  • vbnet_win_rangeparameters.zip
  • vbnet_win_serverfilereports.zip
  • vbnet_win_simplepreviewreport.zip
  • vbnet_win_sortfields.zip
  • vbnet_win_sub_daterange_param_engine.zip
  • vbnet_win_sub_daterange_param_viewer.zip
  • vbnet_win_subreport_basic.zip
  • vbnet_win_subreport_logon.zip
  • vbnet_win_viewer_events.zip

Report Application Server .NET Sample Code
Contains Visual Studio 2005 Web sample code pages that highlight features of the RAS SDK, including report parameter and formula modification, database logon, and exporting.


Viewing

NET-CS2005_CRNET_CR115_Set_Viewer-Locale-by-Page
This sample shows you how to change the multilingual settings for the .NET web form viewer control (CrystalReportViewer) to any locale of your choice. The locale is set via a QueryString variable. The settings are changed on the webform page level instead of using the web.config. Changing the Regional Settings or IE Language Settings will not impact this sample. Note: This has only been tested on Crystal Reports XI R2 with Visual Studio .NET 2005

Crystal Reports .NET C++ - Get Viewer Events
This C++ .NET sample Windows application demonstrates how to access the Viewer Events for the business objects windows forms viewer.

Crystal Reports .NET C++ - View Report
This sample application shows you how to preview a Crystal Report in a .NET C++ application.



Database

Crystal Reports for Delphi 2005 .NET - Connect to Secure Database
This Delphi 2005 sample Windows application demonstrates how to connect to a secured database using the Crystal Reports for Visual Studio .NET Engine object model.

NET-VB2005_CR2008_SET_DB_USING_VIEWER
This sample demonstrates how to view a report by passing the database logon information to the report via the viewer. You can not use this method to change databases at runtime. It must be the database the report is designed against.

NET-CS2005_CRNET_Modify_Logon-Viewer
This sample demonstrates how to modify the userID and password used to log onto the report database using the Crystal Reports .NET Viewer SDK. There is no ReportDocument used in this sample because it is demonstrating how to pass logon info via the Viewer SDK.

NET-CS2005_CRNET_Modify_Database-ConnectionInfo
This sample demonstrates how to modify database server and logon information using the Crystal Reports .NET SDK. The code modifies the ConnectionInfo object and uses the ApplyLogonInfo method to apply the changes to the main and subreports.

NET-CS2005_CR12_SetDatabaseLogon
This sample demonstrates how to view a report by passing the database logon information to the report.  You can not use this method to change databases at runtime.  It must be the database the report is designed against.  This passes the user name and password to connections with a specified server and database name.

NET-CS2005_CR12_SetDatabaseLogon_2
This sample demonstrates how to view a report by passing the database logon information to the report.  You can not use this method to change databases at runtime.  It must be the database the report is designed against.  This passes the user name and password to all database connections in the report.


Parameter

Crystal Reports for Delphi 2005 .NET - Pass Mulitple Parameter Values to the Viewer
This Delphi 2005 .NET sample Windows application demonstrates how to pass multiple values to a single discrete parameter field using the viewer's object model.



Exporting/Printing


Report Modification


NET2003-CS-Web_CRNET_CR115_change_graphic-location
This sample application shows how to change an image in a Crystal Report at runtime using the graphic location formula in the CR .NET SDK (C#).

NET-CS2005_CRNET_CR115_Modify_Image-Location

This sample application shows how to change an image in a Crystal Report at runtime using the graphic location formula in the CR .NET SDK (C#).

NET-CS2003_RAS-Unmanaged_CR115_Modify_Command-Table-SQL
This sample application shows how to retrieve and change the text of a SQL command table from a Crystal Report using the CR .NET SDK and in-process Report Application Server (RAS) Report Creation API (RCAPI). Note that you must have SP2 for Crystal Reports XI R2 for this sample to work. Previously you could access the RAS .NET SDK from the ReportDocument object only if you had a dedicated RAS server. Now you can use RAS in-process to accomplish this.

NET-CPP-Win2005_CRNET_CR115_Change_Record-Selection-Formula
A .NET C++ Windows application that demonstrates how to change a record selection formula at runtime.

Crystal Reports . NET C# - Get SQL Query
This sample application shows how to retrieve the SQL query from a Crystal Report using the CR.NET SDK and RAS in-process. Previously you could only access the RAS .NET SDK from the ReportDocument if you had a dedicated RAS server. Now you can use RAS in-process to accomplish this.

Crystal Reports 2008 .NET C# - Creating Custom Addins
These samples show how to create a Custom Add-In for Crystal Reports 2008. Custom Add-Ins can be used to create custom tools for the Crystal Reports designer. Samples for Visual Studio 2003 and 2005 are both included.


Get Clipmarks - The easiest way to email text, images and videos you find on the web.
Sent with Clipmarks