Quick question to guide me!

Hi there,

thanks for reading.

Firstly I'm developing using vb.net vs 2008 .net 3.5 SP1 SQL 2005 Express. It's a standard records app writing/retrieving data from DB. All complete now so all that is left is reporting side of it.

1) I would just like a few comments please on which route to take, MS Reporting vs Crystal Reports(both from VS2008). Now im not looking for super indepth analysis, just some general comments on which one would be better.

Im very new to reporting so the approach with least effort is my aim at moment, allowing me to produce decent reports without to much configuration i.e. stick to the wizards :) The reports will not be to complex, mainly just filtering a few fields in the DB i.e. payments from a specfic memberID, payments between certain dates etc, possibly some fields summing the data.

2) I have started playing around and created an MS report using the wizard and using a the report viewer to display it. Its all good except i'd like to know how to pass a specific query to the report instead of the default one the wizard chooses.. i.e. at moment from dataset i select 'Payments' table and the query it generated was just SELECT * from Payments. I want it to use another query in my dataset where it only looks for payments that match a specif ID. im sure its something trivial as changing one setting but i cant seem to find it.


Thanks again.:wave:

wow still nothing?!

ok dont worry about first point, ill stick to MS reporting for now...but can anyone please tell me how i can modify the report to use a paramter query(i.e. all fields matching paramter i pass).

thanks again

Quote:

---

Originally Posted by Cyrax.NET

wow still nothing?!

ok dont worry about first point, ill stick to MS reporting for now...but can anyone please tell me how i can modify the report to use a paramter query(i.e. all fields matching paramter i pass).

thanks again

---

create the parameter and then set the field represented in the parameter (denoted by the ?) to this:

{Table.FieldID}={?FieldID}