Crystal Reports XI and Sql Server

Hello everyone,
I am new to crystal reports. Ive been through some of the sample reports and have been learning. All of the samples use the Extreme Database that comes with Crystal Reports. Now I want to practice connecting to my SQL Server database but I havnt been able to figure that out. In the database expert there is every possible database type from MS Access to Oracle, DB2, Informix, Sybase.whatever, but there is no way I have found to connect to an SQL Server directly. The only way I have been able to connect is by creating a DSN for my SQL Server Database and connecting via DSN. Even though I have set my DSN to use integrated security, Im still prompted to enter a user name and password when I refresh the report. The report initially opens without prompting for user name and password.

Has SQL Server been completely left out of the loop in Crystal Reports? Can anyone let me know how to connect to SQL Server directly?

Thanks
GEMCreating the DSN is the way to go. I started by adding an ODBC connection, and adding a system connection, CR will prompt you for a password unless you embed it into the report. (If you embed the password, others with CR may be able to see it) I created a ODBC DSN on my computer, and a matching one (Name Case must match) on my SQL box. ivr_report is the DSN name in this case. Then, open CR, add a ODBC (RDO) connection, select your DSN from the list, (In this case ivr_report), once you have the connection, you can select your tables or views. Hope this helps.sql

Crystal Reports

Sample Code:

-----------------------
g_m_cnnRAM.BeginTrans
ChangeClosingStock // The Function Which Holds Views

crReports.SQLQueryString = Select LotNo, Variety, Cl_Kgs, Value from ClosingStockView

frmViewer.Show
frmViewer.CRViewer1.ReportSource = crReports
g_m_cnnRAM.CommitTrans
frmViewer.CRViewer1.ViewReport
frmViewer.CRViewer1.Zoom (1)

------------------------

The Above is the Sample Code. After the CommitTrans, the ViewReport is Called. At this time if ClosingStockView is Altered, I Get the Someother Modified Data instead of my Data. If I give CommitTrans After ViewReport the System gets Hung.

Find me a solution for this.

Ashok.SSend me the code so that I can check

Crystal Report Summary

Sir,

I am trying to work on the Xtreme Sample database provided with Crystal. Let me explain what I am trying to achieve.

I am trying to populate the list of customers (for bicycle parts) grouped by customer name and then by Order Id. My selection criteria are the country needs to be USA, the orders placed must be in the year 2001 and the "Customer total" (the total price for given customer) should exceed $40,000.

The "Customer total" is of course the summary of line total(which is the product of price of each unit and quantity ordered) for each customer group. I also have a "grand total" (summary) for the report footer which will give me the total amount for all customers.

The problem im facing is that when I apply the first two conditions using the 'Select Expert', ie the country being USA and order placed for year 2001, the "grand total" I get makes sense.

But when I apply the third condition, (which is the group total for customers need to be greater than 40000), the preview shows me the customers whose totals are greater than $40,000 but my "grand total" remains the same (as when I applied the first two selection criteria).

I wish to know if the group totals cannot be used in the select expert while taking summaries. And is there a way to overcome it and achieve my requirement, i.e., to get my grand total only for customers whose group totals are greater than $40,000.

Thanking you in advance for your help.

SeshuIf you want your troubles go away use SimulReport.Net. It is the best solution in this sphere.

Crystal Report Certification

Crystal Certification Sample Papers needed
Any URL will help.
Thanks in AdvanceThis will provide more detail on the Certification.

http://www.businessobjects.com/services/training/certification.asp

Personally, I don't believe in sample Tests and such; the reason being that at the end of the day, knowing ONLY what a person should know in order to pass the exam, doesn't mean much, afterall, it's a certification, and certificates must be earned, because they donn't just get handed out for no reason :)|||Thanks for your Reply
I Agree with your Opinion.
Regards
Raheem

Crystal Report - C#

Hi, everyone
I'm looking for sample codes in C#, using Crystal Report 10 and connecting to database ORACLE (not Access or SQL Server!)
Any help is appreciated,
thank youJust a link to the samples is fine... I'm really in trouble!|||I could find a way to use CrystalReportViewer, but everytime you click something it must refresh the page. I can't use it because it's too slow. I can't believe that actually someone use it...

In classic ASP I can use ActiveX Viewer and it's PERFECT. How can I use it in .NET?|||Hi,
i am using CR 10 and Oracle, but I don't have a direct connection from CR to Oracle. What I am using is a strongly typed dataset, which I link to the reportsource.
Maybe this helps.|||Hi,
i am using CR 10 and Oracle, but I don't have a direct connection from CR to Oracle. What I am using is a strongly typed dataset, which I link to the reportsource.
Maybe this helps.

Hi Reinhold,
I'm using CR 10 and Oracle, too.

As far as I'm a newbie in .NET, can you post me a sample code that explain your solution?
Because that CrystalReportViewer object is useless with that "refresh" problem.

Thanks in advance