Filtering data using web designer

kmt54_99 · Post by **kmt54_99** » Tue Mar 15, 2011 8:55 am

Hi,

I'm trying to create a report that is grouped by Serial Numbers (in this case) and then displays how many faults an item has had and its current location details, as shown in the example.

.

The report lists the correct data (as shown above) but I want to filter the data for items that have more than one fault and sort by the highest amount of faults first.

I've tried to filter the data using the expression Count(ColumnName) > 1 but this returns no data, so I assume I am doing something wrong. What would be the correct way of doing this?

Also am I using the right method for generating a report of this kind, I get the feeling I'm making things harder for myself than they really are?

Any help would be great!

Darren

Post by **Andrew** » Tue Mar 15, 2011 2:01 pm

Hello,

Unfortunately, the file you tried to upload is corrupted. Could you, please upload it again.

Thank you.

kmt54_99 · Post by **kmt54_99** » Wed Mar 16, 2011 3:57 am

Hi,

Sorry I put the internal web address not the external web address.

The image is:

Thanks,

Darren

Post by **Ivan** » Wed Mar 16, 2011 6:59 am

Hello,

Can you please send us a sample report with data, which reproduces the issue?

Thank you.

kmt54_99 · Post by **kmt54_99** » Wed Mar 16, 2011 7:22 am

Hi,

All my data gets populated from SQL as I load the report, so if I send you a saved report it will not contain the data, only the datasources. How do I save the report so that it saves the data with it?

Thanks,

Darren

kmt54_99 · Post by **kmt54_99** » Wed Mar 16, 2011 8:27 am

Hi,

All my data gets populated from SQL as I load the report, so if I send you a saved report it will not contain the data, only the datasources. How do I save the report so that it saves the data with it?

Thanks,

Darren

Post by **Alex K.** » Wed Mar 16, 2011 2:45 pm

Hello,

You can save data in the xml file with using following code:

Code: Select all

using (SqlConnection connection = new SqlConnection())
{
    SqlDataAdapter da = new SqlDataAdapter("Select * from Table", connection);
    DataSet ds = new DataSet("Data");
    da.Fill(ds);
    ds.WriteXml("path");
}

Thank you.

kmt54_99 · Post by **kmt54_99** » Thu Mar 17, 2011 3:38 am

Hi,

I've attached a sample of my report.

I also cannot get the report to sort by the counted column as well.

Thanks

Post by **Alex K.** » Fri Mar 18, 2011 4:15 am

Hello,

As a way, you can use master-detail report.
Please see modified report in attachment.

Thank you.

kmt54_99 · Post by **kmt54_99** » Mon Mar 21, 2011 2:46 am

Hi,

Thanks for this.

The only problem now is that I cannot get the count to display correctly for each record. I put {Count(Data1)} on the databand but it only works for one record.

Also is there a special way to create the databand you created as when I attempt to do it, I only get one record?

Also is there anyway to make the report sort by the number of faults?

Thanks