Good day,
I am at a loss and as such turn to the forums for help.
I am generating a report where I am providing details on incidents called into a helpdesk where a specific product was used. These incidents may have a task that was assigned to a support group for resolution, there may have been more than 1 task, or there may be no task at all. The incident and tasks reside on separate tables within the database.
I need to provide all incidents that match this product criteria except where a task was sent to a group named "Business Solutions". This means that all tasks that went elsewhere, or were addressed solely by the helpdesk need to detailed in the report.
I have built the report on the incident table, and set the necessary filter on the specific product and time period etc. I have built a subreport to detail the task information and declared a shared string variable on the subreport @BSTask that provides a Yes or No output on if the Business Solutions group received a task (Yes being a task that is sent to Business Solutions).
I am able to use this shared string in the main report and it does report correctly, however I am unable to filter these incidents out based on the variable @BSTask as I receive the error "this field name is not known". I attempted to use a formula using the variable to assign a value of 1 to each task that sent to business solutions and a 0 for all other tasks and filter based on this, but this did not work either. I also tried a group selection on this but was unsuccessful.
Any suggestions are greatly appreciated.
Thanks,
JRR
I am at a loss and as such turn to the forums for help.
I am generating a report where I am providing details on incidents called into a helpdesk where a specific product was used. These incidents may have a task that was assigned to a support group for resolution, there may have been more than 1 task, or there may be no task at all. The incident and tasks reside on separate tables within the database.
I need to provide all incidents that match this product criteria except where a task was sent to a group named "Business Solutions". This means that all tasks that went elsewhere, or were addressed solely by the helpdesk need to detailed in the report.
I have built the report on the incident table, and set the necessary filter on the specific product and time period etc. I have built a subreport to detail the task information and declared a shared string variable on the subreport @BSTask that provides a Yes or No output on if the Business Solutions group received a task (Yes being a task that is sent to Business Solutions).
I am able to use this shared string in the main report and it does report correctly, however I am unable to filter these incidents out based on the variable @BSTask as I receive the error "this field name is not known". I attempted to use a formula using the variable to assign a value of 1 to each task that sent to business solutions and a 0 for all other tasks and filter based on this, but this did not work either. I also tried a group selection on this but was unsuccessful.
Any suggestions are greatly appreciated.
Thanks,
JRR