Database to Excel charts (or pdf)
Hi guys I have a simple DB that has two fields in it (time and number 1-3), the data needs to be exported and shown in simple charts (horizontal bars from 0 to max time from my DB)? What is the best way to do that?
sql
sql-server tsql charts edited Nov 13 '18 at 9:52
Shnugo
49k72567
asked Nov 13 '18 at 8:35
Adam DominiakAdam Dominiak
13
|
show 2 more comments
Hi guys I have a simple DB that has two fields in it (time and number 1-3), the data needs to be exported and shown in simple charts (horizontal bars from 0 to max time from my DB)? What is the best way to do that?
sql
sql-server tsql charts edited Nov 13 '18 at 9:52
Shnugo
49k72567
asked Nov 13 '18 at 8:35
Adam DominiakAdam Dominiak
13
Which database it is? SQL, Oracle ?
– Shaili
Nov 13 '18 at 8:47
it's a T-SQL database
– Adam Dominiak
Nov 13 '18 at 8:49
mssqltips.com/sqlservertip/4902/… This may help
– Shaili
Nov 13 '18 at 8:50
T-SQL is not a database, it'a a language. It's used by Sybase and Microsoft SQL Server.
– Zohar Peled
Nov 13 '18 at 9:24
@ZoharPeled Yes I meant SQL Server
– Adam Dominiak
Nov 13 '18 at 9:29
|
show 2 more comments
Hi guys I have a simple DB that has two fields in it (time and number 1-3), the data needs to be exported and shown in simple charts (horizontal bars from 0 to max time from my DB)? What is the best way to do that?
sql
sql-server tsql charts edited Nov 13 '18 at 9:52
Shnugo
49k72567
asked Nov 13 '18 at 8:35
Adam DominiakAdam Dominiak
13
Hi guys I have a simple DB that has two fields in it (time and number 1-3), the data needs to be exported and shown in simple charts (horizontal bars from 0 to max time from my DB)? What is the best way to do that?
sql
sql-server tsql charts sql
sql-server tsql charts edited Nov 13 '18 at 9:52
Shnugo
49k72567
asked Nov 13 '18 at 8:35
Adam DominiakAdam Dominiak
13
edited Nov 13 '18 at 9:52
Shnugo
49k72567
asked Nov 13 '18 at 8:35
Adam DominiakAdam Dominiak
13
edited Nov 13 '18 at 9:52
Shnugo
49k72567
edited Nov 13 '18 at 9:52
Shnugo
49k72567
edited Nov 13 '18 at 9:52
Shnugo
49k72567
49k72567
asked Nov 13 '18 at 8:35
Adam DominiakAdam Dominiak
13
asked Nov 13 '18 at 8:35
Adam DominiakAdam Dominiak
13
asked Nov 13 '18 at 8:35
Adam DominiakAdam Dominiak
13
13
Which database it is? SQL, Oracle ?
– Shaili
Nov 13 '18 at 8:47
it's a T-SQL database
– Adam Dominiak
Nov 13 '18 at 8:49
mssqltips.com/sqlservertip/4902/… This may help
– Shaili
Nov 13 '18 at 8:50
T-SQL is not a database, it'a a language. It's used by Sybase and Microsoft SQL Server.
– Zohar Peled
Nov 13 '18 at 9:24
@ZoharPeled Yes I meant SQL Server
– Adam Dominiak
Nov 13 '18 at 9:29
|
show 2 more comments
Which database it is? SQL, Oracle ?
– Shaili
Nov 13 '18 at 8:47
it's a T-SQL database
– Adam Dominiak
Nov 13 '18 at 8:49
mssqltips.com/sqlservertip/4902/… This may help
– Shaili
Nov 13 '18 at 8:50
T-SQL is not a database, it'a a language. It's used by Sybase and Microsoft SQL Server.
– Zohar Peled
Nov 13 '18 at 9:24
@ZoharPeled Yes I meant SQL Server
– Adam Dominiak
Nov 13 '18 at 9:29
Which database it is? SQL, Oracle ?
– Shaili
Nov 13 '18 at 8:47
Which database it is? SQL, Oracle ?
– Shaili
Nov 13 '18 at 8:47
it's a T-SQL database
– Adam Dominiak
Nov 13 '18 at 8:49
it's a T-SQL database
– Adam Dominiak
Nov 13 '18 at 8:49
mssqltips.com/sqlservertip/4902/… This may help
– Shaili
Nov 13 '18 at 8:50
mssqltips.com/sqlservertip/4902/… This may help
– Shaili
Nov 13 '18 at 8:50
T-SQL is not a database, it'a a language. It's used by Sybase and Microsoft SQL Server.
– Zohar Peled
Nov 13 '18 at 9:24
T-SQL is not a database, it'a a language. It's used by Sybase and Microsoft SQL Server.
– Zohar Peled
Nov 13 '18 at 9:24
@ZoharPeled Yes I meant SQL Server
– Adam Dominiak
Nov 13 '18 at 9:29
@ZoharPeled Yes I meant SQL Server
– Adam Dominiak
Nov 13 '18 at 9:29
|
show 2 more comments
1 Answer
1
active
oldest
votes
The easiest was to establish a direct data access from excel to SQL-Server and use Excel's abilities for the graphics.
If you need the data "exported", it is quite easy to get a table as CSV-list. Again this can be opened with Excel directly to do the graphical work there.
Depending on your environment you might think about any reporting tool, obviously the first choice was SSRS or PowerBI, which is part of the box.
You might even use a SELECT * FROM YourTable and just copy-and-paste the full result into Excel.
The main things to think about:
- One-time action or regularly
- Grade of automatism
- Size of data / Count of rows
- Location / Access-rights / Linkability of your systems
- Existing tools
answered Nov 13 '18 at 9:45
ShnugoShnugo
49k72567
It needs to be fully automated. It looks like so: I have a HMI panel. on this panel I choose a custom range of time. Then after I click the raport button it needs to make a select query for me with this custom time range (that's done). Then it would need to make a report with graphs that would look like this: imgur.com/U8rAHg8
– Adam Dominiak
Nov 13 '18 at 9:56
1
@AdamDominiak You cannot expect any copy-and-paste-ready-made-magic-oh-I'm-so-happy solution for this... This depends on so many factors we do not know... If you can establish direct data access from Excel to SQL-Server you will find everything you need. You might even create VBA-enhanced user-forms...
– Shnugo
Nov 13 '18 at 10:03
Sup @AdamDominiak ; look at this url if you need to pass params to sql db. mssqltips.com/sqlservertip/3436/… ; but like Shnugo is saying you need a game plan for questions suggested by him. From what i rem correctly by default you cannot pass params to external data source from excel (we have a lot of views at my previous work). So yes your using excel RAM to filter data (hint: will be slow) . We are here to guide you not do your work for you. :)
– junketsu
Nov 16 '18 at 17:21
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53276860%2fdatabase-to-excel-charts-or-pdf%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The easiest was to establish a direct data access from excel to SQL-Server and use Excel's abilities for the graphics.
If you need the data "exported", it is quite easy to get a table as CSV-list. Again this can be opened with Excel directly to do the graphical work there.
Depending on your environment you might think about any reporting tool, obviously the first choice was SSRS or PowerBI, which is part of the box.
You might even use a SELECT * FROM YourTable and just copy-and-paste the full result into Excel.
The main things to think about:
- One-time action or regularly
- Grade of automatism
- Size of data / Count of rows
- Location / Access-rights / Linkability of your systems
- Existing tools
answered Nov 13 '18 at 9:45
ShnugoShnugo
49k72567
It needs to be fully automated. It looks like so: I have a HMI panel. on this panel I choose a custom range of time. Then after I click the raport button it needs to make a select query for me with this custom time range (that's done). Then it would need to make a report with graphs that would look like this: imgur.com/U8rAHg8
– Adam Dominiak
Nov 13 '18 at 9:56
1
@AdamDominiak You cannot expect any copy-and-paste-ready-made-magic-oh-I'm-so-happy solution for this... This depends on so many factors we do not know... If you can establish direct data access from Excel to SQL-Server you will find everything you need. You might even create VBA-enhanced user-forms...
– Shnugo
Nov 13 '18 at 10:03
Sup @AdamDominiak ; look at this url if you need to pass params to sql db. mssqltips.com/sqlservertip/3436/… ; but like Shnugo is saying you need a game plan for questions suggested by him. From what i rem correctly by default you cannot pass params to external data source from excel (we have a lot of views at my previous work). So yes your using excel RAM to filter data (hint: will be slow) . We are here to guide you not do your work for you. :)
– junketsu
Nov 16 '18 at 17:21
add a comment |
The easiest was to establish a direct data access from excel to SQL-Server and use Excel's abilities for the graphics.
If you need the data "exported", it is quite easy to get a table as CSV-list. Again this can be opened with Excel directly to do the graphical work there.
Depending on your environment you might think about any reporting tool, obviously the first choice was SSRS or PowerBI, which is part of the box.
You might even use a SELECT * FROM YourTable and just copy-and-paste the full result into Excel.
The main things to think about:
- One-time action or regularly
- Grade of automatism
- Size of data / Count of rows
- Location / Access-rights / Linkability of your systems
- Existing tools
answered Nov 13 '18 at 9:45
ShnugoShnugo
49k72567
It needs to be fully automated. It looks like so: I have a HMI panel. on this panel I choose a custom range of time. Then after I click the raport button it needs to make a select query for me with this custom time range (that's done). Then it would need to make a report with graphs that would look like this: imgur.com/U8rAHg8
– Adam Dominiak
Nov 13 '18 at 9:56
1
@AdamDominiak You cannot expect any copy-and-paste-ready-made-magic-oh-I'm-so-happy solution for this... This depends on so many factors we do not know... If you can establish direct data access from Excel to SQL-Server you will find everything you need. You might even create VBA-enhanced user-forms...
– Shnugo
Nov 13 '18 at 10:03
Sup @AdamDominiak ; look at this url if you need to pass params to sql db. mssqltips.com/sqlservertip/3436/… ; but like Shnugo is saying you need a game plan for questions suggested by him. From what i rem correctly by default you cannot pass params to external data source from excel (we have a lot of views at my previous work). So yes your using excel RAM to filter data (hint: will be slow) . We are here to guide you not do your work for you. :)
– junketsu
Nov 16 '18 at 17:21
add a comment |
The easiest was to establish a direct data access from excel to SQL-Server and use Excel's abilities for the graphics.
If you need the data "exported", it is quite easy to get a table as CSV-list. Again this can be opened with Excel directly to do the graphical work there.
Depending on your environment you might think about any reporting tool, obviously the first choice was SSRS or PowerBI, which is part of the box.
You might even use a SELECT * FROM YourTable and just copy-and-paste the full result into Excel.
The main things to think about:
- One-time action or regularly
- Grade of automatism
- Size of data / Count of rows
- Location / Access-rights / Linkability of your systems
- Existing tools
answered Nov 13 '18 at 9:45
ShnugoShnugo
49k72567
The easiest was to establish a direct data access from excel to SQL-Server and use Excel's abilities for the graphics.
If you need the data "exported", it is quite easy to get a table as CSV-list. Again this can be opened with Excel directly to do the graphical work there.
Depending on your environment you might think about any reporting tool, obviously the first choice was SSRS or PowerBI, which is part of the box.
You might even use a SELECT * FROM YourTable and just copy-and-paste the full result into Excel.
The main things to think about:
- One-time action or regularly
- Grade of automatism
- Size of data / Count of rows
- Location / Access-rights / Linkability of your systems
- Existing tools
answered Nov 13 '18 at 9:45
ShnugoShnugo
49k72567
answered Nov 13 '18 at 9:45
ShnugoShnugo
49k72567
answered Nov 13 '18 at 9:45
ShnugoShnugo
49k72567
answered Nov 13 '18 at 9:45
ShnugoShnugo
49k72567
49k72567
It needs to be fully automated. It looks like so: I have a HMI panel. on this panel I choose a custom range of time. Then after I click the raport button it needs to make a select query for me with this custom time range (that's done). Then it would need to make a report with graphs that would look like this: imgur.com/U8rAHg8
– Adam Dominiak
Nov 13 '18 at 9:56
1
@AdamDominiak You cannot expect any copy-and-paste-ready-made-magic-oh-I'm-so-happy solution for this... This depends on so many factors we do not know... If you can establish direct data access from Excel to SQL-Server you will find everything you need. You might even create VBA-enhanced user-forms...
– Shnugo
Nov 13 '18 at 10:03
Sup @AdamDominiak ; look at this url if you need to pass params to sql db. mssqltips.com/sqlservertip/3436/… ; but like Shnugo is saying you need a game plan for questions suggested by him. From what i rem correctly by default you cannot pass params to external data source from excel (we have a lot of views at my previous work). So yes your using excel RAM to filter data (hint: will be slow) . We are here to guide you not do your work for you. :)
– junketsu
Nov 16 '18 at 17:21
add a comment |
It needs to be fully automated. It looks like so: I have a HMI panel. on this panel I choose a custom range of time. Then after I click the raport button it needs to make a select query for me with this custom time range (that's done). Then it would need to make a report with graphs that would look like this: imgur.com/U8rAHg8
– Adam Dominiak
Nov 13 '18 at 9:56
1
@AdamDominiak You cannot expect any copy-and-paste-ready-made-magic-oh-I'm-so-happy solution for this... This depends on so many factors we do not know... If you can establish direct data access from Excel to SQL-Server you will find everything you need. You might even create VBA-enhanced user-forms...
– Shnugo
Nov 13 '18 at 10:03
Sup @AdamDominiak ; look at this url if you need to pass params to sql db. mssqltips.com/sqlservertip/3436/… ; but like Shnugo is saying you need a game plan for questions suggested by him. From what i rem correctly by default you cannot pass params to external data source from excel (we have a lot of views at my previous work). So yes your using excel RAM to filter data (hint: will be slow) . We are here to guide you not do your work for you. :)
– junketsu
Nov 16 '18 at 17:21
It needs to be fully automated. It looks like so: I have a HMI panel. on this panel I choose a custom range of time. Then after I click the raport button it needs to make a select query for me with this custom time range (that's done). Then it would need to make a report with graphs that would look like this: imgur.com/U8rAHg8
– Adam Dominiak
Nov 13 '18 at 9:56
It needs to be fully automated. It looks like so: I have a HMI panel. on this panel I choose a custom range of time. Then after I click the raport button it needs to make a select query for me with this custom time range (that's done). Then it would need to make a report with graphs that would look like this: imgur.com/U8rAHg8
– Adam Dominiak
Nov 13 '18 at 9:56
1
1
@AdamDominiak You cannot expect any copy-and-paste-ready-made-magic-oh-I'm-so-happy solution for this... This depends on so many factors we do not know... If you can establish direct data access from Excel to SQL-Server you will find everything you need. You might even create VBA-enhanced user-forms...
– Shnugo
Nov 13 '18 at 10:03
@AdamDominiak You cannot expect any copy-and-paste-ready-made-magic-oh-I'm-so-happy solution for this... This depends on so many factors we do not know... If you can establish direct data access from Excel to SQL-Server you will find everything you need. You might even create VBA-enhanced user-forms...
– Shnugo
Nov 13 '18 at 10:03
Sup @AdamDominiak ; look at this url if you need to pass params to sql db. mssqltips.com/sqlservertip/3436/… ; but like Shnugo is saying you need a game plan for questions suggested by him. From what i rem correctly by default you cannot pass params to external data source from excel (we have a lot of views at my previous work). So yes your using excel RAM to filter data (hint: will be slow) . We are here to guide you not do your work for you. :)
– junketsu
Nov 16 '18 at 17:21
Sup @AdamDominiak ; look at this url if you need to pass params to sql db. mssqltips.com/sqlservertip/3436/… ; but like Shnugo is saying you need a game plan for questions suggested by him. From what i rem correctly by default you cannot pass params to external data source from excel (we have a lot of views at my previous work). So yes your using excel RAM to filter data (hint: will be slow) . We are here to guide you not do your work for you. :)
– junketsu
Nov 16 '18 at 17:21
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53276860%2fdatabase-to-excel-charts-or-pdf%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Which database it is? SQL, Oracle ?
– Shaili
Nov 13 '18 at 8:47
it's a T-SQL database
– Adam Dominiak
Nov 13 '18 at 8:49
mssqltips.com/sqlservertip/4902/… This may help
– Shaili
Nov 13 '18 at 8:50
T-SQL is not a database, it'a a language. It's used by Sybase and Microsoft SQL Server.
– Zohar Peled
Nov 13 '18 at 9:24
@ZoharPeled Yes I meant SQL Server
– Adam Dominiak
Nov 13 '18 at 9:29