Skip to main content
T
The Madness
Participant
April 11, 2013
Question

Crosstab in CF Report Builder 8

  • April 11, 2013
  • 1 reply
  • 1058 views

I know this has been asked before but I can't seem to find anything current.  I came across some stuff but the links were diead or explanatory images didn't show.

It seems that Report Builder doesn't do crosstabs.  I wondered if anyone had come across any kind of workaround.  What I would like to show is something like:

Books Circulated

                              Jan          Feb          Mar          Apr...                                        Year Total

Red Books          100          200          300          400

Blue Books          300          100          200          200

Total                    400          300          500          600

Seems like it should be doable.  I usually us a crosstab and it is relatively straightforward.  Any suggestions in Reprot Builder?  Thanks.

This topic has been closed for replies.

1 reply

EddieLotter
EddieLotter
Inspiring
October 3, 2013

The Madness wrote:

Seems like it should be doable.  I usually us a crosstab and it is relatively straightforward.  Any suggestions in Reprot Builder?  Thanks.

A report will accept whatever data-set you provide it.

The trick is to do the crosstab using your database engine. The result-set returned by the database engine can easily be used to create a report.

It is worth noting that Report Builder is for creating fixed layout reports. It is not possible to have a dynamic number of fields generated at run-time. You have to explicitly place each field in the report.

What this means is that your cross-tab query must always return the same number of fields, or at a minimum it needs to return the fields that appear in the report.

If you have more questions feel free to ask.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices