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
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
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
Aleksey Andreyanov wrote:Hello.

You could try to use Cross-data component.

Thank you.
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
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
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
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.