I'd looked at this report module a while back and there seemed to be a couple of different versions floating around - with the one currently on the Open Text KB site seeminly the last and more reliable of them.
Anyway (from memory), there's a couple of approches as to how the plugin actually fetches the data to collated the reports - some via RQL and some via direct ADO/asp connections. I think the asp/ado connection string variables are located in a file called redDot.asp in the reporting plugin windows folder. Check they are configured correctly ... I would use a SQL login (not Windows) to connect to the databases. If you know the username/password of the sql user which RedDot uses, ensure it has dbo rights to the RDReports db (and the other reddot project DBs) and you should be right to go. If you don't know those details, then create a new sql user and as above, assign it dbo access to the RDReports db and all the other project DBs. Paul. On Feb 19, 10:21 am, gk <[email protected]> wrote: > Thanks > > We are not using Oracle and no it won't let me run any user-based > reports (I hadn't tried these reports before). > > Any ideas on what might be causing the SQL connection to not work - > where I should point my IT guy to? > > On Feb 18, 2:26 pm, RedDotExpert <[email protected]> wrote: > > > > > That is correct, an Oracle connection module was never written. > > > The next version will be entirely AJAX using JQuery, database > > agnostic, and a much less complicated installation process. > > > Now, I am just waiting for Jian from OpenText to have time to do it. > > > On Feb 16, 10:30 pm, Gavin Cope <[email protected]> wrote: > > > > Also, last I looked, it wasn't compatible if you were using Oracle as your > > > CMS backend. > > > > On 17 February 2010 13:25, RedDotExpert <[email protected]> wrote: > > > > > Hello, from what I heard, the reports web app is divided into 2 > > > > backend calls, via RQL and SQL. > > > > > Can you do user specific detail report? If no, then the SQL > > > > connection is not working. > > > > > On Feb 8, 5:55 pm, gk <[email protected]> wrote: > > > > > Does anyone else use the RedDot CMS Reporting Plug-in? > > > > > > We've installed it as per the instructions and most of it is working > > > > > as expected - all except the Report Administration bit. This is where > > > > > I'm supposed to be able to add content class elements that will allow > > > > > me to track review dates for pages rather than doing it through > > > > > Workflow. > > > > > > I can open the Add Templates/Elements page, select the appropriate > > > > > content class folder from the drop-down box, select the appropriate > > > > > content class from the next drop-down box. When I then click on the > > > > > 'Add' button nothing happens - no error, no nothing, just sits there. > > > > > Looking at the picture in the manual, I'm supposed to then be able to > > > > > add elements from that content class. Then I should be able to run a > > > > > Page Element Extended Report to show me what is due for review and > > > > > when. > > > > > > Has anyone else had this problem? We are using RedDot V9. > > > > > -- > > > > You received this message because you are subscribed to the Google > > > > Groups > > > > "RedDot CMS Users" group. > > > > To post to this group, send email to [email protected]. > > > > To unsubscribe from this group, send email to > > > > [email protected]<reddot-cms-users%2bunsubscrib[email protected]> > > > > . > > > > For more options, visit this group at > > > >http://groups.google.com/group/reddot-cms-users?hl=en.-Hide quoted text - > > > - Show quoted text -- Hide quoted text - > > - Show quoted text - -- You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/reddot-cms-users?hl=en.
