Sitemap

Amicuk Programming Answers

"Optional" Paremeter/Prompts in report selection.

2015-10-11   Views:1

Advertisement

Post Author: heathdallison CA Forum: Crystal Reports I've been going through the forum looking for someone who has solved my particular problem but I haven't found it. I'm using crystal server XI and crystal reports design tool. I have a report that

Post Author: heathdallison
CA Forum: Crystal Reports
I've been going through the forum looking for someone who has solved my particular problem but I haven't found it. I'm using crystal server XI and crystal reports design tool. I have a report that lists employees who logged in between given dates. So the report has three prompts: start dateend date employee ID.The problem is that the client might want to search for all employees between datesone employee between datesone employee all dates I've tried setting the default values to "" for these prompts and then use an if statement in the select to conditionally determine the use of select criteria as in the following example:(if {?Flight Number} <> "" then ({Flights.FlightNum} = {?Flight Number})) But regardless of whether or not the default value is passed or a flight number is passed the report will run the "then" portion of the if statement. As a result i will always get zero records returned if I don't supply one of the prompt values and allow it to run with the default "" value.  

The replay answer
Advertisement
Post Author: mkotza
CA Forum: Crystal Reports
There is a sample report done in Crystal 8.5 that allows an "All" parameter and the parameters are set up as string types, even the dates.  Link to this sample reports site and download the .zip file. The .rpt that shows this technique is called Allorspecificparameters.rpt. All the sample reports are very good tools to learn from! The site is http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do?cmd=displayKC&docType=kc&externalId=http--supportbusinessobjectscom-communityCS-FilesandUpdatesNoNav-crparameterssampleszipasp&sliceId=&dialogID=6396253&stateId=1%200%206394227
If the link is too long, you might try going to the http://technicalsupport.businessobjects.com and search for "sample reports" and "parameters". Hope this helps!
Minna

Go to See the other 4 answers

"Optional" Paremeter/Prompts in report selection.

Category:DefaultRelease time:2015-10-11Views:130

Post Author: heathdallison CA Forum: Crystal Reports I've been going through the forum looking for someone who has solved my particular problem but I haven't found it. I'm using crystal server XI and crystal reports design tool. I have a report that[More]

Report select options similar to Query output options : Urgent !!!!!

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I have developed a custom report . The output options of this report needs to be included in Selection screen like in SQ01 queries, there should be option to output the report results in different formats like List Viewer, ABAP List, Spread S[More]

Select Options use in ALV Report in ABAP Webdynpro

Category:DefaultRelease time:2015-10-11Views:130

Hello Experts, I Already Done ALV Report In webdynpro with use of view Container UI element.But i do not know ALV  report with help of select option.so Kindly Give Me simple Example of Use in select Option In ALV. Reply ASAP. Regards, Ameya Karadkhed[More]

CR 2008 - Optional parameter prompts

Category:DefaultRelease time:2015-10-11Views:130

Hi! I sometimes use Optional parameter prompts in Crystal Reports 2008. The main reason is to minimise user input in Selection Criteria Screen. I have many subreports, and not all prompts are needed for all subreports. If the user leaves the prompt b[More]

PS report: multible selection for report selection criteria

Category:DefaultRelease time:2015-10-11Views:130

Is there a possibility to define multible selections in the report selection variables of a PS hierarchy report? I tried to define them via CJE6 -> EDIT -> General data selction and entered valiables in the FROM column and the TO column. But when I[More]

Prompt to Report navigation - OBIEE 11g

Category:DefaultRelease time:2015-10-11Views:130

Hello, I've three tables (3 different requests) to be displayed in a page. Each of these tables has one identical column eg. project_name (but from different database tables). My requirement : 1.I should have only one prompt to select the project_nam[More]

Dynamic Action based on Interactive Report Select List Value

Category:DefaultRelease time:2015-10-11Views:130

I'd like to perform a Dynamic Action when a user selects one of 3 options from a Select List within an Interactive Report: select APEX_ITEM.SELECT_LIST( p_idx => 3, --p_value         =>   deptno, p_list_values => 'Copy;Copy,Delete;Delete,Export t[More]

Using @Prompt in the SELECT clause (?)

Category:DefaultRelease time:2015-10-11Views:130

Post Author: faltinowski CA Forum: Semantic Layer and Data Connectivity Product:  Business Objects Version:  6.5 SP3  Patches Applied:  MHF11 and CHF48 Operating System(s):  Windows Database(s):  Oracle Error Messages:  "Parse failed: Exception: DBD,[More]

Hot
Hi there I have recently bought an iphone 5 and I would like to update my Contacts to the iphone 5 from my Windows PC. There in the Contacts folder under my user account in VCARD format, I tried doing it with iTunes, while changing it in the Info tab [More]
I got a 3rd gen itouch. Is there any software that helps to convert the video files. so I can sync those files to my itouch. " Handbrake " used to work pretty good. but now i still can convert the video files to m4v format but itunes doesn't all [More]
not syncing to itunes. Iphone 4 or Ipodtry signing out of icloud and then back on, if your using icloud. Or better yet, put your wife new id on her icloud account.Read other 2 answers [More]
My Adobe has stopped allowing me to move library books from my PC to my KOBO (both show authorized on the ADE. the message reads : CE_COPY_NOT_ALLOWED - No permission to copy book.  It used to work. Any easy fixed for me?(I already tried uninstall an [More]
Hi, I bought a new Android tablet last week: ASUS transformer tf03CX. It seemed to work just fine until I tried to start Skype and tapped the Skype icon. After a few seconds it said: Installation interrupted (OK / Send information). No matter which o [More]
We have QIP 7216 dvr and western digital 1T eSata drive (I can't quickly find the model number but it was one on the Verizon recommended list). The eSata is about 50 percent full. Some of the shows we recorded we can't seem to play. When we click on [More]
I upgraded to firefox 4 and that started since then when i happen to have 2 window open and i close 1 the other main one i have open with tabs ask me if i was sure i want to quit it too and it asks 2 timesStart Firefox in <u>[[Safe Mode]]</u> [More]
Hi, I have a custom .terminal file that opens a terminal window to a specific number of columns and rows, and runs a command. Although I can cause plain ol' Terminal to open at the top left of the screen by moving it there, then closing it, my custom [More]
My apple ID account doesn't work on my itunes but it does on the web. Could this be because I sync my music instead of buy it?No idea what  "My apple ID account doesn't work on my itunes but it does on the web" means. Please explainRead other 2 [More]
Hi, multiple ipod touchs in my house so the kids want their own Facetime accounts.  If I get them apple ID's then I can't manage them on one itunes account. What do you recommend?Have a look here... http://macmost.com/setting-up-multiple-ios-devices- [More]