G
Guest
I have a datagrid that outputs sales data like this:
Customer Month Sales
Acme Corp Jan 1,345
Acme Corp Feb 2,567
I'm trying to make it look like this:
Customer Jan Feb
Acme Corp 1,345 2,567
I just started using template columns and was going to try to pull data from
the same place but put a filter on each template column for each month.
Something like DataGrid runat=server id=dgDetails DataSource='<%#
GetDetails(container.dataitem("AccountID"))%>' WHERE Month = Jan
That doesn't seem to work. I dont' know how to get the WHERE clause in there.
The other option I guess would be to put a several prefiltered nested
datagrids into the datagrid?
Would love someone to set me straight. Thanks.
Customer Month Sales
Acme Corp Jan 1,345
Acme Corp Feb 2,567
I'm trying to make it look like this:
Customer Jan Feb
Acme Corp 1,345 2,567
I just started using template columns and was going to try to pull data from
the same place but put a filter on each template column for each month.
Something like DataGrid runat=server id=dgDetails DataSource='<%#
GetDetails(container.dataitem("AccountID"))%>' WHERE Month = Jan
That doesn't seem to work. I dont' know how to get the WHERE clause in there.
The other option I guess would be to put a several prefiltered nested
datagrids into the datagrid?
Would love someone to set me straight. Thanks.