Dashboard copy all with headings

Yahoo Archive
1
I've never been a Crystal fan. (Not the right tool for the stuff I do... Excel is much more powerful for my needs).
I just find it easier to do a BAQ export and just read the CSV right into excel (where I then do most of the 'heavy lifting' data manipulation & analysis anyway).

Whatever works for you is the way to go.

RobÂ




________________________________
From: Derek Roberts <droberts@...>
To: vantage@yahoogroups.com
Sent: Thursday, May 21, 2009 2:24:08 PM
Subject: RE: [Vantage] Dashboard copy all with headings





What we do (until we upgrade to 9) is create a BAQ Report Design using
Crystal and they run the report in print preview and export the report
to excel (data only) and then the labels are there. You just have to be
careful with the crystal report to make sure it exports correctly.

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Robert Brown
Sent: Thursday, May 21, 2009 11:58 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Dashboard copy all with headings

You could trace through the dashboards and find the underlying system
BAQs feeding them, copy them to your own BAQ(s) so you can twiddle with
them - and then export the BAQ (to CSV) with headers. Those CSV fiels
can then be read by excel as datasources (with headers intact & the
ability to add your own formulas & additional info via vlookup() excel
cell formula.).

Rob

____________ _________ _________ __
From: Randy <rweber@tlcelectroni cs.com
<mailto:rweber% 40tlcelectronics .com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Thursday, May 21, 2009 11:52:07 AM
Subject: [Vantage] Dashboard copy all with headings

I love the Copy All Copy Selection feature in Dashboards but am
frustrated that the headings are not there.

I made some Excel spreadsheets with headings as templates and then we
paste into row 2. This works okay as long as we don't re-arrange the
Dashboard in any way.

Is there something better that I may have missed?

Randy Weber

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

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







[Non-text portions of this message have been removed]
2
I love the Copy All Copy Selection feature in Dashboards but am frustrated that the headings are not there.

I made some Excel spreadsheets with headings as templates and then we paste into row 2. This works okay as long as we don't re-arrange the Dashboard in any way.

Is there something better that I may have missed?

Randy Weber
3
This is probably not going to help you right now but in E9 you can copy with headings on dashboards. I have not come up with a way to do it in 8.0x except to do what you are doing with templates in excel

--- On Thu, 5/21/09, Randy <rweber@...> wrote:


From: Randy <rweber@...>
Subject: [Vantage] Dashboard copy all with headings
To: vantage@yahoogroups.com
Date: Thursday, May 21, 2009, 11:52 AM








I love the Copy All Copy Selection feature in Dashboards but am frustrated that the headings are not there.

I made some Excel spreadsheets with headings as templates and then we paste into row 2. This works okay as long as we don't re-arrange the Dashboard in any way.

Is there something better that I may have missed?

Randy Weber



















[Non-text portions of this message have been removed]
4
Okay - V9 it is. I'm happy to know that is coming J



Randy Weber



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Wagner
Sent: Thursday, May 21, 2009 11:08 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Dashboard copy all with headings








This is probably not going to help you right now but in E9 you can copy
with headings on dashboards. I have not come up with a way to do it in
8.0x except to do what you are doing with templates in excel

--- On Thu, 5/21/09, Randy <rweber@...
<mailto:rweber%40tlcelectronics.com> > wrote:

From: Randy <rweber@...
<mailto:rweber%40tlcelectronics.com> >
Subject: [Vantage] Dashboard copy all with headings
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Date: Thursday, May 21, 2009, 11:52 AM

I love the Copy All Copy Selection feature in Dashboards but am
frustrated that the headings are not there.

I made some Excel spreadsheets with headings as templates and then we
paste into row 2. This works okay as long as we don't re-arrange the
Dashboard in any way.

Is there something better that I may have missed?

Randy Weber

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





[Non-text portions of this message have been removed]
5
You could trace through the dashboards and find the underlying system BAQs feeding them, copy them to your own BAQ(s) so you can twiddle with them - and then export the BAQ (to CSV) with headers. Those CSV fiels can then be read by excel as datasources (with headers intact & the ability to add your own formulas & additional info via vlookup() excel cell formula.).

Rob




________________________________
From: Randy <rweber@...>
To: vantage@yahoogroups.com
Sent: Thursday, May 21, 2009 11:52:07 AM
Subject: [Vantage] Dashboard copy all with headings





I love the Copy All Copy Selection feature in Dashboards but am frustrated that the headings are not there.

I made some Excel spreadsheets with headings as templates and then we paste into row 2. This works okay as long as we don't re-arrange the Dashboard in any way.

Is there something better that I may have missed?

Randy Weber







[Non-text portions of this message have been removed]
6
It is very easy to create a dashboard crystal report. Then just add all the fields from the dashboard to the report and export Excel data only from the report.

--- On Thu, 5/21/09, Robert Brown <robertb_versa@...> wrote:


From: Robert Brown <robertb_versa@...>
Subject: Re: [Vantage] Dashboard copy all with headings
To: vantage@yahoogroups.com
Date: Thursday, May 21, 2009, 11:58 AM








You could trace through the dashboards and find the underlying system BAQs feeding them, copy them to your own BAQ(s) so you can twiddle with them - and then export the BAQ (to CSV) with headers. Those CSV fiels can then be read by excel as datasources (with headers intact & the ability to add your own formulas & additional info via vlookup() excel cell formula.).

Rob

____________ _________ _________ __
From: Randy <rweber@tlcelectroni cs.com>
To: vantage@yahoogroups .com
Sent: Thursday, May 21, 2009 11:52:07 AM
Subject: [Vantage] Dashboard copy all with headings

I love the Copy All Copy Selection feature in Dashboards but am frustrated that the headings are not there.

I made some Excel spreadsheets with headings as templates and then we paste into row 2. This works okay as long as we don't re-arrange the Dashboard in any way.

Is there something better that I may have missed?

Randy Weber

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



















[Non-text portions of this message have been removed]
7
What we do (until we upgrade to 9) is create a BAQ Report Design using
Crystal and they run the report in print preview and export the report
to excel (data only) and then the labels are there. You just have to be
careful with the crystal report to make sure it exports correctly.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Robert Brown
Sent: Thursday, May 21, 2009 11:58 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Dashboard copy all with headings








You could trace through the dashboards and find the underlying system
BAQs feeding them, copy them to your own BAQ(s) so you can twiddle with
them - and then export the BAQ (to CSV) with headers. Those CSV fiels
can then be read by excel as datasources (with headers intact & the
ability to add your own formulas & additional info via vlookup() excel
cell formula.).

Rob

________________________________
From: Randy <rweber@...
<mailto:rweber%40tlcelectronics.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thursday, May 21, 2009 11:52:07 AM
Subject: [Vantage] Dashboard copy all with headings

I love the Copy All Copy Selection feature in Dashboards but am
frustrated that the headings are not there.

I made some Excel spreadsheets with headings as templates and then we
paste into row 2. This works okay as long as we don't re-arrange the
Dashboard in any way.

Is there something better that I may have missed?

Randy Weber

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





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