Assuming specified is required, the following 81 results were found.
-
the Properties panel for this. Under Custom Properties » OpenRowset, you should see the name of the Excel worksheet you specified as the datasource (eg. "Sheet1$"). Using the example above: Sheet1$A11:AL12 Selects all data from column A, row 11 up to...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
param3=@param3): Local Variables Note that we were trying to execute our stored procedure with the parameters specified just after the name of the procedure. The trick is not to use any of these and to use the GUI dialog of the "Dataset Properties" for...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
should be that the Name is the "Label" and ItemID is the "Value", just in case you didn't pick up on this. If no type is specified (type=2) then datasources and folders will also show. The Side-by-Side Table As you know, most datasets will return the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Source Control Explorer and check what it says next to "Local Path" (for me this said the name of the local folder that I specified just before)
- Type: Article
- Author: Joel Lipman
- Category: Team Foundation Server
- Language: *
-
the column name which will contain this value. ** ** ** ** Return Values : Table of three columns: ** ** - myValue: value specified in parameter 1 (matched in database to search) ** ** - myTable: table in which the column occurs ** ** (returned as...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
GROUP BY t1.IP ORDER BY b.user_name ) t2 GROUP BY MONTH(t2.Date); Notes: I use this in a PHP script so where year is specified (2010), I have a variable posted from a HTML form in my PHP. Also note: The association to a user can change because anonymous...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
if you're working on a local report within BIDS connecting to remote servers. If you want the report to be viewable on a specified Reporting Server than you'll need to deploy the report. If you get the following error (like I did) when you view the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
I only know how to do this with a UNION ALL clause. Scenario: I have a Joomla module which should take the keywords from a specified number of different but similar tables. I'm looking to query the Title and the Introductions of any valid articles from...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
though, I wanted the "left" div to take over the whole page if there were no modules positioned in the "right" div. I specified width of left using PHP. This is the CSS though: #container { position: relative; } #content { position: relative; top: 0;...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
to spread gradient backgrounds across a long page. It would appear to be fool proof because of the "background:#f7f7f7" specified at the beginning of the code but it is not. My only solution was to propose to set the background as white (#f7f7f7 - white...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
to the below code but you could get your values from anywhere: On page load, the seconds remaining and elapsed are specified JS then takes over and runs the time var seconds_remaining = ; var seconds_elapsed = ; setInterval('showTime()', 1000); function...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
So the file shouldn't exist if you check after the script has completed. Do the following step to keep the file in a specified folder. 5. Form processing works so now test the actual file upload Add the following code after the above code sample in step...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
stripos($output, '?>') + 2 ); // remove leading spaces, carriage returns $output = trim($output); // process if type specified was xml if($apimo_type=='xml'){ // send header header("Content-Type:text/xml"); // print result to page echo $output; }...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
going to move the Excel file to a folder of its own. We're going to run two VBScripts in two stages, firstly to split the specified rows into sheets, then each sheet into a file each. And we want all the files generated to be created in the same folder....
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
and I myself don't put any copyright information on the end product. I needed a program to: + Group all the data by a specified column + Generate interactive flash charts The program was intended to chart EventViewer "Security" logs but I quickly found...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
a MS SQL Server 2008 instance were dependent on either the server or the client machine. Realised that this was actually specified in the report. Here's a quick note on how to set Dates and Times used in parameter fields to UK format (dd/MM/yyyy). You...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
specify the date as it's a report parameter. What we want The user will select a date. We want the report to open with the specified day expanded and the remaining days that week to be collapsed (hidden). The first time I did this, I couldn't expand the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
the box "Repeat header columns on each page. Situation I have a report which has been set to landscape with zero margins specified. Although BIDS acknowledges that I want this to output to A4 with the correct measurements, the report doesn't seem to...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
BY TABLE_NAME, COLUMN_NAME The following is a MYSQL query that finds all columns that had the data_type TEXT across a specified database (eg. sample_db): SELECT CONCAT(TABLE_NAME, '.', COLUMN_NAME) AS value FROM information_schema.COLUMNS WHERE...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Version Platform ChangeLog Options 1.0 + Group all the data by a specified column + Generate interactive flash charts - Date Uploaded: Wed, 15th Sep 2010 Download
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *