Hello, I am having trouble doing a particular type of report. I have tried to use the cross tab component, but it makes no sense for this type of report do to the summarized field, I don't need one.

I would like my report to be a grid. The columns of the grid will be a laser.

So my columns would be laser1, laser 2, laser 3 etc.

The rows i would like to be the attributes of my lasers from the database such as : laser position, laser manufacturer, laser type, laser offset, etc.

The values inside of the grid i would like to be the value from the database. So for example for laser 1; laser type, i would like the value in the grid to be the actual type from the database say... 32Khz.

My grid would look something like this:

--------------laser 1------------------------- laser2
Type -------32Khz---------------------------16Khz
Position------1-------------------------------- 2

etc etc.

Does anyone know how to do this in crystal where I have a grid structure like the one above. Any suggestions are welcome and greatly appreciated.

Thanks,
deep.

Hello Deep,

Even i had such situation of creating report. Finally I get ride of it.

I too used Cross-Tab report for by problem. But rahter than connecting the
tables directly, i created a stored procedure and inserted the data to #table
by joining all multiple tables. So i finally sort the data as needed, at the SP
level. Then i reffered this SP in the report and used grouping and dragged proper
those fields as the column headers and also for rows.

Th output of the report was like a matrix, like for this row at this column, it
is mapped and i am showing "X" symbol, where you will be showing the numbers like
1,2,3 ... and Khz.

Its not an eays way to approch. But just give a try by creating SP and check.
hope this helps.

If you already tried using SP what i said, then, try creating a physical table
at runtime by adding "Laser1"... like column names and insert the correct respective data under respective column. Here you have the table ready with proper look at the database level. Now just you have to reffer that table and
place right fields at right place.

According to my knowledge, its not a very easy job. Just give a try, you might
end up with success.

Hope this helps.


With Regards,
Raghavendra Mudugal

Thanks, I thought about creating a seperate table but that sounded outlandish considering i am just showing basic data from my tables.

The stored procedure idea is a good idea, and I will give that a shot. Anybody else have any ideas.

Thanks for taking your time to reply.

deep