i have doubt about how to show the text box value into the crystal report..
in my project i need to show the log in name in the crystal report.. i had created the parameters and assigned the discrete values but when am executing the application discrete value wizard will be appear on the screen.. please help me how to solve this problem and how to show the text box value into the crystal report.. am added the following code
paramField = new ParameterField(); // <-- This line is added
paramDiscreteValue = new ParameterDiscreteValue(); // <-- This line is added
paramField.Name = "uname";
paramDiscreteValue.Value = uname;<-- this is loginname
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
Iftikar HussainPosted Jul 15, 2013, 2:51 AM
your existing query
select empid,empname,salary from Employee
now you can combine like this
declare @username varchar(10)
set @username=username from UserInfor where userId=@userId
the final query will be
select @username as username,empid,empname,salary from Employee
the above need to modify in SP level
Regards,
Iftikar
Suresh BabuPosted Jul 15, 2013, 2:24 AM
if suppose the username is not available in crystal report.. Actually my intention is i want to display the value in crystal report what ever data i entered in text box..
If the data is not available in database then how to show the text box value in crystal report;
please help me..
Iftikar HussainPosted Jul 14, 2013, 1:28 AM
The simple way you can do this by returning the user name from your sql query itself. You can pass user id as input parameter to your crystal report and sql query and display the output column in text value.
Regards,
Iftikar