Reports
-
Okay.. Here is my question! I want to generate reports using crystal report or any other reporting feature that works in visual studio 2005 (using C-sharp). now the trick is, i want the user to be able to define what they would like in their report(without them actually writing the sql behind the report). for example lets say they they wanted to see a list of people with names starting with "G" according to how much they earned.. it should be able to do this. the user should just select options on the "form" and a report be generated.. thanks. :-\
-
Okay.. Here is my question! I want to generate reports using crystal report or any other reporting feature that works in visual studio 2005 (using C-sharp). now the trick is, i want the user to be able to define what they would like in their report(without them actually writing the sql behind the report). for example lets say they they wanted to see a list of people with names starting with "G" according to how much they earned.. it should be able to do this. the user should just select options on the "form" and a report be generated.. thanks. :-\
-
For this you need to pass parameters to your store procedure based on the users choice. And then based on that build your crystal report.
Ahsan Ullah Senior Software Engineer
hey.. ive created reports before but ive never had to pass parameter in a report.. can more than one parameter be passed? if its not too much to ask for you could you please just explain to me how to do this. Thanks. (sent the exact msg to your email, wasnt sure if you'd get it or not)
-
hey.. ive created reports before but ive never had to pass parameter in a report.. can more than one parameter be passed? if its not too much to ask for you could you please just explain to me how to do this. Thanks. (sent the exact msg to your email, wasnt sure if you'd get it or not)
-
I am not asking you to pass parameter to report. I am asking to pass parameter to your query or storeprocedure which gives you the selected records based on the parameters.
Ahsan Ullah Senior Software Engineer
After defining and opening your connection and creating your data adapter..
yourCommand.CommandType = CommandType.StoredProcedure; yourCommand.CommandText = "YourStoredProcedureName(ParameterValue1,ParameterValue2)"; yourCommand.ExecuteNonQuery();
All generalizations are wrong, including this one! (\ /) (O.o) (><)
-
Okay.. Here is my question! I want to generate reports using crystal report or any other reporting feature that works in visual studio 2005 (using C-sharp). now the trick is, i want the user to be able to define what they would like in their report(without them actually writing the sql behind the report). for example lets say they they wanted to see a list of people with names starting with "G" according to how much they earned.. it should be able to do this. the user should just select options on the "form" and a report be generated.. thanks. :-\
Do you mean, the users are able to really define what they like to see in the report, or, do you mean, the users have pre-defined options to choose how to filter the data?? For the first case, many developers has been asked the same thing, and the answer is no, the user, unless they know how to use the report generation tool such as Crystal Report or SQL Reporting Service, and know the system, they can't "freely" generate any report that they like. For second case, you can pass value by parameters and have the report filter by these parameters, or in Crystal Report case, you can add the selection criteria to SelectionFormula that is formed by the user interface.