Report builder

Hi,

I know this has been covered before but I can't find the answer in the
archives.

What table and field contains the current user logged into Vantage that is
trying to run the report?


Thanks,


Dave Cole
Reeder & Kline



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

Please forgive my ignorance. Is there any way to prompt a user
for the filter parameters for a RB report. I hate having them
open the report in RB and having to edit the filters.

Perhaps using the Runtime-Parameters() function along with VB?

Thanks

Bob Bruton


[Non-text portions of this message have been removed]
Hey I think I can get this one...
In vantage "custom reports" when you select the report there is a check box
for print preview and a second for change filters. The user will then be
prompted for the filter change before the report runs...
I think I got that right, correct me if I am wrong...anyone...

Aaron Hoyt
System Administrator
Design Standards Corp.
PO Box 1620
Charlestown, NH 03603
Tel 603-826-7744
<mailto:Aaron@...>


-----Original Message-----
From: Robert Bruton [mailto:bob@...]
Sent: Friday, January 19, 2001 11:19 AM
To: vantage@egroups.com
Subject: [Vantage] Report builder


Hi All,

Please forgive my ignorance. Is there any way to prompt a user
for the filter parameters for a RB report. I hate having them
open the report in RB and having to edit the filters.

Perhaps using the Runtime-Parameters() function along with VB?

Thanks

Bob Bruton


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


To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com
If you add the report to Vantage's "Custom Report Link" and check the
FILTERS check box. If they run the report from this point or from the report
attach to the vantage menu structure they will get the filers dialog box.
Here they can change each report builder filer line to their liking. You can
also perform some other task for them such as defaulting the report to
today's transaction, etc... so they don't have to select a filter at all.
Generally if they have a version of a report they run all the time with a
filter set to say one customer I just save a copy of the report that way.
Good Luck.

Patrick

-----Original Message-----
From: Robert Bruton [mailto:bob@...]
Sent: Friday, January 19, 2001 10:19 AM
To: vantage@egroups.com
Subject: [Vantage] Report builder


Hi All,

Please forgive my ignorance. Is there any way to prompt a user
for the filter parameters for a RB report. I hate having them
open the report in RB and having to edit the filters.

Perhaps using the Runtime-Parameters() function along with VB?

Thanks

Bob Bruton


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


To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com
Thanks all.

Seems the memory isn't what it used to be. Have done this
in the past, just forgot.
Neurons must be calcified or something. :-)

Bob
Entek

-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Friday, January 19, 2001 11:50 AM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] Report builder




[Non-text portions of this message have been removed]
I recently saw a posting for being able to view the SQL behind a
report builder by hitting a key sequence. I can't remember what the keys
were or where I saw the tip. If anyone knows what this is, could you please
share it with me. Thank you.

Bart Sgroi


[Non-text portions of this message have been removed]
In Report Builder:
Debug Mode:
<ctrl> <alt> P
To View the SQL:
Go to debug mode, then press F12

Chris Gitzlaff
IS Manager
Major Industries, Inc.



-----Original Message-----
From: Sgroi, Bart T. [mailto:btsgroi@...]
Sent: Tuesday, July 10, 2001 3:02 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Report builder


I recently saw a posting for being able to view the SQL behind a
report builder by hitting a key sequence. I can't remember what the keys
were or where I saw the tip. If anyone knows what this is, could you please
share it with me. Thank you.

Bart Sgroi


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


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Thanks Chris

Bart

-----Original Message-----
From: Gitzlaff, Christopher [mailto:cgitzlaff@...]
Sent: Tuesday, July 10, 2001 4:19 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Report builder


In Report Builder:
Debug Mode:
<ctrl> <alt> P
To View the SQL:
Go to debug mode, then press F12

Chris Gitzlaff
IS Manager
Major Industries, Inc.



-----Original Message-----
From: Sgroi, Bart T. [mailto:btsgroi@...]
Sent: Tuesday, July 10, 2001 3:02 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Report builder


I recently saw a posting for being able to view the SQL behind a
report builder by hitting a key sequence. I can't remember what the keys
were or where I saw the tip. If anyone knows what this is, could you please
share it with me. Thank you.

Bart Sgroi


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


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



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