gfiehler Posted March 19, 2018 Share Posted March 19, 2018 I am calling a stored procedure that returns a table something likeCol header 1Col Header 2Col Header 3row header 1value 1value 2row header 2value 3value 4My report should look like Row Header 1 Row Header 2Col Header 2 value 1 value 3 Col Header 3 value 3 value 4 basically switched rows and columns. the actual data has 30+ columns and 3 rows returned. so I need 30 plus rows and 3 columns in my output.I have put the report fields in the summary section, but all I can access is the first row of data. Is there a way to handle this situation, or does the stored proc need to return the data differently? Thanks for any assistanceGregg Link to comment Share on other sites More sharing options...
mlopez_1 Posted March 20, 2018 Share Posted March 20, 2018 You can put Row Headers as a columns using crosstab, it's very easy but I don't know how to use column as a rows.Mariano Link to comment Share on other sites More sharing options...
henrique.santos1988 Posted March 20, 2018 Share Posted March 20, 2018 on the 'palette' tab you have the 'basic elements', use the crosstab element. when set up correctly it will do what you need. Link to comment Share on other sites More sharing options...
gfiehler Posted March 20, 2018 Author Share Posted March 20, 2018 Thank you for your reponses. I am now working with a Crossbtab but do not understand how this will solve the issue.Working with my table above in the crosstab I set the column group to "Col Header 1" field, This seems to give me my dynamic columns based on Col Header 1 values. But after that I am in the dark. I have no row groups, all columns are equal and there are no calculations, I just need to display the field data horizontally instead of vertically. Please let me know if I am missing something. On another track, I tried to a regular table and use the Horizontal layout, but that made no difference to the report at all.Any help is always greatly appreciated. Gregg Link to comment Share on other sites More sharing options...
mlopez_1 Posted March 21, 2018 Share Posted March 21, 2018 I have some crosstabs with Calculation -> 'No calculation function' for measures, to show some rows as columns. This works perfectly for me.What I told you was that I don't know how to set columns for rows. I think it can't be done.Mariano Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now