Hi,
The app configuration is asp.net(C#), crystal web viewer with SQL Server 2000 on the back-end. I am using the push model with ado.net datasets. Datetime fields from the database are not being displayed on the report. However, the fields are displayed if I convert the dates to varchar in the sproc. I also checked the dataset being returned and the date fields are populated.
The problem then is that I need to be able to sort the report at runtime on the date columns and if they are converted to varchar the values are sorted alphabetically instead of numerically. Any ideas would be appreciated (sample XML below).
TIA,
Amit Kohli
<NewDataSet>
<InvoicesMatterName>
<BusinessUnit>Default Business Unit</BusinessUnit>
<Litigation>NO</Litigation>
<MatterName>Matter Wonder</MatterName>
<MatterNumber>MW00003</MatterNumber>
<Description>Default Matter Type</Description>
<MatterOpenDate>Feb 26 2003</MatterOpenDate>
<MatterCloseDate>Jan 1 1900</MatterCloseDate>
<ResponsibleAttorney>Team, Moon</ResponsibleAttorney>
<Vendor>Vendor North</Vendor>
<Budget>7893.33</Budget>
<TotalPaid>0</TotalPaid>
<LawFirmID>VN10000</LawFirmID>
<InvoiceDate>2002-10-10T00:00:00.0000000-05:00</InvoiceDate>
<Status>Pending</Status>
<InvoiceNum>TESTI00006</InvoiceNum>
<Invoiced>8129.75</Invoiced>
<Disc_x002F_Adj>-1613.15</Disc_x002F_Adj>
<Net>6516.6</Net>
</InvoicesMatterName>
</NewDataSet>
The app configuration is asp.net(C#), crystal web viewer with SQL Server 2000 on the back-end. I am using the push model with ado.net datasets. Datetime fields from the database are not being displayed on the report. However, the fields are displayed if I convert the dates to varchar in the sproc. I also checked the dataset being returned and the date fields are populated.
The problem then is that I need to be able to sort the report at runtime on the date columns and if they are converted to varchar the values are sorted alphabetically instead of numerically. Any ideas would be appreciated (sample XML below).
TIA,
Amit Kohli
<NewDataSet>
<InvoicesMatterName>
<BusinessUnit>Default Business Unit</BusinessUnit>
<Litigation>NO</Litigation>
<MatterName>Matter Wonder</MatterName>
<MatterNumber>MW00003</MatterNumber>
<Description>Default Matter Type</Description>
<MatterOpenDate>Feb 26 2003</MatterOpenDate>
<MatterCloseDate>Jan 1 1900</MatterCloseDate>
<ResponsibleAttorney>Team, Moon</ResponsibleAttorney>
<Vendor>Vendor North</Vendor>
<Budget>7893.33</Budget>
<TotalPaid>0</TotalPaid>
<LawFirmID>VN10000</LawFirmID>
<InvoiceDate>2002-10-10T00:00:00.0000000-05:00</InvoiceDate>
<Status>Pending</Status>
<InvoiceNum>TESTI00006</InvoiceNum>
<Invoiced>8129.75</Invoiced>
<Disc_x002F_Adj>-1613.15</Disc_x002F_Adj>
<Net>6516.6</Net>
</InvoicesMatterName>
</NewDataSet>