Click here to Skip to main content
15,666,844 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I want to design a crystal report using 'Cross Tab'. I am writing query for that, in that query i am taking Fields which i want to display in cross tab report.
but, my problem is...when i am taking query from SQL Server to visual studio -->.rpt file(i.e.crystal report file)--> Field Explorer --> command--> in this I am paste the query. that time all column names are display which i want to show in report.but when i am taking 'cross tab Expert' that time in the available field option all column names are not display.
how can i show all column name in the cross tab expert which are present in Field Explorer--> Database Field-->Command ?

I want to design the Muster of Employee.
which have different columns related employee details.which comes from different table from SQL Server.

plz.give solution on this?
Thank u in advance....
RaviRanjanKr 11-Dec-11 3:41am    
A suggestion :- Never use short textspeak words like u instead of 'YOU' and plz instead of 'Please'. try to avoid it. :)

Verify the datasource in your report & try again, that's all. Just make sure all the fields are in dataset in your report.

Creating a Crosstab Report in Visual Studio 2005 Using Crystal Reports[^]
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900