Last post Jul 29, 2014 05:20 AM by Ajay2707
Jul 25, 2014 09:28 AM|aspfun|LINK
I use store procedure with CR. If the store procedure only return one table, CR has no problem.
Now, I change the store procedure to return two tables.
How to make CR to choose second tables as data source?
In CR fields explore, I can only see fields from one table.
Jul 25, 2014 09:40 AM|Prince Srivastava|LINK
use Tables for first table or
Tables for first table
or wirte your table name
ddlCity.DataSource = cboxTeam_DS.Tables["MyTable"];
ddlCity.DataTextField = "CityName";
ddlCity.DataValueField = "idCode";
Jul 28, 2014 05:36 AM|aspsak|LINK
Jul 29, 2014 05:20 AM|Ajay2707|LINK
You can't use second table from sp.
Either use single table which return from stored procedure
or use direct tables in crystal report and map field in selection formula.
Another approach is sub-report. To use second table, create sub-report and use it in main report with mapping parameters.