Crystal Reports crystal report 2005

Talk with the Author
Crystal Reports Forum : General Information : Talk with the Author

Topic: crystal report 2005

Author	Message
hosam Newbie Joined: 20 May 2007 Location: Egypt Online Status: Offline Posts: 3	Topic: crystal report 2005 Posted: 24 May 2007 at 2:31am
	hi how r u i've a great problem that can't be solved until now by crystal report i'm creating a control program for exam results the table of the result is created dynamically by code the table name i don't know ex the table created like this courseResult_facName_deptName_Year so i don't know the facName , deptName anf year so i can not specify a table source for the dataset i hope you understand me 2- the colmns in this dynamic table that generated by code i don't know too i hope u understand me i want u to solve me this problem
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3702	Posted: 24 May 2007 at 10:58am
	The table name issue can be handled fairly in code. However, if the columns are not "standard" (e.g., always the same) there's no way that I know of to actually dynamically create the report in code based on the structure of the table you're given at run time. -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

hosam Newbie Joined: 20 May 2007 Location: Egypt Online Status: Offline Posts: 3	Posted: 26 May 2007 at 10:27pm
	thnx the table name i solve it by still the colmn names which i don't know still cann't be solved is there any way to get from dataView c# 2005 to crystal report directly
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3702	Posted: 28 May 2007 at 11:54am
	The only way I know of only works if you know what your columns are whey you're designing the report. I don't know of any reasonable way to design the report "on the fly" with a dynamic data source. One way I've gotten around this in the past is to set up a generic dataset in an appliction. There are two tables with the following structures: Report_Headers Column1_Header string Column2_Header string ... ColumnN_Header string Report_Data Column1 string Column2 string Column3 string ... ColumnN string Where N is the maximumn number of columns you'll ever display on the report. All data is converted to a string format and places in the Report_Data table in the order in which it will be displayed on the report. The corresponding column headers are placed in the Report_Header table. Columns are left empty if there is no data. You then design a report around this dataset. However, I'm not sure that this method would work for you because your data is actually generated by code that you don't know and may not have access to. -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.047 seconds.