oamador Posted June 2, 2008 Share Posted June 2, 2008 I need some help with a crosstab. My data is in rows in database, I need to print a report where the data shows in columns based on the year. The crosstab is set in the summary of the report. The reports shows multiple columns based on the year in the data. The rows are based in two column of the database. One column in the database is used on the first column of the crosstab, the other column is printed on every column based on the year. My first question is that the crosstab will only print the row once. I have duplicates in the column used for the row group in the crosstab. Is it possible to hav the row groups to print one row for every value in that column? So the report could look like Year1 Year2 Year3Item1 desc desc desc Item1 desc desc desc Item1 desc desc desc Item2 desc desc desc If the table is clear, then item1 is repeated and display multiple times and the description is display on ever year column. The other question is how to set the crosstab to the detail section of the report. I copy the crosstab and the report runs, but it print like 150 pages, instead of the few required by the crosstab. Can one prevent the multiple crosstabs from displaying in the detail section? I'll appreciate any pointer/suggestion about crosstabs. Link to comment Share on other sites More sharing options...
ktalarico Posted January 27, 2010 Share Posted January 27, 2010 Did you ever find a solution to your problem? Karen Link to comment Share on other sites More sharing options...
erosszz_jp Posted January 28, 2010 Share Posted January 28, 2010 >Can one prevent the multiple crosstabs from displaying in the detail section?you may insert the crosstab report as subreport of a master report's detail section. 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