PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → Click on Report to open Form
Click on Report to open Form
Débuté par Denis Vaughan, 22 aoû. 2008 18:17 - 1 réponse
#1
Posté le 22 août 2008 - 18:17
Hi,

I have a report created based on a query. The report shows a certain subset of records from a particular data table. Under the click function for one of the report controls I have code to open a form which contains a table control for all records in the data table that the report query is based on. That works fine.

What I want to do is open that form but in the table, only have records that match the value of the report control I have clicked.

So if a row in the report contains a document number, that it opens the form displaying all records in the table that has that same value.

Obviously the query in the report will differ in criteria from the query when the form opens.

Thanks

DV
#2
Posté le 26 août 2008 - 17:46
Hi,

I now have this where, when you click on a row, it opens the form with the table control limited to a value. However the value I am passing the form is being used to filter the table based on the primery key. Can I change the filter (table..filter ?) of the form so that it points to a different field in the table. At the moment it returns one row (value passed to it happens to also be a value in the primary field). If I can change the table's filiter to look at a different fiedl it would return several rows. The other field is indexed but allows duplicates.

Code from report = Open(Win_Matched,MySource.ID_QW)
The value of MySource.ID_QW could be 3 and there might be 5 rows that match. However when the table is displayed it matched this value to it's primary key field instead returning 1 row (or possibly none if there is no match)

Can you help

DV
→ Revenir à WINDEV 2024