Anyone know how I can generate a list of numbers eg. 1 to 100 that I can use in report.
I could create a custom or temp table with a numeric field with a values 1 to 100 but rather use something thats completely internal to the report. I envision this could be accomplished with Crystal version 9's SQL command object.
Anyone know how this could be done. Snippet of code?
Select 1 as Index_Value
Union
Select 2 as Index_Value
.
.
Union
Select 100 as Index_Value
will do this, but I'm looking for something a bit more elegant eg. using some kind of control loop.
Anyone know something that will work in the SQL command object of Crystal 9?
Thanks,
I could create a custom or temp table with a numeric field with a values 1 to 100 but rather use something thats completely internal to the report. I envision this could be accomplished with Crystal version 9's SQL command object.
Anyone know how this could be done. Snippet of code?
Select 1 as Index_Value
Union
Select 2 as Index_Value
.
.
Union
Select 100 as Index_Value
will do this, but I'm looking for something a bit more elegant eg. using some kind of control loop.
Anyone know something that will work in the SQL command object of Crystal 9?
Thanks,