Crystal subreport demanding password... with a twist

Yahoo Archive
1
Good morning Elizabeth.

One way I have been able to "link twice" a table is by linking ONLY by the company field and then selecting (in BAQ criteria) when -in your case- PartRev.PartNum = PartMtl.PartNum OR PartRev.PartNum = PartMtl.MtlPartNum.

You would have to deal with duplicates at the Crystal level, but if it's a simple BAQReport as you mention, that also should be manageable. Shoot me an email if I can help you further with this.

Regards.

Roel Martinez
ERP Analyst

SABRE TUBULAR STRUCTURES (tm)
www.sabretubularstructures.com<http://www.sabretubularstructures.com/>
8653 E. Hwy 67 | Alvarado, TX 76009
Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax: 817-852-1705



[Non-text portions of this message have been removed]
2
Under Engineering > Reports lies the otherwise unobtrusive BOM Listing report. One of my engineers asked if I could add the PartRev.DrawNum field to each of the material parts.

Since the PartRev table is already being pulled for the main assembly, I added a subreport that uses a separate BAQ (not ODBC) and match the material part number and rev number with the appropriate drawing number.

On my PC this works great. Flawless. With anybody's Epicor login.

On any other PC, with my login, the system admin login, or anyone else's login, Crystal throws up a demand for username and password.

Everything I've found says that it's ODBC that makes this happen, but we don't even have ODBC installed (much to my chagrin, but that's a different story).

Any ideas where to look?

Ernie Lowell
Diba Industries
3
Good Day Ernie:

Is the BAQ, Report, and other things, "Shared" out, or even
"Global" if you are into that.

len.hartka@...

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Elizabeth
Sent: Thursday, February 24, 2011 3:13 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal subreport demanding password... with a twist




Under Engineering > Reports lies the otherwise unobtrusive BOM Listing
report. One of my engineers asked if I could add the PartRev.DrawNum
field to each of the material parts.

Since the PartRev table is already being pulled for the main assembly, I
added a subreport that uses a separate BAQ (not ODBC) and match the
material part number and rev number with the appropriate drawing number.

On my PC this works great. Flawless. With anybody's Epicor login.

On any other PC, with my login, the system admin login, or anyone else's
login, Crystal throws up a demand for username and password.

Everything I've found says that it's ODBC that makes this happen, but we
don't even have ODBC installed (much to my chagrin, but that's a
different story).

Any ideas where to look?

Ernie Lowell
Diba Industries






This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


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

Thanks for getting back so quick, but yes, the BAQ is shared. I also tried Global, but it had no noticeable effect.

It's an embarrassingly simple BAQ, a single table, 4 fields. In Crystal I've checked and re-checked the joins on both the main report and the subreport.

I've seen on this forum something about bringing a table in twice in a Report Data Definition. That's actually what I need to do... the PartRev table needs to be joined both to the PartMtl.PartNum field AND the PartMtl.MtlPartNum field. If there are other ways to do that I'm wide open.

Thanks again,

Ernie Lowell
Diba Industries

--- In vantage@yahoogroups.com, "Len Hartka" <len.hartka@...> wrote:
>
> Good Day Ernie:
>
> Is the BAQ, Report, and other things, "Shared" out, or even
> "Global" if you are into that.
>
> len.hartka@...
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Elizabeth
> Sent: Thursday, February 24, 2011 3:13 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal subreport demanding password... with a twist
>
>
>
>
> Under Engineering > Reports lies the otherwise unobtrusive BOM Listing
> report. One of my engineers asked if I could add the PartRev.DrawNum
> field to each of the material parts.
>
> Since the PartRev table is already being pulled for the main assembly, I
> added a subreport that uses a separate BAQ (not ODBC) and match the
> material part number and rev number with the appropriate drawing number.
>
> On my PC this works great. Flawless. With anybody's Epicor login.
>
> On any other PC, with my login, the system admin login, or anyone else's
> login, Crystal throws up a demand for username and password.
>
> Everything I've found says that it's ODBC that makes this happen, but we
> don't even have ODBC installed (much to my chagrin, but that's a
> different story).
>
> Any ideas where to look?
>
> Ernie Lowell
> Diba Industries
>
>
>
>
>
>
> This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
>
>
> [Non-text portions of this message have been removed]
>
5
Elizabeth, good morning. I don't know why my response earlier to this topic did not post, but well.... here's an idea.

One way I have been able to "link twice" a table is by linking ONLY by the company field and then selecting (in BAQ criteria) when –in your case- PartRev.PartNum = PartMtl.PartNum OR PartRev.PartNum = PartMtl.MtlPartNum.

You would have to deal with duplicates at the Crystal level, but if it's a simple BAQReport as you mention, that also should be manageable. Shoot me an email if I can help you further with this.

Roel Martinez

ERP Analyst.