passing parameters to a report project
-
hi everyone, ım using .net and sql server 2005, ı have a report project and this project have parameters.think that like "primary school" and "high school fields". sometimes, ı want to filter outputs with two parameters, and sometimes ı want to filter with just one parameter. thats the time that ı have problems. when ı pass only a parameter, ı want that this report doesnt care with the second parameter. but, it understands it (param1=something_ı_want, param2=null). then it searches for null values in second parameter and as an output, ı have nothing. do you know how can ı fix that problem, how can ı say to this report "dont care with second parameter, ı only ask for first one"? :) thanks for your help, Ali Sapancı
-
hi everyone, ım using .net and sql server 2005, ı have a report project and this project have parameters.think that like "primary school" and "high school fields". sometimes, ı want to filter outputs with two parameters, and sometimes ı want to filter with just one parameter. thats the time that ı have problems. when ı pass only a parameter, ı want that this report doesnt care with the second parameter. but, it understands it (param1=something_ı_want, param2=null). then it searches for null values in second parameter and as an output, ı have nothing. do you know how can ı fix that problem, how can ı say to this report "dont care with second parameter, ı only ask for first one"? :) thanks for your help, Ali Sapancı
i think u r using crystal report,better you pass recordset to the report at runtime. At run time you can frame your SQL as you want and create the recordset and assign that record set to the report. that will be very flexible than using the parameters in report
-
i think u r using crystal report,better you pass recordset to the report at runtime. At run time you can frame your SQL as you want and create the recordset and assign that record set to the report. that will be very flexible than using the parameters in report
it is not my decision, ım in an internship now and that is what they want:)