I am using Crystal 9.0 and SQL Server 2005.
I am trying to create a report which runs a Stored Procedure in SQL Server. The procedure accepts 6 parameters, 4 of which are comma delimited lists. I want to be able to provide the user a list of values in which to build these parameters.
To do this, I created a main report which has multiselect parameters for the 4 comma delimited lists. Then created formulas to take those parameters and concatinate them into comma delimited lists.
I linked those formulas to a subreport which runs the procedure. My problem is that the subreport will not pull up automatically when running the report. I have to double click on it (like an ondemand subreport) at which time it works beautifully
If I link to the subreport directly on the parameters, it will open right away, but I do not get the multiselect functionality.
Any suggestions on getting this report to open / function correctly?
Thanks
Joy
I am trying to create a report which runs a Stored Procedure in SQL Server. The procedure accepts 6 parameters, 4 of which are comma delimited lists. I want to be able to provide the user a list of values in which to build these parameters.
To do this, I created a main report which has multiselect parameters for the 4 comma delimited lists. Then created formulas to take those parameters and concatinate them into comma delimited lists.
I linked those formulas to a subreport which runs the procedure. My problem is that the subreport will not pull up automatically when running the report. I have to double click on it (like an ondemand subreport) at which time it works beautifully
If I link to the subreport directly on the parameters, it will open right away, but I do not get the multiselect functionality.
Any suggestions on getting this report to open / function correctly?
Thanks
Joy