stored procedure / group name field???

[ShowersDK]

I am trying to replace the tables in a report with a stored procedure. Now in the Group formulas I get the error "group name field could not be created". Does anyone have an idea of what is happening here?

Thanks,
Darren

 

[scriptscroll]

The Group Field references a table that you do not have in the report anymore.

Solution: right click on the group header and select the CHANGE GROUP menu option.

Select the new column from the drop down...

cheers,

 

[ShowersDK]

Thanks! That worked. Since you seemed to be well versed in this area, maybe you can tell me why I am now getting the error message "The summary / running total field could not be created" in the same scenario of changing from tables to a stored procedure.

Thanks,
Darren

 

[ShowersDK]

Actually that turned out to be a similar issue. Now im getting the error "Physical Database not found" using a stored procedure. Any thoughts?

Thanks,
Darren

 

[scriptscroll]

Again, you'll have to right click on the summary field in question and delete it, then simply add a new summary field by selecting INSERT from the menu and select SUMMARY FIELD.