Most of you people are already familier with the working of crystal reports unlike me.I am working on an application when I have no other option but to use CR.
It is very diff. for me to read an entire book on CR for a simple report, so I thought if you people can help me :)
Here is the table structure.
I opened the crystal reports in VS 2005 and added the crystal report and using the Database Expert selected the fields I want.
I was worrying about the deployment but I was relieved to find that the connection string gets stored in app.config.
I needed two reports , one with grouping(Based on Ext_Number) (for a summary report) and one without (for a detailed report).
So I added two reports and in one report grouped by Ext_Number and one without.
In both the reports I need to add the where clause
Where Trunk_Number IN ( <param1>,<param 2>,..... ) and Ext_Number IN ( <param1>,<param 2>,..... ) and Called_Number IN ( <param1>,<param 2>,..... and Cost < < > < >> < => )
I dont know how to create the parameters in c# (complete layman).
I guess it would be something like
Reportname.Show ( " comma seperated list of Trunk_Number" , " comma seperated list of Ext_Number" , " comma seperated list of Trunk_Number" , <confused about the less than, greater than and equal to operator >)
I need help about passing parameters in my case.
Looks time consuming but I will be of much help and use for me.
Thanks and regards.
It is very diff. for me to read an entire book on CR for a simple report, so I thought if you people can help me :)
Here is the table structure.
I opened the crystal reports in VS 2005 and added the crystal report and using the Database Expert selected the fields I want.
I was worrying about the deployment but I was relieved to find that the connection string gets stored in app.config.
I needed two reports , one with grouping(Based on Ext_Number) (for a summary report) and one without (for a detailed report).
So I added two reports and in one report grouped by Ext_Number and one without.
In both the reports I need to add the where clause
Where Trunk_Number IN ( <param1>,<param 2>,..... ) and Ext_Number IN ( <param1>,<param 2>,..... ) and Called_Number IN ( <param1>,<param 2>,..... and Cost < < > < >> < => )
I dont know how to create the parameters in c# (complete layman).
I guess it would be something like
Reportname.Show ( " comma seperated list of Trunk_Number" , " comma seperated list of Ext_Number" , " comma seperated list of Trunk_Number" , <confused about the less than, greater than and equal to operator >)
I need help about passing parameters in my case.
Looks time consuming but I will be of much help and use for me.
Thanks and regards.