September 24, 2008 at 1:23 pm
Our company is moving away from Cognos Impromptu and replacing it with SQL Server Solutions. I am trying to develop a report that imitates a feature in Impromptu where it can list a detail item more than once in a column where that column changed but the rest of the columns remained the same. Example. We create a trouble ticket report with a ticket number. There are entries for the ticket number, problem description, solution, and assignment. The report will not change for ticket number, problem description, and solution, but the assignment will. I don't want a new line for every detail. I only want a additional lines inside of the report column assignment when it gets re-assigned. Can this be accomplished?
September 29, 2008 at 2:47 pm
I wanted let everyone know I found a solution to my problem. First, I probably mistitled the topic. SQL Server 2005 Reporting Services allows you to 'Hide Duplicates' in the TextBox properties box. I just clicked a check mark there on each field and associated it with the containing dataset and the duplicate information disappeared. Only the field that was different appeared on the next line.
September 30, 2008 at 7:01 am
I'm not sure, but I think you might be able to achieve this in SSRS 2008, if you have the option of installing SSRS 2008.
September 30, 2008 at 9:07 am
Thanks. I do have an evaluation copy of SQL SERVER 2008. I will take a second look at that.
My solution is not ideal because I would prefer the row added for a non-duplicate be combined in the column and divided by line instead of a separate row. That would have more eye appeal and take up less real estate.
September 30, 2008 at 2:03 pm
RS 2008 is even better because it expands on grouping and does exactly what I would expect.
Thanks!
September 30, 2008 at 2:05 pm
No problem. Glad it worked.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply