Crystal Report with dynamic Rows and Columns

Question

I need to write a crystal report that uses data which has both dynamic rows (which is normal) and dynamic columns.

As I understand it, a cross tab will allow me to have dynamic columns but not dynamic columns and rows. How can I drag a column to a report when those columns are dynamic?

I know how to create the SQL query that provides the data and inserts columns in dynamically, the question now is how to present it.

If anyone has done something similar or can give me some pointers, I'd be very grateful.

Many thanks,

Chris.

I think you have misunderstood it - a crosstab should allow you to have dynamic rows and columns. Can you post a representative query that you want to report? — user359040
– user359040, Commented Dec 17, 2011 at 16:16

Ankit · Accepted Answer · 2011-12-17 07:09:41Z

1

Have a look in following Stored Procedure

CREATE PROCEDURE MY_PROCEDURE
@P_QNO INT
AS
BEGIN
IF @P_QNO=1
SELECT FIELD1 AS F1, FIELD2 AS F2,0 AS F3 FROM MYTABLE1
ELSE
SELECT FIELD3 AS F1, FIELD4 AS F2, FIELD5 AS F3 FROM MYTABLE2
END

This procedure will always give you 3 Columns F1,F2,F3 you can easily use them in Crystal Reports. Make sure that every Query returns same number of columns and have same name that will do the Trick. I am using it.

answered Dec 17, 2011 at 7:09

Ankit

6904 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Crystal Report with dynamic Rows and Columns

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related