Dynamic Columns in a Reports - HELP NEEDED

All MSRS Mentors,
I need to create a report with dynamic columns, my stored procedure will
return columns based on the parameters I pass.
I have three static columns and n dynamic columns.
My Reports should look like this
ColumnA ColumnB ColumnC DynamicColumnD DynamicColumnE ......
YY RR TT YY YY
TT OO TT YY YY
I am new to RS, please send me the steps to do this, so that I can do it.
Thanks
Balaji
--
Message posted via http://www.sqlmonster.comHi balaji,
im also working on the same problem.....
Do u have any idea in solving this....
"BALAJI KRISHNAN via SQLMonster.com" wrote:
> All MSRS Mentors,
> I need to create a report with dynamic columns, my stored procedure will
> return columns based on the parameters I pass.
> I have three static columns and n dynamic columns.
> My Reports should look like this
> ColumnA ColumnB ColumnC DynamicColumnD DynamicColumnE ......
> YY RR TT YY YY
> TT OO TT YY YY
> I am new to RS, please send me the steps to do this, so that I can do it.
> Thanks
> Balaji
> --
> Message posted via http://www.sqlmonster.com
>|||Unfortunately, I don't think this is possible in this version -- you have to
have all your columns defined up front. Perhaps you can flatten your data
and use a matrix control instead of a table control.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"BALAJI KRISHNAN via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:ee0a6b9e279446d99fa4d3c96e5b443d@.SQLMonster.com...
> All MSRS Mentors,
> I need to create a report with dynamic columns, my stored procedure will
> return columns based on the parameters I pass.
> I have three static columns and n dynamic columns.
> My Reports should look like this
> ColumnA ColumnB ColumnC DynamicColumnD DynamicColumnE ......
> YY RR TT YY YY
> TT OO TT YY YY
> I am new to RS, please send me the steps to do this, so that I can do it.
> Thanks
> Balaji
> --
> Message posted via http://www.sqlmonster.com|||Jeff,
What do you mean my flaten data, could you explain me in detail, so that I
can try that.
Thanks
Balaji
--
Message posted via http://www.sqlmonster.com|||You put the data that goes into different columns into different rows of
your data source, and have a field whose value in each row becomes the
column name (when turned into the matrix column group).
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"BALAJI KRISHNAN via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:ca7d41f91f334d45bf1335f57c878af6@.SQLMonster.com...
> Jeff,
> What do you mean my flaten data, could you explain me in detail, so that I
> can try that.
> Thanks
> Balaji
> --
> Message posted via http://www.sqlmonster.com|||Balaji, You need to use a matrix. Which generates dynamic columns.
However, it only allows one'fixed' column per grouping.
You can get around this by using the Rectangle control.
Create a rectangle OUTSIDE of the data region. Create some textbox
fields inside the rectangle, assign the relevant value to each text box.
Then cut the rectangle and paste it inside the row cell in the matrix.
This would be the structure of your matrix. Its a bit of a fudge but
works (it can be fiddly to get the alignments right).
+--+--+
| | |
+--+--+
|+--+| |
||+--+--+|| |
||| ColA | ColB ||| Dynamic |
||+--+--+|| data |
|+--+| |
+--+--+
If you're unsure about matrix controls, run through the AdventureWorks
samples first before trying this.
Chris
BALAJI KRISHNAN via SQLMonster.com wrote:
> All MSRS Mentors,
> I need to create a report with dynamic columns, my stored procedure
> will return columns based on the parameters I pass.
> I have three static columns and n dynamic columns.
> My Reports should look like this
> ColumnA ColumnB ColumnC DynamicColumnD DynamicColumnE ......
> YY RR TT YY YY
> TT OO TT YY YY
> I am new to RS, please send me the steps to do this, so that I can do
> it.
> Thanks
> Balaji