Page 1 of 1
Make a report with repeating columns
Posted: Thu May 28, 2015 8:38 am
by alex_yar
Is it possible to make a report with a continiously repeating column elements until the end of query data?

- How it should look like
- stimulcolumns.PNG (3.12 KiB) Viewed 2591 times
Consider we've got some sql data from three columns (date, estimated, real) and infinite number of rows.

- SQL Data
- sqldata.PNG (3 KiB) Viewed 2597 times
Re: Make a report with repeating columns
Posted: Thu May 28, 2015 1:19 pm
by HighAley
Hello.
You could try to use
Cross-data component.
Thank you.
Re: Make a report with repeating columns
Posted: Thu May 28, 2015 2:23 pm
by alex_yar
Thank you so much for your answer.
I tried my best but I failed to compose the report according to description on your link.
Is there any way to make it a bit more difficult than I described that before?
I've got an additional SQL data column, named "Cities".

- What it would have become after all
- stimulcolumns1.PNG (6.51 KiB) Viewed 2574 times
Re: Make a report with repeating columns
Posted: Fri May 29, 2015 5:58 am
by HighAley
Hello.
Then it's better to use
Cross-tabs component.
Thank you.
Re: Make a report with repeating columns
Posted: Fri May 29, 2015 7:04 am
by alex_yar
Thanks again, everything now works fine.
Would you tell me one last thing: is there any way to make columns continue on the same page?
Like this:

- stimulcolumns2.PNG (11.77 KiB) Viewed 2568 times
Re: Make a report with repeating columns
Posted: Fri May 29, 2015 12:16 pm
by HighAley
Hello.
Please, try to set the Wrap property to True.
The Cross-tab should be on the Data Band.
Thank you.
Re: Make a report with repeating columns
Posted: Fri May 29, 2015 2:28 pm
by alex_yar
Aleksey Andreyanov wrote:Hello.
Please, try to set the Wrap property to True.
The Cross-tab should be on the Data Band.
Thank you.
Hello, Aleksey Andreyanov.
I can't guess where is the Wrap property you told about.
Would you please attach a screenshot to make things clear for me?
Thanks in advance.
Re: Make a report with repeating columns
Posted: Mon Jun 01, 2015 5:31 am
by HighAley
Hello.
Please, look at the attached image. May be you should switch the property grid to the professional view in the context menu.

- CrossTabWrap.png (11.46 KiB) Viewed 2551 times
Thank you.
Re: Make a report with repeating columns
Posted: Mon Jun 01, 2015 8:40 am
by alex_yar
Hello, Aleksey Andreyanov.
Is it possible to achive the same goal with a cross-data band?
Thanks for your replies.
Re: Make a report with repeating columns
Posted: Mon Jun 01, 2015 1:49 pm
by HighAley
Hello.
There is no such property for Cross-data.
Thank you.