|
Mail Labels -- priya acharya --
Hi,Friends I am trying to make Report of Mail Labels using Crystal Reports. I can make it for fixed no. of parameters but, i want it to display dynamic parameters passed by user. Please Help me. It is urgent. Thanks. Priya... |
|
-- Vivekananda --
hi priya, Can you explain ur question more clear?? Regards, Vivek On 7/10/06, priya acharya <priyaach> wrote: Hi,Friends I am trying to make Report of Mail Labels using Crystal Reports. I can make it for fixed no. of parameters but, i want it to display dynamic parameters passed by user. Please Help me. It is urgent. Thanks. Priya... > |
|
-- priyaacharya --
Hi, Vivek Thanks For Reply. Actually, I want to Display Mail Labels Report. In that Label, user can choose 2 fields,or 4 fields..means dynamic. that fields i m passing to my stored procedure.. and then i m going to make Mail Label Report. It displays proper in Crystal Reports. But,when i m display it by viewer, it displays only first letter of all fields. Can u help me?? If still not understood plz tell me.. Thanks... Priya....... On 7/12/06, Vivek ananda <vivek.triad> wrote: hi priya, Can you explain ur question more clear?? Regards, Vivek On 7/10/06, priya acharya <priyaach> wrote: > Hi,Friends > I am trying to make Report of Mail Labels using Crystal Reports. > I can make it for fixed no. of parameters but, i want it to display > dynamic parameters passed by user. > Please Help me. It is urgent. > Thanks. > Priya... > > > > > > > > |
|
-- vivek --
hi Priya, Check whether ur SP gives all the fields(values) correctly.... you can try by giving "Can Grow" option true for that field. Regards, Vivek priya acharya <priyaach> wrote: Hi, Vivek Thanks For Reply. Actually, I want to Display Mail Labels Report. In that Label, user can choose 2 fields,or 4 fields..means dynamic. that fields i m passing to my stored procedure.. and then i m going to make Mail Label Report. It displays proper in Crystal Reports. But,when i m display it by viewer, it displays only first letter of all fields. Can u help me?? If still not understood plz tell me.. Thanks... Priya....... On 7/12/06, Vivek ananda <vivek.triad> wrote: hi priya, Can you explain ur question more clear?? Regards, Vivek On 7/10/06, priya acharya < priyaach> wrote: Hi,Friends I am trying to make Report of Mail Labels using Crystal Reports. I can make it for fixed no. of parameters but, i want it to display dynamic parameters passed by user. Please Help me. It is urgent. Thanks. Priya... --------------------------------- Do you Yahoo!? Get on board. You're invited to try the new Yahoo! Mail Beta. |
|
-- priyaacharya --
Hi,Vivek I told u my SP gives me proper result and also in Crystal Reports 9, i m getting proper result. But,when i m trying to display it through crystal viewer i don't get proper result. Here is my SP. CREATE PROCEDURE RPT_ITEM_LABELS_TRIAL @FIELD1 CHAR(100), @FIELD2 CHAR(100), @FIELD3 CHAR(100), @FIELD4 CHAR(100), @FIELD5 CHAR(100), @FIELD6 CHAR(100), @FIELD7 CHAR(100), AS EXEC('SELECT '+ @FIELD1 +' AS ,'+ @FIELD3 +' AS ,'+ @FIELD6 +' AS FROM ') here, i m passing fields' name dynamically. Thanks.. Priya... On 7/12/06, vivek <vivek_pv27> wrote: hi Priya, Check whether ur SP gives all the fields(values) correctly.... you can try by giving "Can Grow" option true for that field. Regards, Vivek *priya acharya <priyaach>* wrote: Hi, Vivek Thanks For Reply. Actually, I want to Display Mail Labels Report. In that Label, user can choose 2 fields,or 4 fields..means dynamic. that fields i m passing to my stored procedure.. and then i m going to make Mail Label Report. It displays proper in Crystal Reports. But,when i m display it by viewer, it displays only first letter of all fields. Can u help me?? If still not understood plz tell me.. Thanks... Priya....... On 7/12/06, Vivek ananda <vivek.triad> wrote: > hi priya, > > > Can you explain ur question more clear?? > > Regards, > Vivek > > > On 7/10/06, priya acharya < priyaach> wrote: > > > Hi,Friends > I am trying to make Report of Mail Labels using Crystal Reports. > I can make it for fixed no. of parameters but, i want it to display > dynamic parameters passed by user. > Please Help me. It is urgent. > Thanks. > Priya... > > > > > ------------------------------ > Do you Yahoo!? > Get on board. You're invited< http://us.rd.yahoo.com/evt=40791 >to try the new Yahoo! Mail Beta.> > > > > |
|
-- vivek --
hi priya, 1. Check whether field name in sp and field name in dataset are same. 2. Check whether you hav given "Can grow" option enabled...for each field in the crystal report. Regards, Vivek. --------------------------------- Do you Yahoo!? Get on board. You're invited to try the new Yahoo! Mail Beta. |
|
-- priyaacharya --
HI,Vivek Yes, My database Fields' name and SP parameters are same, and also i have given can grow option to each field. You can try out for any table. Thanks.. Priya.. On 7/12/06, vivek <vivek_pv27> wrote: hi priya, 1. Check whether field name in sp and field name in dataset are same. 2. Check whether you hav given "Can grow" option enabled...for each field in the crystal report. Regards, Vivek. ------------------------------ Do you Yahoo!? Get on board. You're invited< http://us.rd.yahoo.com/evt=40791 >to try the new Yahoo! Mail Beta.> |
|
-- sandeepspawar --
hi priya, i have seen your query all the field are dynamic. all the field data type also may be different, if i am not wrong? now when you are designing your mail lables are u using the textbox of crystal report and assinging the values from the formulas ? regards, Sandeep Pawar |
|
-- priyaacharya --
Hi, Sandeep My query fields' datatypes are same. I m passing fields from my windows form to crystal report.I haven't use any formula in Report. I tried by formula but it doesn't work. Thanks.. Priya.. On 7/14/06, sandeep.s.pawar <sandeep.s.pawar> wrote: hi priya, i have seen your query all the field are dynamic. all the field data type also may be different, if i am not wrong? now when you are designing your mail lables are u using the textbox of crystal report and assinging the values from the formulas ? regards, Sandeep Pawar > |