GeorgeSalet
asked on
creating a list of search strings in crystal reportscrystal reports
I have created a crystal report that displays the contents of a specific drawer in a truck the report uses uses 2 perimeters "R" or "L" and the drawer number. What I would like to do is create a report that will will list all the drawers in the truck and print my report sort of like a batch file.
r-11
report
r-12
report
r-13
report
etc etc
I just need some direction on what the best way to do this
Thanks
George
r-11
report
r-12
report
r-13
report
etc etc
I just need some direction on what the best way to do this
Thanks
George
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I agree with James. Using a subreport will be slower. How much depends on the data you have.
If you are trying to produce separate reports for each drawer there are 3rd-party tools that can burst the report into separate reports while printing.
mlmcc
If you are trying to produce separate reports for each drawer there are 3rd-party tools that can burst the report into separate reports while printing.
mlmcc
ASKER
I think I want to go with the sub-report routine. I am using perimeter as the memory variable to search on and wonder if I should use a formula field instead?
I want to change the value of the memory variable with some sort of statement and where would I put it
I am envisioning :
Side = r
Bin = 11
report
Side =r
Bin =12
report
Side =l
Bin = 11
report
Thanks for all the help
George
I want to change the value of the memory variable with some sort of statement and where would I put it
I am envisioning :
Side = r
Bin = 11
report
Side =r
Bin =12
report
Side =l
Bin = 11
report
Thanks for all the help
George
Where do the Side and Bin values come from? Are you going to read some table, like a "Drawer" table that contains a list of the drawers in each truck? Or is there a preset list of values (eg. you always want r-11, r-12, r-13, etc.)? Or does the user enter a list of drawers? If the user is selecting the drawers, what do they enter? Do they enter drawers (eg. r-11 and r-12), or separate Side and Bin values, or something else?
James
James
ASKER
The drawers are numbered in the database as side (side of truck) and Bin (number) both are in the database. this report will be static in that the user will have no choice as to what bins will be selected.
George
George
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
James