>>>I created a report in CR using VS2010. I had to download CR from SAP and get past a myriad of errors. I finally got the report to run.
>>>
>>>Then I copied the app to my client's PC and ran it, and the report prompts me for DB login info. I check the Use Integrated Security checkbox, click Finish, and get
>>>
>>>

>>>---------------------------
>>>Crystal Report Windows Forms Viewer
>>>---------------------------
>>>Failed to retrieve data from the database.
>>>Details:  [Database Vendor Code: 18456 ]
>>>Failed to retrieve data from the database.
>>>Error in File temp_b8bc73a2-fa84-4548-9c7a-681b52ce4d63 {CAD5A22F-51E7-49C7-8C39-0E260E6DED7F}.rpt:
>>>Failed to retrieve data from the database.
>>>Details:  [Database Vendor Code: 18456 ]
>>>---------------------------
>>>OK   
>>>---------------------------
>>>

>>>
>>>The app uses trusted connection and I'm having no problems getting into SQL for the apps data. It's jjust Crystal that won't cooperate. I checked the SQL logs and found:
>>>
>>>

>>>2011-03-16 20:16:19.76 Logon       Error: 18456, Severity: 14, State: 5.
>>>2011-03-16 20:16:19.76 Logon       Login failed for user 'Kevin'. [CLIENT: 192.168.1.191]
>>>

>>>
>>>The 'Kevin' user name is my dev machine login name. My remote user name at the client site is 'kmarois', so the report isn't getting its login info.
>>>
>>>Anyone know how to fix this?
>>>
>>>
>>>
>>>Finally, I have really had it with Crystal Reports. I had always thought that CR was decent product. The MS got ahold of it, and now gave it over to SAP. For YEARS I have been struggling with the same issues, and other programmers at work all say the same thing - when you get it working, it's great. Until then, your screwed. I am going with SSRS from now on.
>>>
>>>Good ridence CR.
>>
>>Did MS ever have ahold of it? Not to my knowledge, but I'm no expert. I thought it went from Seagate to Crystal Decisions to Business Objects to SAP.
>
>
>Ya, you're right. I'm just pissed off.
>
>Any idea on how to get the report to use the correct connection info?

I've never chosen to do it that way. I always set up the data for the report and set the report's datasource before I run the report....(for both SSRS and for Crystal back when i was testing it)

Very very basic example is here:
http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-sql-query.htm

that site has a good basic tutorial:
http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-tutorial.htm