Hi,
I created a DataSet MCO with 2 DataTables "Customers" and "Materials". With this I create a report (crystal report) showing the customers with it's materials (linked by an ID). The materials are shown in a subreport.
In this subreport I need some extra calculated fields. I can do this by inserting a function, that's no problem...but... To calculate this I need info of 2 textboxes on a windows form. These text boxes are no part of the table. Is it possible to "import" these values into the report and use these variables use in a function?
I found somthing about passing variables to a report, but I can't get it to work (yet). But I'm not sure this is the right way (caus maybe this is something like parameters in a query like in Access). Can anybody help me please?
edit: I also need to make a total of these calculated fields...So I'm not sure if I can use a function. On every detail line I will receive the right value, but is it possible to make a total sum too at the report footer? In Access I made a make-table query adding this extra field to the table. With this new table I created a report, and then I could make a sum.
I created a DataSet MCO with 2 DataTables "Customers" and "Materials". With this I create a report (crystal report) showing the customers with it's materials (linked by an ID). The materials are shown in a subreport.
In this subreport I need some extra calculated fields. I can do this by inserting a function, that's no problem...but... To calculate this I need info of 2 textboxes on a windows form. These text boxes are no part of the table. Is it possible to "import" these values into the report and use these variables use in a function?
I found somthing about passing variables to a report, but I can't get it to work (yet). But I'm not sure this is the right way (caus maybe this is something like parameters in a query like in Access). Can anybody help me please?
edit: I also need to make a total of these calculated fields...So I'm not sure if I can use a function. On every detail line I will receive the right value, but is it possible to make a total sum too at the report footer? In Access I made a make-table query adding this extra field to the table. With this new table I created a report, and then I could make a sum.
Last edited: