help in Crystal reports to pass multilple ID's for selection
-
Well hi everyone, I have a problem with crystal reports... the record selection formula in crystal reports helps to retieve a single row from the database (depending on the ID passed) Now the problem is if have a selection criteria which demands to retrieve data from the databse for more than one ID so how will i pass multiple ID for selecting multiple row...please help.. Eg. my selection crieria wud be prjID = 1 record selection formula wud be = 1 now if my selection criteria prjID = 1 and 4 and 6 and 9 hw ud i do it... Sachin G. worrin bout losin keeps me WINNING
-
Well hi everyone, I have a problem with crystal reports... the record selection formula in crystal reports helps to retieve a single row from the database (depending on the ID passed) Now the problem is if have a selection criteria which demands to retrieve data from the databse for more than one ID so how will i pass multiple ID for selecting multiple row...please help.. Eg. my selection crieria wud be prjID = 1 record selection formula wud be = 1 now if my selection criteria prjID = 1 and 4 and 6 and 9 hw ud i do it... Sachin G. worrin bout losin keeps me WINNING
im using this formula in my current working report {Project.ProjectID} = 1 or {Project.ProjectID} = 2 or {Project.ProjectID} = 3 TRY IT.................
-<>-shoaib-<>-
-
im using this formula in my current working report {Project.ProjectID} = 1 or {Project.ProjectID} = 2 or {Project.ProjectID} = 3 TRY IT.................
-<>-shoaib-<>-
Ya thanks... but i tried it it doesn't works.... i tried with the OR condition.. still it is retrieving single row.. also i tried with AND condition and the report goes blank.... Please can u suggest any other alternative.... Sachin G.