Hi ,
I am trying to create a custom report inorder to track the subscription sales by attribute.
I have succesfully created the stored procedure ,infomaker object and Report server object.But when I try to run the report eveything works fine expect the attribute value.
Instead of displaying the attribute value system is displaying some random numbers.
I have done the entire process over and over again.I see that the values returned from the stored procedure are accurate.
Parameters: Attribute(t_keycode) Attribute_value (t_kwcoded_values) order start date and order end date.
I guess I will not be able to debug this.Kindly let me know if you have any suggestions.
I don't exactly know the reason but I am able to see the attribute value after I regenerated the infomaker object.
Hi Revanth,
Good day.
I think you should check the data type of "attribute_value" field .
you can use something like:
CAST((ltrim(rtrim(isnull(attribute_value,'')))) AS varchar(20))as attribute_value
to replace the attribute_value field.
have fun
Ben