Assuming parameters is required, the following 108 results were found.
-
solutions did not answer our questions but did lead us to a workaround. So this is regarding an error when trying to add parameters to a Stored Procedure of an Oracle database from within Microsoft SQL Server Reporting Services. The Error ORA-00911:...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Added parameter: Display submitted by. - Enhancement: Added parameter: Display category. - Enhancement: Reorganized parameters "Module Settings". - Enhancement: Parameters switched from radio to list type. - Enhancement: Aesthetic tweaks for Joomla v3...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
of this article). The end-user must be able to search on EITHER the student's username or the student's ID (2 report parameters: @StudentADAccount [varchar] and @StudentReference [int] respectively). Most of the remaining datasets use the resulting...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
the top)......persondays in values (the number my bosses want - 7h 24m or 26640s is 1 person day)... With date range as parameters...ouch......and it was so easy up to here... Tables of interest StaffActivities...the one users recorded time gets...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
on when using Business Intelligence Development Studio (BIDS) or Report Builder 2.0 and when previewing the report, the parameters are not accounted for (ie. the SQL query creating the dataset does not use the parameters in its query). Problems: Given a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
m_Payload.put("grant_type",v_GrantType); r_AuthToken = invokeurl [ url :v_EndPoint type :POST parameters:m_Payload ]; info r_AuthToken; Once you have a refresh token, it is not necessary to generate another refresh token as it does not expire. You would...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
REST API v2.1 on EU datacenter r_CreateCrmQuote = invokeurl [ url :"https://www.zohoapis.eu/crm/v2.1/Quotes" type :POST parameters:m_Data.toString() connection:"myconnection" ]; or if converted to JSON, the request would read as: { "data": { "Subject":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
select * from ( SELECT TOP 1 c.[Name] AS [ReportName] , e.[ReportID] AS [ReportID] , e.[TimeStart] AS [TimeStamp] , e.[Parameters] AS [Parameters] , e.[ByteCount] AS [Size] , e.[TimeDataRetrieval] AS [Data Retrieval] , e.[TimeProcessing] AS [Process...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Version Platform ChangeLog Options 1.1 - Added parameters: Width, Height - Added parameters: Zoom Level, Heading, Tilt - Added parameters: Marker 1: Latitude, Longitude - Added parameters: Marker 1: HTML to display, Replace Marker Image - Added...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
A quick article on converting a Map (associative array with keys and values) into a URL string to pass as URL parameters. How? Let's first define a map: m_Payload = Map(); m_Payload.put("client_id","my-unique-client-id");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
m_Params.put("scope",r_Api.Scope_s); r_eBayResponse = invokeurl [ url :v_TokenEndpoint type :POST parameters:m_Params headers:m_Headers ]; //info r_eBayResponse; if(!isnull(r_eBayResponse.get("access_token"))) { // info "New Token Generated";...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
I have: // // build up COQL query v_CoqlQuery = "select distinct Currency from Quotes where Subject!=''"; // // build up parameters m_Params = Map(); m_Params.put("select_query",v_CoqlQuery); // // invokeUrl r_Coql = invokeUrl [ url...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
If you ever want to check the parameters submitted with a report for alpha numeric characters (so it doesn't contain symbols, punctuations, etc) then you should do this at the database level, and then get the report to complete the check: The Plan User...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
an SSRS parameter Idem as in just specify a parameter as you would for any usual SSRS report. (Ignore my 2nd and 3rd SSRS parameters in my example as I didn't end up using them) 4. Add a dataset Follow these steps carefully. I've added some screenshot...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Under "Form Properties" > Tick the box under "Validation" for "Custom Validation" to create a function: Ensure you select parameters to input rather than retrieving the record data: I'm calling the Function Name "RejectLeave" then click on Edit Params...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
v_ShopifyApiVersion = r_ShopifyAPI.API_Version; v_AccessToken = r_ShopifyAPI.Access_Token; // // set header parameters m_Header = Map(); m_Header.put("Content-Type","application/json"); m_Header.put("X-Shopify-Access-Token", v_AccessToken); // // set...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
request to chatgpt openai r_ChatGPTResponse = invokeurl [ url :"https://api.openai.com/v1/chat/completions" type :POST parameters:m_Params.toString() headers:m_Header detailed:true ]; if(r_ChatGPTResponse.get("responseCode") == 200) { // // retrieve the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
request to chatgpt openai r_ChatGPTResponse = invokeurl [ url :"https://api.openai.com/v1/chat/completions" type :POST parameters:m_Params.toString() headers:m_Header detailed:true ]; if(r_ChatGPTResponse.get("responseCode") == 200) { // // retrieve the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
r_AddTags = invokeurl [ url :"https://www.zohoapis.com/crm/v7/Deals/" + p_DealID + "/actions/add_tags" type :POST parameters:m_Params.toString() connection:"azcrm" ]; info r_AddTags; } } } /*...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
+ v_ShopifyProductID + "/images.json"; r_UploadPhoto = invokeurl [ url :v_Endpoint type :POST headers:m_Header parameters: m_Params.toString() ]; v_Output = r_UploadPhoto; } return v_Output; } Sends something like the following request (sent using Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *