Page 1 of 2
Filtering data using web designer
Posted: Tue Mar 15, 2011 8:55 am
by kmt54_99
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
Filtering data using web designer
Posted: Tue Mar 15, 2011 2:01 pm
by Andrew
Hello,
Unfortunately, the file you tried to upload is corrupted. Could you, please upload it again.
Thank you.
Filtering data using web designer
Posted: Wed Mar 16, 2011 3:57 am
by kmt54_99
Hi,
Sorry I put the internal web address not the external web address.
The image is:
Thanks,
Darren
Filtering data using web designer
Posted: Wed Mar 16, 2011 6:59 am
by Ivan
Hello,
Can you please send us a sample report with data, which reproduces the issue?
Thank you.
Filtering data using web designer
Posted: Wed Mar 16, 2011 7:22 am
by kmt54_99
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
Filtering data using web designer
Posted: Wed Mar 16, 2011 8:27 am
by kmt54_99
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
Filtering data using web designer
Posted: Wed Mar 16, 2011 2:45 pm
by Alex K.
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.
Filtering data using web designer
Posted: Thu Mar 17, 2011 3:38 am
by kmt54_99
Hi,
I've attached a sample of my report.
I also cannot get the report to sort by the counted column as well.
Thanks
Filtering data using web designer
Posted: Fri Mar 18, 2011 4:15 am
by Alex K.
Hello,
As a way, you can use master-detail report.
Please see modified report in attachment.
Thank you.
Filtering data using web designer
Posted: Mon Mar 21, 2011 2:46 am
by kmt54_99
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