BAQ Report with ODBC subreport

system · December 2, 2008, 11:09am

Yes, I am trying to run it from the same machine that I wrote the
crystal report on, using the same system DSN. In fact after getting
the error I can go to the ..\mfgsysdata\reports\<uname> directory,
and find the .xml file. Replace the sample data file that is created
by the BAQ report tool with the newly generated file. Open the report
in Crystal, and I get the exact report I am looking for. Just not if
I run it from Vantage.
Thanks,
Craig
--- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@...>
wrote:

>
> Have you installed the OpenEdge Driver? Does doing a Test Connect

work in

> the Data Source Administrator?
>
> Scott
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On

Behalf Of

> Craig Weiss
> Sent: Tuesday, December 02, 2008 8:56 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BAQ Report with ODBC subreport
>
> Thanks for the response, but that didn't seem to help. What is

really

> strange, is that even when I fill in the information (server,
> database,table (greyed out), user, password), it doesn't seem to
> accept it. The prompt just keeps coming back.
>
> Craig
>
> --- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@>
> wrote:
> >
> > You need to enter the password in the Registry Key
> > HKLM\Software\ODBC\ODBC.INI\{Vantage Entry}
> >
> > Enter a String Value called Password. Modify that and enter the

ODBC

> > Password
> >
> > Scott
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
> > Craig Weiss
> > Sent: Monday, December 01, 2008 4:00 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] BAQ Report with ODBC subreport
> >
> > Is there any trick to creating a Crystal Report using the BAQ
> Report
> > tool, and adding subreports that are using ODBC? I have several
> Crystal
> > Reports that I have written using only ODBC, and when I run them
> from
> > the Vantage menu it gives the option to use the default
> credentials,
> > and all works fine. However, when I add a BAQ Report to the menu
> that
> > contains an ODBC sub-report it asks for credentials, and won't
> accept
> > them even if I type them. Am I missing something?
> > Thanks,
> > Craig
> >
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have
> > already linked your email address to a yahoo id to enable

access. )

> > (1) To access the Files Section of our Yahoo!Group for Report
> Builder and
> > Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You

must have

> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report

Builder and

> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>

system · December 1, 2008, 4:59pm

Is there any trick to creating a Crystal Report using the BAQ Report
tool, and adding subreports that are using ODBC? I have several Crystal
Reports that I have written using only ODBC, and when I run them from
the Vantage menu it gives the option to use the default credentials,
and all works fine. However, when I add a BAQ Report to the menu that
contains an ODBC sub-report it asks for credentials, and won't accept
them even if I type them. Am I missing something?
Thanks,
Craig

system · December 1, 2008, 5:03pm

You need to enter the password in the Registry Key
HKLM\Software\ODBC\ODBC.INI\{Vantage Entry}

Enter a String Value called Password. Modify that and enter the ODBC
Password

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Craig Weiss
Sent: Monday, December 01, 2008 4:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Report with ODBC subreport

Is there any trick to creating a Crystal Report using the BAQ Report
tool, and adding subreports that are using ODBC? I have several Crystal
Reports that I have written using only ODBC, and when I run them from
the Vantage menu it gives the option to use the default credentials,
and all works fine. However, when I add a BAQ Report to the menu that
contains an ODBC sub-report it asks for credentials, and won't accept
them even if I type them. Am I missing something?
Thanks,
Craig

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

system · December 1, 2008, 5:05pm

I embed the password in the connection string, while creating the connection in Crystal.

________________________________
From: Scott Litzau <scott.litzau@...>
To: vantage@yahoogroups.com
Sent: Monday, December 1, 2008 4:03:02 PM
Subject: RE: [Vantage] BAQ Report with ODBC subreport

You need to enter the password in the Registry Key
HKLM\Software\ ODBC\ODBC. INI\{Vantage Entry}

Enter a String Value called Password. Modify that and enter the ODBC
Password

Scott

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Craig Weiss
Sent: Monday, December 01, 2008 4:00 PM
To: vantage@yahoogroups .com
Subject: [Vantage] BAQ Report with ODBC subreport

Is there any trick to creating a Crystal Report using the BAQ Report
tool, and adding subreports that are using ODBC? I have several Crystal
Reports that I have written using only ODBC, and when I run them from
the Vantage menu it gives the option to use the default credentials,
and all works fine. However, when I add a BAQ Report to the menu that
contains an ODBC sub-report it asks for credentials, and won't accept
them even if I type them. Am I missing something?
Thanks,
Craig

------------ --------- --------- ------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups. yahoo.com/ group/vantage/ files/.
(2) To search through old msg's goto:
http://groups. yahoo.com/ group/vantage/ messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links

[Non-text portions of this message have been removed]

system · December 1, 2008, 5:09pm

If youÂ¹re using MSSQL you can also use SQL Native Client as your
connection method and use the Â³Trusted ConnectionÂ² option, which lets you
use the userÂ¹s Windows credentials to authenticate the database connection.
This is considerably more secure.

http://www.connectionstrings.com/ is a good resource if you do need to
build connection strings and arenÂ¹t sure of the syntax.

On 12/1/08 4:59 PM, "Craig Weiss" <cweiss@...> wrote:
>
> Is there any trick to creating a Crystal Report using the BAQ Report
> tool, and adding subreports that are using ODBC? I have several Crystal
> Reports that I have written using only ODBC, and when I run them from
> the Vantage menu it gives the option to use the default credentials,
> and all works fine. However, when I add a BAQ Report to the menu that
> contains an ODBC sub-report it asks for credentials, and won't accept
> them even if I type them. Am I missing something?

[Non-text portions of this message have been removed]

system · December 1, 2008, 5:33pm

I have not been able to get this to work.
What's your secret?

________________________________
From: "Brian W, Spolarich" <bspolarich@...>
To: vantage@yahoogroups.com
Sent: Monday, December 1, 2008 4:09:40 PM
Subject: Re: [Vantage] BAQ Report with ODBC subreport

If youÂ¹re using MSSQL you can also use SQL Native Client as your
connection method and use the Â³Trusted ConnectionÂ² option, which lets you
use the userÂ¹s Windows credentials to authenticate the database connection.
This is considerably more secure.

http://www.connecti onstrings. com/ is a good resource if you do need to
build connection strings and arenÂ¹t sure of the syntax.

On 12/1/08 4:59 PM, "Craig Weiss" <cweiss@peerlessmfg. com> wrote:
>
> Is there any trick to creating a Crystal Report using the BAQ Report
> tool, and adding subreports that are using ODBC? I have several Crystal
> Reports that I have written using only ODBC, and when I run them from
> the Vantage menu it gives the option to use the default credentials,
> and all works fine. However, when I add a BAQ Report to the menu that
> contains an ODBC sub-report it asks for credentials, and won't accept
> them even if I type them. Am I missing something?

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

system · December 2, 2008, 7:30am

Cunning? Dead chicken waving? Not sure since IÂ¹m donÂ¹t know what
problems youÂ¹re having. :-)

What I have concluded is that the embedded Crystal Reports viewer in
Vantage doesnÂ¹t work very well. Some of my custom reports that talk
directly to MSSQL simply donÂ¹t display properly in the Vantage viewer but
work fine in other viewers (e.g. the Logicity viewer).

You do need to make sure you add the Windows users accounts of those who
will be running these reports to MSSQL and give them db_datareader access at
a minimum to the database (or those tables involved if youÂ¹re concerned
about security), and any stored procedures youÂ¹re invoking.

-bws

On 12/1/08 5:33 PM, "Tony Hughes" <thughes281@...> wrote:

> I have not been able to get this to work.
> What's your secret?

[Non-text portions of this message have been removed]

system · December 2, 2008, 8:25am

must be the dead chicken, :D

I am not sure if it's my misunderstanding of what credentials are being passed.
I created a SQL logon that matches both name and password to the ODBC account you set up in System Agent.
I gave this SQL logon rights to execute the stored procedure, but I get the credentials prompt.
I also gave the SQL logon db_datareader to the database, but had same credentials prompt.

Most of our users go through Citrix, and I am thinking the problem is in that.
When I run Vantage locally, everything works perfectly for me (on my non-admin account). When I go through Citrix I get the prompt.
I can use the embedded ODBC connection string, using a logon that is only given execute to specific stored procedures I write.
Do you see any problem with my logic?

Thank you!

________________________________
From: "Brian W, Spolarich" <bspolarich@...>
To: vantage@yahoogroups.com
Sent: Tuesday, December 2, 2008 6:30:11 AM
Subject: Re: [Vantage] BAQ Report with ODBC subreport

Cunning? Dead chicken waving? Not sure since IÂ¹m donÂ¹t know what
problems youÂ¹re having. :-)

What I have concluded is that the embedded Crystal Reports viewer in
Vantage doesnÂ¹t work very well. Some of my custom reports that talk
directly to MSSQL simply donÂ¹t display properly in the Vantage viewer but
work fine in other viewers (e.g. the Logicity viewer).

You do need to make sure you add the Windows users accounts of those who
will be running these reports to MSSQL and give them db_datareader access at
a minimum to the database (or those tables involved if youÂ¹re concerned
about security), and any stored procedures youÂ¹re invoking.

-bws

On 12/1/08 5:33 PM, "Tony Hughes" <thughes281@yahoo. com> wrote:

> I have not been able to get this to work.
> What's your secret?

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

system · December 2, 2008, 8:48am

Maybe you're doing something different than I am since I'm using SQL
Native Client and Windows authentication via a MSSQL "Trusted
Connection" instead of ODBC. If you're truly using ODBC are your DSNs
setup correctly and identically on your system vs. the Citrix servers?

I can't answer the question about the relationship between the system
agent ODBC credentials and custom reports as I've never done it.

One thing that I do recall is that when I used SQL Native Client as my
connection method, if the client workstation doesn't have SQL Native
Client installed then you will also see the credentials prompt as the
embedded Crystal Viewer presumably throws some sort exception related to
connecting to the database that Vantage bubbles up to you as an
authentication challenge. It may be falling back to try to connect via
ODBC but it is not clear to me how that would work since the connection
details are embedded in the report itself.

I wrote a WSH/VBScript wrapper that invokes the custom report via the
Logicity viewer after checking to make sure that it and the SQL Native
Client were installed. If they're not, it points the user to a web page
where they can download and install the required components.

Not sure how this relates to your scenario though.

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... ~ 734-864-5618 ~
www.advancedphotonix.com

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Tony Hughes
Sent: Tuesday, December 02, 2008 8:25 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAQ Report with ODBC subreport

must be the dead chicken, :D

I am not sure if it's my misunderstanding of what credentials are being
passed.
I created a SQL logon that matches both name and password to the ODBC
account you set up in System Agent.
I gave this SQL logon rights to execute the stored procedure, but I get
the credentials prompt.
I also gave the SQL logon db_datareader to the database, but had same
credentials prompt.

Most of our users go through Citrix, and I am thinking the problem is in
that.
When I run Vantage locally, everything works perfectly for me (on my
non-admin account). When I go through Citrix I get the prompt.
I can use the embedded ODBC connection string, using a logon that is
only given execute to specific stored procedures I write.
Do you see any problem with my logic?

.

<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007181/msg
Id=71476/stime=1228224319/nc1=3848644/nc2=3848581/nc3=5349276>

[Non-text portions of this message have been removed]

system · December 2, 2008, 9:56am

Thanks for the response, but that didn't seem to help. What is really
strange, is that even when I fill in the information (server,
database,table (greyed out), user, password), it doesn't seem to
accept it. The prompt just keeps coming back.

Craig

--- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@...>
wrote:

>
> You need to enter the password in the Registry Key
> HKLM\Software\ODBC\ODBC.INI\{Vantage Entry}
>
> Enter a String Value called Password. Modify that and enter the ODBC
> Password
>
> Scott
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On

Behalf Of

> Craig Weiss
> Sent: Monday, December 01, 2008 4:00 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] BAQ Report with ODBC subreport
>
> Is there any trick to creating a Crystal Report using the BAQ

Report

> tool, and adding subreports that are using ODBC? I have several

Crystal

> Reports that I have written using only ODBC, and when I run them

from

> the Vantage menu it gives the option to use the default

credentials,

> and all works fine. However, when I add a BAQ Report to the menu

that

> contains an ODBC sub-report it asks for credentials, and won't

accept

> them even if I type them. Am I missing something?
> Thanks,
> Craig
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You

must have

> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report

Builder and

> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>

system · December 2, 2008, 10:45am

Have you installed the OpenEdge Driver? Does doing a Test Connect work in
the Data Source Administrator?

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Craig Weiss
Sent: Tuesday, December 02, 2008 8:56 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ Report with ODBC subreport

Thanks for the response, but that didn't seem to help. What is really
strange, is that even when I fill in the information (server,
database,table (greyed out), user, password), it doesn't seem to
accept it. The prompt just keeps coming back.

Craig

--- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@...>
wrote:

>
> You need to enter the password in the Registry Key
> HKLM\Software\ODBC\ODBC.INI\{Vantage Entry}
>
> Enter a String Value called Password. Modify that and enter the ODBC
> Password
>
> Scott
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On

Behalf Of

> Craig Weiss
> Sent: Monday, December 01, 2008 4:00 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] BAQ Report with ODBC subreport
>
> Is there any trick to creating a Crystal Report using the BAQ

Report

> tool, and adding subreports that are using ODBC? I have several

Crystal

> Reports that I have written using only ODBC, and when I run them

from

> the Vantage menu it gives the option to use the default

credentials,

> and all works fine. However, when I add a BAQ Report to the menu

that

> contains an ODBC sub-report it asks for credentials, and won't

accept

> them even if I type them. Am I missing something?
> Thanks,
> Craig
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You

must have

> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report

Builder and

> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

Topic		Replies	Views
BAQ Report Subreport Yahoo Archive	3	451	September 3, 2009
BAQ Report With Sub-report Yahoo Archive	1	340	September 4, 2009
ODBC password for Standard reports with subreports(6.1) Yahoo Archive	7	430	August 21, 2008
Custom Crystal Reports in Vantage 6.1 Yahoo Archive	6	864	November 26, 2008
[Vantage 8.03] Crystal ODBC Reports Yahoo Archive	9	677	August 17, 2007

BAQ Report with ODBC subreport

Related Topics