Help regarding crystal reports
-
Hi , i am able to create static crystal reports , but i want to create reports based on user input. I have to provide UI to select between two dates and some other options . i want to get data from databse (sql 2005) based on these query ... can any one suggest me how can i do : this (samples or Links ) Thanks csn.
-
Hi , i am able to create static crystal reports , but i want to create reports based on user input. I have to provide UI to select between two dates and some other options . i want to get data from databse (sql 2005) based on these query ... can any one suggest me how can i do : this (samples or Links ) Thanks csn.
That thing will depend upon the version of Crystal Report you are using. In Crystal report 11, the method is, go to "Field Explorer". you have the option "Parameter Fields". Create a new parameter with datatype date time. for eg. "Startdate" & "EndDate". Now go to menu Report --> Select Expert. It will ask you to select the field. Assuming that the field you have to use is "DateofBirth", select this field. Now a window will open & it will ask you for selecting a option, as for date, you will select "is between", then it will ask you the two values. Select the parameter field you have created earlier & click ok its done. Now see the preview it will ask you for input parameters. Good luck :)
-
Hi , i am able to create static crystal reports , but i want to create reports based on user input. I have to provide UI to select between two dates and some other options . i want to get data from databse (sql 2005) based on these query ... can any one suggest me how can i do : this (samples or Links ) Thanks csn.
You need to create parameters in crystal report. Google Push and Pull method in ASP.NET with Crystal Report. Cheers Anoop
-
That thing will depend upon the version of Crystal Report you are using. In Crystal report 11, the method is, go to "Field Explorer". you have the option "Parameter Fields". Create a new parameter with datatype date time. for eg. "Startdate" & "EndDate". Now go to menu Report --> Select Expert. It will ask you to select the field. Assuming that the field you have to use is "DateofBirth", select this field. Now a window will open & it will ask you for selecting a option, as for date, you will select "is between", then it will ask you the two values. Select the parameter field you have created earlier & click ok its done. Now see the preview it will ask you for input parameters. Good luck :)