Last post Oct 07, 2013 02:28 AM by cnranasinghe
Oct 06, 2013 07:43 AM|Jazaib.Hussain|LINK
Hello Everyone There,
I have 4 Tables using in my application building in asp.net on vs2010
1. Requests(id, description)
2. Items(id, name, description)
3. IssuedItems(id, item_id, request_id, qty, comments)
4. ReturnedItems(id, item_id, request_id, qty, comments)
I want to get list of issuedItems and ReturnedItems against a specific request id, and want to show this result on crystal reports. I can retrive data using SQL and able to show data in crystal reports but unable to show data as i required(SHOWN IN PICTURE
IN THE LINK.... http://imgur.com/ri4C8ve) on 1 page just. I am still getting data depends on the numbers of IssuedItems(for example if i have 10 Items then 10 pages are printing and all the pages have 1 item on it.)
Can anyone help me in showing data as i required.
Oct 07, 2013 02:28 AM|cnranasinghe|LINK
In your data source (from SQL) add new column as Type (data will be Parts and ReturnedParts). Add the datasource to the report and group the report using Type column. You will have 2 section as Parts and ReturnedParts.