RSBLaird71
Programmer
- Apr 20, 2010
- 4
This is a weird one y'all and I need all the help I can get to figure it out. I'm at my wits end!
I'm working with SQL Reporting Services 2008
I have a detail report based on a stored procedure that is created from Derived Tables in the new server. These tables have been formed from the original tables on another database
Here's a basic example I know it's confusing, so I hope I can explain this right:
Elements of "dbo.Line_table" & "dbo.Event_Fab" on the "Asset" database are combined to form the "dbo.LineFab" table on the "DerivedAsset" database
The columns are given Aliases for this new table. My report stored procedure references only the Column Alias of the new derived table.
BUT -- The boss wants the user to be able to see what the original field name and table that it originally came from.
Now, I created a clever way to force those orginal table names and column names to a table that gets truncated and repopulated every time one of these reports run...no problem. Now the problem comes when I am trying to tie these elements together in the Report itself. What he REALLY wants is a floating tool tip that will appear over the column header (current column alias) with the ORIGINAL TableName.ColumnName
Crazy I know...but I've gotten pretty darn close...
Like I said, I have a table populated with the ColumnAlias, ColumnName, TableName. I made a dataset within the report that is pulling this information in. And have even made a "pivottable" of sorts with a Matrix element in RS...lined it up with the tablix I am trying to match to. But this option is just not possible, because the columns widths will not match and of course cannot dynamically change to match the main dataset tablix.
And the orignal easiest way is impossible, because RS will not let me make a tool tip from any element in any other dataset besides the one it's on.
If anyone can actually understand this, or can begin to grasp my problem or a possible solution...I BEG you to holler back at me. I am not great at exlaining in "writing"...especially when it's this complex of a subject.
Any help is SOOOO appreicated.
Thank you,
RSBLaird71
I'm working with SQL Reporting Services 2008
I have a detail report based on a stored procedure that is created from Derived Tables in the new server. These tables have been formed from the original tables on another database
Here's a basic example I know it's confusing, so I hope I can explain this right:
Elements of "dbo.Line_table" & "dbo.Event_Fab" on the "Asset" database are combined to form the "dbo.LineFab" table on the "DerivedAsset" database
The columns are given Aliases for this new table. My report stored procedure references only the Column Alias of the new derived table.
BUT -- The boss wants the user to be able to see what the original field name and table that it originally came from.
Now, I created a clever way to force those orginal table names and column names to a table that gets truncated and repopulated every time one of these reports run...no problem. Now the problem comes when I am trying to tie these elements together in the Report itself. What he REALLY wants is a floating tool tip that will appear over the column header (current column alias) with the ORIGINAL TableName.ColumnName
Crazy I know...but I've gotten pretty darn close...
Like I said, I have a table populated with the ColumnAlias, ColumnName, TableName. I made a dataset within the report that is pulling this information in. And have even made a "pivottable" of sorts with a Matrix element in RS...lined it up with the tablix I am trying to match to. But this option is just not possible, because the columns widths will not match and of course cannot dynamically change to match the main dataset tablix.
And the orignal easiest way is impossible, because RS will not let me make a tool tip from any element in any other dataset besides the one it's on.
If anyone can actually understand this, or can begin to grasp my problem or a possible solution...I BEG you to holler back at me. I am not great at exlaining in "writing"...especially when it's this complex of a subject.
Any help is SOOOO appreicated.
Thank you,
RSBLaird71