BAQ Report Blank Title 83353

Yahoo Archive
1
Hi Paul,

I'm not sure why you'd want to use this query.

The way you have it it's only looking for warehousecode=''. Unfortunately
there isn't a wildcard. However, if you summarize this table you can create
a formula which can then do a sum( <formula> ) and will get you the desired
results.

Not knowing how you are bringing in the PartTran or what your end result is
I'm just offering what I see at this point.

--Sean



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Paul Smith
Sent: Wednesday, March 17, 2010 1:32 PM
To: Vantage
Subject: [Vantage] BAQ Report






Group

I am looking for a report that needs to pull information from several
different warehouses. Is there a wildcard I can use to specify search in
every warehouse? The BAQ code is below. Thanks in advance

and PartTran.WareHouseCode = ' ' and

Paul Smith

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





[Non-text portions of this message have been removed]
2
I have created a BAQ report and in the report form I want to set the
archive period to one week. Easy choice. However, under the actions
menu where I would typically go to Save the Defaults, everything is
grayed out and it won't allow me to save any changes. What am I
missing?



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>







[Non-text portions of this message have been removed]
3
Was it created with a different user ID?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rob Bucek
Sent: Wednesday, September 30, 2009 9:18 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Report

I have created a BAQ report and in the report form I want to set the
archive period to one week. Easy choice. However, under the actions
menu where I would typically go to Save the Defaults, everything is
grayed out and it won't allow me to save any changes. What am I
missing?



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>







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



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

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
4
I created it under the same user ID I am currently trying to modify it
with..



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Wednesday, September 30, 2009 8:24 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Report





Was it created with a different user ID?

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Rob Bucek
Sent: Wednesday, September 30, 2009 9:18 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ Report

I have created a BAQ report and in the report form I want to set the
archive period to one week. Easy choice. However, under the actions
menu where I would typically go to Save the Defaults, everything is
grayed out and it won't allow me to save any changes. What am I
missing?

Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>

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

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

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/.
<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]
5
Rob,

I get that on all my BAQ reports. I don't know if it can be changed.

If you want an alternative you could put this in to a customization on the
BAQ front end. This would make it global.

'------------------------------------------------
Private Sub BAQReportForm_Load(ByVal sender As object, ByVal args As
EventArgs) Handles BAQReportForm.Load
'//
'// Add Event Handler Code
'//
Dim edvReportParam As EpiDataView =
CType(oTrans.EpiDataViews("ReportParam"), EpiDataView)
edvReportParam.dataView(edvReportParam.Row)("ArchiveCode") = 7

End Sub
'-----------------------------------------------

I suppose you could look at the sessionid if you wanted it to be specific to
a user or group of users.

Ross


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Rob Bucek
Sent: Wednesday, September 30, 2009 8:18 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Report

I have created a BAQ report and in the report form I want to set the
archive period to one week. Easy choice. However, under the actions
menu where I would typically go to Save the Defaults, everything is
grayed out and it won't allow me to save any changes. What am I
missing?



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>







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



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

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
6
Hey Ross,



Thanks for the input! Making it a global parameter via customization
would be a very acceptable solution to this. I didn't know you could do
that with VB customization...Thanks a lot!!



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ross Hughes
Sent: Wednesday, September 30, 2009 9:38 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Report





Rob,

I get that on all my BAQ reports. I don't know if it can be changed.

If you want an alternative you could put this in to a customization on
the
BAQ front end. This would make it global.

'------------------------------------------------
Private Sub BAQReportForm_Load(ByVal sender As object, ByVal args As
EventArgs) Handles BAQReportForm.Load
'//
'// Add Event Handler Code
'//
Dim edvReportParam As EpiDataView =
CType(oTrans.EpiDataViews("ReportParam"), EpiDataView)
edvReportParam.dataView(edvReportParam.Row)("ArchiveCode") = 7

End Sub
'-----------------------------------------------

I suppose you could look at the sessionid if you wanted it to be
specific to
a user or group of users.

Ross

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Rob Bucek
Sent: Wednesday, September 30, 2009 8:18 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ Report

I have created a BAQ report and in the report form I want to set the
archive period to one week. Easy choice. However, under the actions
menu where I would typically go to Save the Defaults, everything is
grayed out and it won't allow me to save any changes. What am I
missing?

Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>

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

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

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/.
<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]
7
Group

I am looking for a report that needs to pull information from several
different warehouses. Is there a wildcard I can use to specify search in
every warehouse? The BAQ code is below. Thanks in advance


and PartTran.WareHouseCode = ' ' and

Paul Smith




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