Karim
|
| Posted: 05/31/2002, 1:11 PM |
|
How would you construct a CrossTab Report using CCS?
Thanks
|
|
|
 |
Brent
|
| Posted: 05/31/2002, 2:18 PM |
|
Any particular language or database?
CCS does not have a reporting feature so you need to roll your own crosstabs
using SQL and perhaps Group By statements. It may take several iterations to
build up all the columns. It all depends how complicated your crosstab is.
Then you can store the results in a table and have CCS display the table in a
grid.
You can do a google search http://www.google.ca/search?hl=en&safe=off&q=sql+crosstab+tutorial&meta=
and it will give you several ways to do it using SQL.
Brent
|
|
|
|
Karim
|
| Posted: 06/03/2002, 11:21 AM |
|
Since crosstabs are build dynamicly, means the number of rows will change depending on the inputs, how can you construct a grid using CCS when you don't know the names of the fields?
Thanks
|
|
|
|
Brent
|
| Posted: 06/03/2002, 1:17 PM |
|
Karim,
>>Since crosstabs are build dynamicly, means the number of rows will change depending on the
>>inputs, how can you construct a grid using CCS when you don't know the names of the fields?
You've raised a good point (actually it is the variable # of columns that causes
the problem not the rows). It looks like you will have to construct an html table
after the query has finished and avoid using the CCS grid entirely. It doesn't appear
that CCS will help you to display the results at all.  You could "borrow" the
look of a CCS grid and use their style sheet when you build your HTML grid. Building
and HTML table using code isn't all that hard.
If you wanted to get fancy, you could put hotlinks on each row title, col title,
and cell so when the user presses on it, it opens another browser window showing
the raw data that went into this row/column,cell. This gives it a "drill down"
effect. You just pass the row title/col title to the 2nd window and it builds the
query based on those values and displays the raw data in a CCS grid.
Brent
|
|
|
|
Karim
|
| Posted: 06/04/2002, 7:09 AM |
|
Thanks a mill, I was hoping for a CCS fix. I can use getrows and loop throught the col to build an HTML table dynamicly.
Need to figure out how to use CCS gird code and SS.
How about XML? Anyone know how I might build an XML output of a CrossTab?
Thanks again.
|
|
|
|
mcurry
|
| Posted: 06/04/2002, 8:04 AM |
|
XML? For a cross-tab report? What would be the point? XML is for frequent re-use -- otherwise the overhead isn't worth it.
Crystal Decisions (Crystal Reports) has some reasonably good HTML reporting capability that can be called via CGI or other server interface. It takes awhile to get comfortable with Crystal, but it can sure make life easy when it comes to reports.
|
|
|
|
|
