I have two questions on controlling the output using Aspose Cells for Reporting Services.
The first item is based on the value from a dataset, I need to set the background color of a cell to a certain value. For example, if the value is a 4 or 5, then the cell is green and if the value is a 1 or 2, the cell is red. Can this be done?
The second item is adding rows programmatically. For example, I need to return text from a stored procedure. Sometimes the text is larger than will fit in a cell. I would like to have the text split over two or three rows so it is all visible to the user. I figure that I could do this in my stored procedure and just return multiple rows for the same header information, but I am hoping to use an existing stored procedure where this is not done. Therefore, I need to take data from a dataset and use a formula to split the text into multiple rows. Can this be done?
This message was posted using Page2Forum from Aspose.Cells for Reporting Services - Documentation