Hello,

One of the features that my company wants for our dashboard is to show a list of 'My Reports' and then an indicator to show if the 'My Report' has a schedule attached attached to it. So if the user has 10 'My Reports' and only has a schedule for 2 of the reports he/she would be able to see that when they log in.

Would this be possible using the Report Caster API (or some other method)?

Thank you for your help.

Elizabeth Cosain

This message has been edited. Last edited by: <Kathryn Henning>,

Is this something you want as a part of the tree? Or would a report to do so be sufficient? You could create a report that goes off of the BOT* tables to see what Report Caster jobs are scheduled. You could then write a script to comb through the basedir and list all of the .fex files in the directories. Load that to a table and then join the two. This is probably the approach that I would take.

Hello,

Thanks for your response. I am pretty new to this and am just trying to find out if this is even possible.

I searched for the bot tables but could not find them on our server. I read that I may have to create synonyms for them (we are an Oracle shop) but was nervous about using the 'Create All Tables' on the Admin Console. Report Caster is up and running now so the tables should already be created, right? How do you access your BOT tables?

We would like to show an HTML list of the reports with links to the actual report and then the indicator that shows if there is a schedule or not.

If that is not possible a report will do. Do you have samples of the steps you proposed to create a script that pulls the data from basedir directory?

Thank you for your help.

Elizabeth Cosain

If you already use ReportCaster, then the tables would have been setup already. I would talk to your administrator about which schema they installed the tables into.

Sounds like you will have to create the synonyms for these tables though. Its not that difficult of a process so I wouldn't be scared. When you create them, just create a new folder on the data server first and then create them in there. That way you can be sure that you aren't over writing any preexisting master files. If you get stuck there is some documentation on creating master files in the tech doc library to help you out.

As for a sample script to pull the data from the basedir, I need to know where your client resides. Is it on windows or linux? Also does your company have any plans to move to WF8 any time soon? From my understanding the basedir is moving to be rdbms based as opposed to htm files. If you are planning on moving soon, it might just be better to wait until then when something like this should be that much easier and you would most likely have to rewrite your process. But that's a timing question. Effort versus gain.

For your report, you can use drills to execute the user report. I'm not sure how complex it would need to be, but there are ways that it could be done.