Can someone be able to help me how to schedule Crystal Reports (2008) with dynamic cascaded prompts, using BO Publications?I am not using a Universe, but importing database tables from teradata and using the fields in the report.
I need to schedule a report that give me 10 different reports for 10 different Countries. I have different levels of cascaded dynamic parameters in the report State>>Region>>Place>>Shop . For scheduling, how should I include Country as a parameter in the report? While running the publication, I don’t want to supply values for the 4 parameters, except the Country.
I tried using not hasvalue function in the report and the report now can run for ALL values if I don’t specify any parameter values. But while I tried to schedule this report through publications, I am getting 10 different reports but all of them are blank.
Am I doing something wrong in Record /Group Selection? I have been asking this question in many forums, but no luck. Can anyone please help me resolving this or suggest me a proper way that works? Thanks in advance
teejee (BOB member since 2012-03-18)