|
|
 Up |
|
|
  |
Author: glenglen Date: Sep 7, 2007 06:52
We are using BCM but are finding getting the reports we want
frustrating.....Is anyone using a third party report writer with success? I
noticed that BCM seems to be using Crystal reports.....Is the BCM data
accessable to Crystal reports to generate reports?
--
Thank you
Glen
|
| |
|
| | 10 Comments |
|
|
Author: LutherLuther Date: Sep 10, 2007 08:10
On Sep 7, 6:52 am, glen discussions.microsoft.com> wrote:> We are using BCM but are finding getting the reports we want
> frustrating.....Is anyone using a third party report writer with success? I
> noticed that BCM seems to be using Crystal reports.....Is the BCM data
> accessable to Crystal reports to generate reports?
> --
> Thank you
> Glen
Yes. Crystal, and any other report writer that uses generic Windows
mechanism to access databases (e.g. ODBC, or OLD-DB) should have
access to all the BCM dat
--when run by the same login that has access
to BCM. When connecting to the BCM database I would recommmend first
trying to find the data you want in their database views, before going
directly to the tables. The views aggregate fields across several
tables to present records packaged by the entities you're familiar
with in BCM (e.g. Business Contacts).
|
| |
|
| | no comments |
|
|
Author: glenglen Date: Sep 10, 2007 12:22
Thank you for the information..... One concern...Before I received your
response..I was able to get at some of the information via Access. The
information we are trying to get better reporting on is the product and
services table.....I wasn't able to link to this information using Access.
Can that infomation be linked to using Access...if not will I be able to open
the table in Crystal?
--
Thank you
Glen
"Luther" wrote:
> On Sep 7, 6:52 am, glen discussions.microsoft.com> wrote:>> We are using BCM but are finding getting the reports we want
>> frustrating.....Is anyone using a third party report writer with success...
|
| Show full article (1.35Kb) |
| no comments |
|
|
Author: LutherLuther Date: Sep 11, 2007 09:39
On Sep 10, 12:22 pm, glen discussions.microsoft.com> wrote:> Thank you for the information..... One concern...Before I received your
> response..I was able to get at some of the information via Access. The
> information we are trying to get better reporting on is the product and
> services table.....I wasn't able to link to this information using Access.
> Can that infomation be linked to using Access...if not will I be able to open
> the table in Crystal?
> --
> Thank you
> Glen
>
>
>
> "Luther" wrote:
>> On Sep 7, 6:52 am, glen discussions.microsoft.com> wrote:>>> We are using BCM but are finding getting the reports we want
>>> frustrating.....Is anyone using a third party report writer with success? I
>>> noticed that BCM seems to be using Crystal reports.....Is the BCM data
>>> accessable to Crystal reports to generate reports?
>>> -- ...
|
| Show full article (1.70Kb) |
| no comments |
|
|
Author: glenglen Date: Sep 11, 2007 18:22
Thank you for responding.....I just don't seem to able to find the
table....could you be so kind as to give me a little more detail.....ie what
kind of table and the location. I have installed Crystal and when adding a
connection I see the outlook folder and it lists all the tables except for
productsmaster. I have also tried to find it in Access. A little more
detail is appreciated.
--
Thank you
Glen
"Luther" wrote:
> On Sep 10, 12:22 pm, glen discussions.microsoft.com> wrote:>> Thank you for the information..... One concern...Before I received your
>> response..I was able to get at some of the information...
|
| Show full article (2.22Kb) |
| no comments |
|
|
Author: LutherLuther Date: Sep 12, 2007 15:22
On Sep 11, 6:22 pm, glen discussions.microsoft.com> wrote:> Thank you for responding.....I just don't seem to able to find the
> table....could you be so kind as to give me a little more detail.....ie what
> kind of table and the location. I have installed Crystal and when adding a
> connection I see the outlook folder and it lists all the tables except for
> productsmaster. I have also tried to find it in Access. A little more
> detail is appreciated.
> --
> Thank you
> Glen
>
>
>
> "Luther" wrote: >> On Sep 10, 12:22 pm, glen discussions.microsoft.com> wrote:>>> Thank you for the information..... One concern...Before I received your
>>> response..I was able to get at some of the information via Access. The
>>> information we are trying to get better reporting on is the product and
>>> services table.....I wasn't able to link to this information using Access.
>>> Can that infomation be linked to using Access...if not will I be able to open ...
|
| Show full article (2.99Kb) |
| no comments |
|
|
Author: glenglen Date: Sep 13, 2007 16:06
Luther
Thanks!
Good....I've determined from your instuctions....that the the sql instance
name and the database name are (the same as yours). So you have directed me
to the right door...now if you don't mind helping me open the door.
I am using Access 2007 on a Vista machine.....I open a blank data
base....click on the external data tab.....click on the more button....select
the ODBC_database.....click on the radio button-Link to the data source by
creating a linked table....OK....Then I'm prompted for a DNS
Name.?????.....I'm not seeing where to enter the SQL instance name and
database name. Any suggestions to get me on the right path.
--
Thank you
Glen
"Luther" wrote:
> On Sep 11, 6:22 pm, glen discussions.microsoft.com> wrote:>> Thank you for responding.....I just don't seem to able to find the
>> table....could you be so kind as to give me a little more detail...
|
| Show full article (3.84Kb) |
| no comments |
|
|
Author: glenglen Date: Sep 17, 2007 16:52
Again thankyou for the previous information....however....I find it curious
that I am unable to finish this off......you have provided me a lot of should
do this ....should do that.....but when it comes down to finishing this...and
actually making BCM work for us.....nothing is given....from anyone including
support. Frustrated....and since I haven't heard back from anyone....I'm
assuming that any report writting outside of the quite limited canned reports
is not possible.
--
Thank you
Glen
"Luther" wrote:
> On Sep 11, 6:22 pm, glen discussions.microsoft.com> wrote:>> Thank you for responding.....I just don't seem to able to find the
>> table....could you be so kind as to give me a little more detail...
|
| Show full article (3.67Kb) |
| no comments |
|
|
Author: LutherLuther Date: Sep 19, 2007 20:34
On Sep 13, 4:06 pm, glen discussions.microsoft.com> wrote:> Luther
>
> Thanks!
> Good....I've determined from your instuctions....that the the sql instance
> name and the database name are (the same as yours). So you have directed me
> to the right door...now if you don't mind helping me open the door.
> I am using Access 2007 on a Vista machine.....I open a blank data
> base....click on the external data tab.....click on the more button....select
> the ODBC_database.....click on the radio button-Link to the data source by
> creating a linked table....OK....Then I'm prompted for a DNS
> Name.?????.....I'm not seeing where to enter the SQL instance name and
> database name. Any suggestions to get me on the right path.
> --
> Thank you
> Glen
>
>
>
> "Luther" wrote: ...
|
| Show full article (4.34Kb) |
| no comments |
|
|
|
|
|
Author: LutherLuther Date: Sep 19, 2007 20:36
On Sep 19, 8:34 pm, Luther gmail.com> wrote:> On Sep 13, 4:06 pm, glen discussions.microsoft.com> wrote:
>
>
>
>
>>> Luther
>
>> Thanks!
>> Good....I've determined from your instuctions....that the the sql instance
>> name and the database name are (the same as yours). So you have directed me
>> to the right door...now if you don't mind helping me open the door.
>> I am using Access 2007 on a Vista machine.....I open a blank data
>> base....click on the external data tab.....click on the more button....select
>> the ODBC_database.....click on the radio button-Link to the data source by
>> creating a linked table....OK....Then I'm prompted for a DNS
>> Name.?????.....I'm not seeing where to enter the SQL instance name and
>> database name. Any suggestions to get me on the right path.
>> -- ...
|
| Show full article (4.73Kb) |
| no comments |
|
|
|
|
