Hi All,
I am trying to connect my crystal reports 2011 from my local pc to SAP BW OLAP on a server.
I have not created an ODBC on my local pc as I am going file/new in CR and choosing OLAP. Following through and adding, then from the drop down choosing SAP Business Information Warehouse. I am...
Hi All,
I am using SQL 2008 R2 and I have a table with a lookup field. The lookup field must connect to another table and rather than go through the 100+ tables is there a search facility which can show me which other tables hold this field? Or a sql script?
Many Thanks
Hi All,
Iam using SQL Server 2008 r2 and wanted to know when I get my results can I change the view method from horizontal to vertical as you can do in Oracle.
Many Thanks
Hi All,
I have seen a functionality in SQL Server 2008 r2 which automatically populates codes in Management Studio as typing...I have seen this on someone else's pc, so intrigued how this is possible...
I am fairly new to SQL Server...
Please can you help....
Many Thanks
Hi All,
I am new Sharepoint Excel services, please someone tell me can Sharepoint Excel services handle different data sources (Oracle, MS SQL) in the same workbook and on the same worksheet?
I hope I am in the correct forum
Many Thanks
Hi All,
please can you remind me can CR XI rel3 handle mutiple data sources in one report i.e. two subreport embedded into one report one data source being SQL and another Oracle.
Many Thanks
Hi All,
does anyone how to get the old 'Show desktop' icon on the left hand side of the taskbar. That was nice, dont know why they changed it in windows 7!
Many Thanks
Hi All,
I am using outlook 2007 and in my inbox my email is being grouped my date. I dont want that, I just want one list to be sorted by received date. How do I switch off the grouping?
Many Thanks
Hi All,
I am using MS Word 2007, when I open a new document the document aligns to the left of the screen. How do I get it in the centre of the screen?
Many Thanks
Hi All,
I am looking into SSRS 2008 R2 and wanted to is it possible to connect to a Oracle ODS?
Also is an ODS only available in Oracle databases?
Many Thanks
Hi All,
I have working with ms excel 2007 and I have a top row which i want to freeze as well as a row on the left hand side. I cant manage both at the same time....Please can you advise...
Many Thanks
Hi All,
I have been given a task to choose a BI reporting tool from either Business Objects or SSRS. I come from a Business Objects background and want to better understand SSRS.
Please can you advise like in BO there is a universe so one change can impact many reports, is that functionality...
Hi All,
I know this is the business objects forum but I wanted to know your opinion on BO on a whole compared to other products especially around for example:
SSRS 2008 better than Crystal reports?
Strategy Companion Analyzer better than BO Voyager?
Anything that rivals WEBI?
Many Thanks
Hi All,
I am using MS Office 2007 and have some columns where I type in 'Yes'
they change colour...
Please can you advise how do I change that?
Many Thanks
Hi All,
please can you advise how the following is possible?
select *
from table1
where
trunc(started) >= '09-Aug-2010'
and started < sysdate
The line
trunc (started) i.e. field is not even available in the table, how can this work I am lost?
Many Thanks
Hi All,
I am new to MS Excel and olap connection. I have connected to the olap cube and placed two fields in the report filter.
field 1
field 2
Now I want to code to bring back data where it meets the following condition
field 1 or field 2
or (field 1 and field 2)
Where do I code this?
I...
Hi All,
Can someone tell me if this is correct:
In sql server 2005, there is BIDS which allows you to create reports. Does 2005 have report builder? Is there reporting services in sql server 2005?
In sql server 2008, there is SSRS, now what is the difference between reporting services and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.