Re: Reporting question
Thanks all! I was aware of the pre built using the advanced query bar. This customer wanted them built directly into the report, and unless it's a crystal or Birt report, that isn't going to happen. a well.. On Tue, Mar 17, 2015 at 2:03 PM, Patrick Zandi remedy...@gmail.com wrote: ** I was looking for that.. myself.. On Tue, Mar 17, 2015 at 2:00 PM, Frank Caruso caruso.fr...@gmail.com wrote: Not sure if this helps but you can create Advanced searches which do prompt for parameters. In the advanced bar you can type the following: 'Submit Date' = $Enter Start Date$ and 'Submit Date' = $End Date$ When you run this a dialog box will appear asking for the dates. After the query is run you can then save the Search. The next time you run it the parameter dialog will appear. HTH Frank Caruso ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years -- Patrick Zandi _ARSlist: Where the Answers Are and have been for 20 years_ -- Warren R. Baltimore II Remedy Developer 410-533-5367 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Reporting question
Warren, Depending on the number of reports and number of variables they want to search by. You can build a display only form to run reports from On the form a field to select (from a menu) pre-defined reports. And Variable fields as need (ie. Start Date, End Date, Assigned To, Category, ect...) Use ALs to display the variable fields needed for the report selected. Users fill in the variable fields and click a Run Report button. Each report has a dedicated AL (Run if Qual) to Open Window (Report) Use the Variable fields to compose the Qualification for the report in the AL. Gregory Givens CTR Pers-54 Remedy Admin -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Warren R. Baltimore II Sent: Tuesday, March 17, 2015 11:15 AM To: arslist@ARSLIST.ORG Subject: Reporting question ** ARS 7.6.04 ITSM 7.6.04 We just moved off of an ARS 6.3 client based installation. I am now getting a ton of questions about reporting. The Mid Tier manuals appendixes infer that you can still build reports with embedded qualifications that use parameters. However whenever I try to do it, I get an error. I'd like to be able to do something like 'Submit Date' = $StartDateHere$ AND 'Submit Date' $EndDate+1Here$. This was never an issue in the client, but now...whoo boy! I've got a helpdesk staffer who is in charge of creating reports that he is sharing with his management, but they hate the fact that they have to run a search, select records, then choose a report. They want to be able to just run the report from the report console and be prompted for the variables. I know it's possible with the BIRT tool, but we're just not there yet. Any help would be appreciated. Warren -- Warren R. Baltimore II Remedy Developer 410-533-5367 _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years smime.p7s Description: S/MIME cryptographic signature
Re: Reporting question
I was looking for that.. myself.. On Tue, Mar 17, 2015 at 2:00 PM, Frank Caruso caruso.fr...@gmail.com wrote: Not sure if this helps but you can create Advanced searches which do prompt for parameters. In the advanced bar you can type the following: 'Submit Date' = $Enter Start Date$ and 'Submit Date' = $End Date$ When you run this a dialog box will appear asking for the dates. After the query is run you can then save the Search. The next time you run it the parameter dialog will appear. HTH Frank Caruso ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Reporting question
Not sure if this helps but you can create Advanced searches which do prompt for parameters. In the advanced bar you can type the following: 'Submit Date' = $Enter Start Date$ and 'Submit Date' = $End Date$ When you run this a dialog box will appear asking for the dates. After the query is run you can then save the Search. The next time you run it the parameter dialog will appear. HTH Frank Caruso ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Requirements Doc
Hi, Tami, et al:: The sample zoo requirements doc also exists in the 8.1.00 online documentation. Search for this EXACT text inside these quotation marks, “An example BMC Remedy AR System application”. Thanks to LJ for originating this topic – as I was trying to find ideas for some new developers as well. I’d be interested in any other mini-requirements docs as well. Michelle From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tami Palacky Sent: Tuesday, March 17, 2015 11:15 AM To: arslist@ARSLIST.ORG Subject: Re: Requirements Doc ** Ben, I would be interested in seeing the document if you dont mind sharing. Thank You On Friday, March 6, 2015 at 12:31:39 PM UTC-5, Ben Cantatore wrote: ** LJ, I'm not sure if this is something you're looking for, but I currently have an enhancement request from one of my users to modify the email function (located under function on left side navigation panel) in tickets to allow for canned messages. Many teams that are fulfilling requests have messages to send formatted in a specific way with a specific message and want to send during the setup/completion of the requests. So the idea would be to create a form where the various teams can add/modify their canned messages and then have it selectable from a menu on the email dialog box. In this example, your junior develop would have to create a form, menu, active links and buttons. I think I recall you have a custom environment so add dialog box and maybe tack on the actual email function if you want to ramp up the difficulty level. [Image removed by sender.] Ben Cantatore Remedy Product Manager Bed Bath Beyond 650 Liberty Avenue Union NJ 07083-8130 Office: (908) 613-5769 Cell: (914) 263-6802 [Image removed by sender. LinkedIn]http://www.linkedin.com/pub/ben-cantatore/3/220/9a7/ From:LJ LongWing lj.lo...@gmail.comjavascript: To:ars...@arslist.orgjavascript:, Date:03/06/2015 09:58 AM Subject:Requirements Doc Sent by:Action Request System discussion list(ARSList) ars...@arslist.orgjavascript: ** All, I'm training up a newbie on Remedy Development, and we have reached the point where I think he's ready for a 'test'I remember going through my 7.x RAC class, and they gave us a small 'requirements doc' for a fairly simple, yet complex enough application that needed to be built...the guys that were in the class with me all built different applications of course, but they all met the application...it was a good exercise and helped hone the blade so to speak on all of our skills...I was wondering if anyone happened to have something like that laying around that I would be able to use It doesn't need to be related to any particular industry, etc...just a couple of pages of requirements for an app that requires a few forms, and some description of functionality, but of course, not how the functionality needs to be built If anyone is willing to send me some stuff, either on or offline, I would appreciate it. _ARSlist: Where the Answers Are and have been for 20 years_ -- CONFIDENTIALITY NOTICE: This e-mail, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain confidential information. If you are not the intended recipient of this e-mail, you are hereby notified that any dissemination, distribution or copying of this e-mail, and any attachments thereto, is strictly prohibited. If you have received this e-mail in error, please permanently delete the original and any copy of any e-mail and any printout thereof. Thank you for your compliance. _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ -- This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Archive/Delete of records in few OTB forms
Hi, I would like to know the importance of below forms. HPD:HelpDesk_AuditLogSystem SLM:AuditLog SLM:Measurement SLM:MilestoneLogging NTE:SYS:NonGroupNumberGenerator HPD:Help Desk Assignment Log We have recently found that DB size is growing and in the above tables, it was found that there are huge number of rows created and Size of these tables are also found to be bigger. Just thinking of Archive-Delete option, would it be impacting anywhere ?? and are there any best ways ..please let me know. Regards Madhu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ITSM Upgrade completed with warnings - In fact failed to upgrade
Hi Aditya, Thank you very much for your reply. Please find my answers below. 1) Which database you have? If you have Oracle, did you check for INVALID objects while installing/upgrading? ANS: Oracle, How do we checked INVALID objects by the below query and it fetched almost 65 entries select object_name,object_type,status from user_objects where status='INVALID'; Any suggestions to correct them is highly appreciated, also I would like to know why they are INVALID. How to troubleshoot that? 2) Hope you must have seen ITSM install log files, but would again suggest you to look through logs and find out which .def failed to import. For ex chg_deplapp.def etc ANS: Fixed all most all the issues that we could see in the logs. The issues which we are seeing now is while importing CHG:ChangeRelationshipinterface form, which doesnot exist in 7.6.03 but seems like newly added in 8.1.02 3) Go through all INC/PBM/CHG and import all the failed def files. ANS: imported all the def files related to INC and PBM only facing issues while importing chg_deplapp.def and especially with CHG:ChangeRelationshipinterface form. 4) If you are facing issues with specific form import also - suggest you to modify them, save changes and again try to import them. ANS: Since we are only facing issues with CHG:ChangeRelationshipinterface form, is that fine modifying that form? My only concern is the above mentioned form does not exist in 7.603. We are upgrading ITSM from 7.6.03 to 8.1.02. Please let me now your thoughts and any suggestions to move forward!! Thanks once again. On Tue, Mar 17, 2015 at 9:07 AM, Aditya Shrivastava iadity...@gmail.com wrote: ** Hi Pavan, 1) Which database you have? If you have Oracle, did you check for INVALID objects while installing/upgrading? 2) Hope you must have seen ITSM install log files, but would again suggest you to look through logs and find out which .def failed to import. For ex chg_deplapp.def etc 3) Go through all INC/PBM/CHG and import all the failed def files. 4) If you are facing issues with specific form import also - suggest you to modify them, save changes and again try to import them. Let us know how it goes. Thanks! Regards, Aditya On Tue, Mar 17, 2015 at 5:59 AM, Nagidi Pavan pavan@gmail.com wrote: ** Hello Experts, Do anyone has any suggestions for me!! On Fri, Mar 13, 2015 at 8:04 PM, Nagidi Pavan pavan@gmail.com wrote: Hi Ken, Thanks for your response. For the form which we are facing the issue, in the Base devleopment mode it shows its overlaid, in the Best Practice Customization mode it shows unmodified. Is this the issue? If so, how to overcome this? On Fri, Mar 13, 2015 at 2:52 AM, Ken Pritchard pri...@ptd.net wrote: ** I’ve seen the unique index error occur when there is a form with and without the __c designation. Seems like the system thinks they are two different forms, but the same form. *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W *Sent:* Thursday, March 12, 2015 2:03 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: ITSM Upgrade completed with warnings - In fact failed to upgrade ** The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552 Sounds like your database had an error with connecting to it. I believe there is an SQL log made during the upgrade. See if it has any more information Look to see what the SQL was doing when you got the The value(s) for this entry violate a unique index that has been defined for this form; , 382 That will tell you which forms tried to create duplicate records Fred *From:* Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] *On Behalf Of *Nagidi Pavan *Sent:* Thursday, March 12, 2015 12:52 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: ITSM Upgrade completed with warnings - In fact failed to upgrade ** Hi William, Firstly, thanks for your response. Below was done prior to ITSM upgrade. 1) We have upgraded AR Server from 7.6.04 to 8.1.02 without any issues. 2) Ran BPCU in overlay mode to preserve our customizations 3) Upgraded Atrium Core successfully from 7.6.03 to 8.1.02 4) Upgraded ITSM from 7.6.03 to 8.1.02 successfully after fixing issues with field mappings using the option Only copy CI attributes from CDM to ITSM Foundation. 5) Restarted upgrade once again with the option Upgrade to 8.1.02 but don not remove CI attributes from CDM. After 13 hours we got the results as BMC Remedy ITSM Suite 8.1.02 install completed with warnings. I believe I am going in the correct direction. Please advise. Thanks Pavan *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Nagidi Pavan *Sent:* Thursday, March 12, 2015 12:14 PM *To:* arslist@ARSLIST.ORG *Subject:* ITSM Upgrade completed with warnings - In fact failed to upgrade **
Re: Time to Install ITSM 8.1.2
i set up and installed on a new server group environment for Windows 2012, SQL 2012R2 and ARS 8.1.02 and did not have any issues on the installs. i would say it took me about 1 day per application server and about an hour or less on the mid-tier servers On Monday, March 9, 2015 at 8:48:05 AM UTC-4, Tanner, Doug wrote: ** Dear List, Looking for some feedback on Installation times for ITSM Suite. I know there are a lot of variables and different system configurations, etc. I installed CMDB, Atrium Integrator and then ITSM (8.1.2) suite over the weekend on a Sandbox. Just trying to gauge if my installation time was typical/average. My Question for the List – *If you have installed ITSM 8.1.2 – How long did the install take?* P.S. Are there any tips/tricks that can reduce the installation time? Thanks in Advance, Doug *|**Doug Tanner **| *Enterprise Workflow Applications *|* *|*Compass Group *| *2400 Yorkmont Rd, Charlotte, NC 28217 *|* *| *(*w*) +1.704.328.3178 *| *(*m*) +1.980.230.8563 *|* *| *www.cgnad.com *|*why Compass? http://www.worldofcompass.com/video/* |* This email is subject to certain disclaimers, which may be reviewed via the following link. http://compass-usa.com/Pages/Disclaimer.aspx. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Service Request Scheduler Design
Hi Chad, We did an application like this several years ago but started it from Asset Management, rather than a Service Request. The application was for managing scheduled and unscheduled asset outages. For each asset or class of assets, the user would specify the frequency and when the asset should come off-line for maintenance, who was responsible for the asset outage, and the template to be used. Frequency could be daily, weekly, semi-monthly, monthly, quarterly or annually. For example, you could say the asset should come off-line the 2nd Sunday of the quarter at 2PM. Then, using the template specified, our ActionProgram Manager Plus would calculate a schedule using the 2nd Sunday of the Quarter at 2PM as the target date. Some tasks in the template need to be performed before the target date and some after the target date. A week before the first task was to be performed, the person responsible would be notified so that he or she could assign people to the tasks. The assignments would be in the person's to-do list / console. The work schedule would be during prime shift but the work could be done at any time. The person would work the task, status the task, enter their time against the task (optionally) and update the related asset record. All of the tasks would be on the relationship tab of the asset record so you could see the work done against the asset. If they were capturing time, the hours could be multiplied by a rate so you could see the labor cost against each asset. This approach gives you a more complete Total Cost of Ownership of each asset. It was very cool. Of course, all of this could be done from a Service Request or Change or some other form. It's a major benefit of being Remedy-based. Please give me a call off-line if you want to talk more about this. Thanks. Stan st...@projectremedies.com w. 310-230-1722. c. 310-428-5748. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Chad Wilhelm Sent: Friday, March 13, 2015 11:33 AM To: arslist@ARSLIST.ORG Subject: Service Request Scheduler Design Happy Friday Everyone, Looking for feedback on a project kicking off soon. Any documentation or examples is welcome as well. Background: This is a non ITSM environment. ARS 7.6.04 We have a requirement to retire a ootb java based application which automates the scheduling of SR's. Basically it creates the SR with fields requester, category, description, etc. SR is a option on the form on the ticket form. The current application design 1. Ability to schedule a starting date. 2. A repeat interval of Hourly, Daily, Weekly, Monthly, Yearly. All of these have options. The days during the week are all (Mon-Sun). Hourly You can specify how many hours the SR is occurs(For example generate every 2 hours) and on what days during the week it is allowed to run. Minimum 1 hr value. Daily You can specify how many days the SR occurs(For example generate every 2 days) and on what days during the week it is allowed to run. Weekly You can specify how many weeks the SR occurs(For example generate every 2 weeks) Monthly You can specify how many months the SR occurs(For example generate every 2 months), on what days during the week it is allowed to run, and what week it is allowed to run (1st,2nd, 3rd, 4th, and Last) Yearly You can specify how many years the SR occurs(For example generate every 2 years) 3. Ending Date You can specify a end date to the schedule, no end date, end after occurrences. 4. Requester Information Nothing out of the ordinary. In experimenting, I was able to calculate the next run time on the options of Weekly and Yearly based upon the SR occurrence. This is based off Starting Date using DATEADD function. I have two fields using this Last Run Date and Next Run Date. I believe in order to correctly process, at least one table will need to be added. Rows in the table will be next run date, last run date, Integer Field to hold day of week using WEEKDAY function. Then walk the table to the next run date check the int value against what is allowed for that day. For the ending date, a counter that would hold occurrences if used to decrement if End After x occurrences was used. End Result would be a push fields to the ticket form. Thanks, Chad Wilhelm ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years - No virus found in this message. Checked by AVG - www.avg.com Version: 2015.0.5751 / Virus Database: 4306/9292 - Release Date: 03/13/15 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Requirements Doc
Ben, I would be interested in seeing the document if you dont mind sharing. Thank You On Friday, March 6, 2015 at 12:31:39 PM UTC-5, Ben Cantatore wrote: ** LJ, I'm not sure if this is something you're looking for, but I currently have an enhancement request from one of my users to modify the email function (located under function on left side navigation panel) in tickets to allow for canned messages. Many teams that are fulfilling requests have messages to send formatted in a specific way with a specific message and want to send during the setup/completion of the requests. So the idea would be to create a form where the various teams can add/modify their canned messages and then have it selectable from a menu on the email dialog box. In this example, your junior develop would have to create a form, menu, active links and buttons. I think I recall you have a custom environment so add dialog box and maybe tack on the actual email function if you want to ramp up the difficulty level. *Ben Cantatore* *Remedy Product Manager* Bed Bath Beyond 650 Liberty Avenue Union NJ 07083-8130 Office: (908) 613-5769 Cell: (914) 263-6802 [image: LinkedIn] http://www.linkedin.com/pub/ben-cantatore/3/220/9a7/ From:LJ LongWing lj.lo...@gmail.com javascript: To:ars...@arslist.org javascript:, Date:03/06/2015 09:58 AM Subject:Requirements Doc Sent by:Action Request System discussion list(ARSList) ars...@arslist.org javascript: -- ** All, I'm training up a newbie on Remedy Development, and we have reached the point where I think he's ready for a 'test'I remember going through my 7.x RAC class, and they gave us a small 'requirements doc' for a fairly simple, yet complex enough application that needed to be built...the guys that were in the class with me all built different applications of course, but they all met the application...it was a good exercise and helped hone the blade so to speak on all of our skills...I was wondering if anyone happened to have something like that laying around that I would be able to use It doesn't need to be related to any particular industry, etc...just a couple of pages of requirements for an app that requires a few forms, and some description of functionality, but of course, not how the functionality needs to be built If anyone is willing to send me some stuff, either on or offline, I would appreciate it. _ARSlist: Where the Answers Are and have been for 20 years_ -- CONFIDENTIALITY NOTICE: This e-mail, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain confidential information. If you are not the intended recipient of this e-mail, you are hereby notified that any dissemination, distribution or copying of this e-mail, and any attachments thereto, is strictly prohibited. If you have received this e-mail in error, please permanently delete the original and any copy of any e-mail and any printout thereof. Thank you for your compliance. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Reporting question
ARS 7.6.04 ITSM 7.6.04 We just moved off of an ARS 6.3 client based installation. I am now getting a ton of questions about reporting. The Mid Tier manuals appendixes infer that you can still build reports with embedded qualifications that use parameters. However whenever I try to do it, I get an error. I'd like to be able to do something like 'Submit Date' = $StartDateHere$ AND 'Submit Date' $EndDate+1Here$. This was never an issue in the client, but now...whoo boy! I've got a helpdesk staffer who is in charge of creating reports that he is sharing with his management, but they hate the fact that they have to run a search, select records, then choose a report. They want to be able to just run the report from the report console and be prompted for the variables. I know it's possible with the BIRT tool, but we're just not there yet. Any help would be appreciated. Warren -- Warren R. Baltimore II Remedy Developer 410-533-5367 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Reporting question
As far as I know and seen, Variables (Popped up) is not possible. the only way is the choose field, =; value in the form under the report console. you can create pre configured reports and put them out there on the console as a menu. There are ways to give them prebuilt Query's in the form as well, which might help. On Tue, Mar 17, 2015 at 12:14 PM, Warren R. Baltimore II warrenbaltim...@gmail.com wrote: ** ARS 7.6.04 ITSM 7.6.04 We just moved off of an ARS 6.3 client based installation. I am now getting a ton of questions about reporting. The Mid Tier manuals appendixes infer that you can still build reports with embedded qualifications that use parameters. However whenever I try to do it, I get an error. I'd like to be able to do something like 'Submit Date' = $StartDateHere$ AND 'Submit Date' $EndDate+1Here$. This was never an issue in the client, but now...whoo boy! I've got a helpdesk staffer who is in charge of creating reports that he is sharing with his management, but they hate the fact that they have to run a search, select records, then choose a report. They want to be able to just run the report from the report console and be prompted for the variables. I know it's possible with the BIRT tool, but we're just not there yet. Any help would be appreciated. Warren -- Warren R. Baltimore II Remedy Developer 410-533-5367 _ARSlist: Where the Answers Are and have been for 20 years_ -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Reporting question
https://www.youtube.com/watch?v=meGxFeH0Kbg On Tue, Mar 17, 2015 at 12:33 PM, Patrick Zandi remedy...@gmail.com wrote: As far as I know and seen, Variables (Popped up) is not possible. the only way is the choose field, =; value in the form under the report console. you can create pre configured reports and put them out there on the console as a menu. There are ways to give them prebuilt Query's in the form as well, which might help. On Tue, Mar 17, 2015 at 12:14 PM, Warren R. Baltimore II warrenbaltim...@gmail.com wrote: ** ARS 7.6.04 ITSM 7.6.04 We just moved off of an ARS 6.3 client based installation. I am now getting a ton of questions about reporting. The Mid Tier manuals appendixes infer that you can still build reports with embedded qualifications that use parameters. However whenever I try to do it, I get an error. I'd like to be able to do something like 'Submit Date' = $StartDateHere$ AND 'Submit Date' $EndDate+1Here$. This was never an issue in the client, but now...whoo boy! I've got a helpdesk staffer who is in charge of creating reports that he is sharing with his management, but they hate the fact that they have to run a search, select records, then choose a report. They want to be able to just run the report from the report console and be prompted for the variables. I know it's possible with the BIRT tool, but we're just not there yet. Any help would be appreciated. Warren -- Warren R. Baltimore II Remedy Developer 410-533-5367 _ARSlist: Where the Answers Are and have been for 20 years_ -- Patrick Zandi -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Reporting question
https://www.youtube.com/watch?v=R3x7yWUN95s On Tue, Mar 17, 2015 at 1:09 PM, Patrick Zandi remedy...@gmail.com wrote: https://www.youtube.com/watch?v=meGxFeH0Kbg On Tue, Mar 17, 2015 at 12:33 PM, Patrick Zandi remedy...@gmail.com wrote: As far as I know and seen, Variables (Popped up) is not possible. the only way is the choose field, =; value in the form under the report console. you can create pre configured reports and put them out there on the console as a menu. There are ways to give them prebuilt Query's in the form as well, which might help. On Tue, Mar 17, 2015 at 12:14 PM, Warren R. Baltimore II warrenbaltim...@gmail.com wrote: ** ARS 7.6.04 ITSM 7.6.04 We just moved off of an ARS 6.3 client based installation. I am now getting a ton of questions about reporting. The Mid Tier manuals appendixes infer that you can still build reports with embedded qualifications that use parameters. However whenever I try to do it, I get an error. I'd like to be able to do something like 'Submit Date' = $StartDateHere$ AND 'Submit Date' $EndDate+1Here$. This was never an issue in the client, but now...whoo boy! I've got a helpdesk staffer who is in charge of creating reports that he is sharing with his management, but they hate the fact that they have to run a search, select records, then choose a report. They want to be able to just run the report from the report console and be prompted for the variables. I know it's possible with the BIRT tool, but we're just not there yet. Any help would be appreciated. Warren -- Warren R. Baltimore II Remedy Developer 410-533-5367 _ARSlist: Where the Answers Are and have been for 20 years_ -- Patrick Zandi -- Patrick Zandi -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years