VS 2010 Crystal Report

Question

Hi,

I have a table in ms-sql obm_FeeTable

FeeId int, FranchieId int, Amount Money, ChequeNo int, BankName nvarchar(200), PaymentDate DateTime

when I want to display all collection in crystal report it don't show Amount / PaymentDate when creating report, don't know why its doing like this.

Please help why is it doing like this. also how to use linq with Crystal Report.

Thanks

Answer 1

Have you recently modified the table to add these fields? If so, perhaps Crystal doesn't know about them yet. To fix this, right-click inside the report, select "Database" -> "Log On or Off Server...". OPen The "Current Connections" item and select the one where your table lives. Click the "Log Off" button and then the "Log On" button. This will refresh Crystal's view of the database objects, and you missing fields should appear.

Another possibility is that the login you are using to access the table doesn't have 'select' permission on thos columns.

I don't think linq is applicable to Crystal, but the is a very different question. You should probably post it separately with more detail on what you want to do.