Office Software Thread, Excel with SQL Expressions (Possible BIDS Alternative) in Technical; New here so Hi everyone!
Not sure if this is the correct area to post my query as it contains ...
19th February 2014, 09:36 AM #1
19th February 2014, 09:50 AM #2
When you add the link to the SQL database you can input an SQL statement, however I don't "think" it can be multiple ones at the same time. So if you had a connection to the database using say "SELECT * FROM 'STUDENTS' WHERE 'THINGY' = Y" etc, it would only pull the data that the statement relates to, but I'm not sure how that would work with multiple queries, unless you had seperate connections for each one.
(That is if I understood what you want correctly?)
19th February 2014, 10:01 AM #3
- Rep Power
Ha yer kinda tricky to explain the report we use to manually note down the rows and manually count the number of Y's present in a field related to that one employee is all part of one single report that uses SQL (the SQL is generated by the software via changes made in an easy to use user interface..ya know drag and drop change parameters..a bit like the SQL Builder in BIDS where the SQL is built for u).
The Report itself is a report specific to the program we are using ..it is NOT an .RDL therefore i "think" and im not expert quite a newbie tbh but i like to think i learn fast as i only just built my first report in BIDS a few days ago.. I might have to build the report in BIDS so its seen as an .RDL file that i could perhaps link to the excel form (if possible) then use expressions in excel to read from the report ive linked to count the number of rows and count the number of letters etc.
Seems to make sense to me.. but its all a matter of whether that's possible.. to actually link a specific report/rdl to an excel document and then use expressions in excel to count rows and letters generated by the report and place the data gathered by the expressions in individual cells. (Like i said id be using the same expressions for the exact same fields just changing the employee who im looking at in that particular cell.
Im a newbie though so what do i know hey haha
Last edited by Jbone; 19th February 2014 at 10:05 AM.
By sidewinder in forum Windows
Last Post: 17th July 2011, 01:42 AM
By interele in forum MIS Systems
Last Post: 2nd February 2008, 05:43 PM
By WithoutMotive in forum MIS Systems
Last Post: 17th January 2008, 09:55 AM
By hayjo86 in forum MIS Systems
Last Post: 20th December 2007, 10:34 AM
By dhicks in forum MIS Systems
Last Post: 14th December 2007, 09:05 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)