rgordish, Member
We are trialing mydbr for use within the Department, however, I am having problems creating reports.
I can create the SP's and they all seem to work fine, but when trying to create the report itself, the drop down box on thr "Add Report" dialog only lists sp_DBR, no others. sp_DBR is the first SP I played with?
I can't find a way in other than to edit the first SP...
myDBR Team, Key Master
myDBR will show in the Add Report dialog those reports that have been created with prefix 'sp_DBR' but that not yet been attached as a report. So looks like you only got the first one.
To make sure you have the other procedures stored in the database, run this in the SQL Editor:
MySQL:
SHOW PROCEDURE STATUS like 'sp_DBR%'
SQL Server / Sybase / SQL Anywhere:
select name from sysobjects where name like 'sp_DBR%'
That will show you the list of stored procedures. You can directly edit any of them by selecting the name in SQL Editor editing area and clicking "Show selected object".
When you create a report procedure, attach it as a report so that they do not always show up in Add Report dialog.
--
myDBR Team
rgordish, Member
Aha !
Ok, got it, thanks very much. I was removing the DBR bit when naming the procedures.
Thank you
You must log in to post.