Search results for query: *

Hello, Has anyone experience any issues with leading comments in a command within Crystal reports 2013. If the comments are in the middle or end it works too. It only errors out when you are connecting from a 12c client to any other version using an ODBC connection. When we use Oracle server...

Hello, I am scheduling a monthly ETL on the 5th and 20th. The begin date should always be the first day of the previous month if the ETL runs on the 5th The End Date should always be t-1 The begin date for the ETL that runs on the 20th should always be the 1st of that month. Example ETL Run...

Hello, Is it possible to use the query builder to find all reports that ran on a certain server? thanks for your help!

Hello, I was wondering if anyone could tell me if there is a way to find Crystal reports that runs longer than 2 hours from the query builder? Thank you, Sara

Hello, I am having an issue with a cross tab using a formula {username} +"-"+ totext(Minimum({date})). I realize the reason why I am having this issue is because I have Minimum within the formula. Has anyone encounter this issue before? Can someone help me with a solution? I am using 2008

I am trying to supress the rows that does not display each day of 5 days. My lay it is. Record selection {CKPT_SEND_TO_CACHE} in currentdate to currentdate-6 and {@Time} in Time (2, 00, 00) to Time (2, 30, 00) Group 1: Table Name Details: {INITIALIZE_TIME} {CKPT_DEPENDENCY_CHK} {@Date Diff}...

I need to create a query that has a date range with a certain time. Example, 03/01 2:30 03/02 2:30 03/03 2:30 03/04 2:30 The results the date range will display different dates but with a set time. Please let me know if this makes sense

How does BOE determine what server to run reports on? I have about 20 reports running right now and they are all running on one server (and hitting it really hard). Is there any kind of load balancing that occurs when running reports? I assumed there was but that is not what is happening right...

Hello, I was wondering if anyone can tell me where I can find the name of the database that BO/ CMC is on? I inherited BO with no info so I have no clue which database BO is on.

Hello, I was wondering is there a way to subtract a date+time from to columns and have the results in seconds? Example; F2 I2 J2 Oct 8, 2012 4:17 PM Oct 15, 2012 1:04 PM Results in seconds I am using excel 2007 above...

Hello, I am having a hard time finding a code to only give me the first letter of the first 3 words even if there is more then 3 words and to include this - as a space. e.i. Consult-Archive LV = CAL Ambulance Rec-scanned LV = ARS eDetailed Pt Charting LV = ePC Here is the code...

Hello I just created a procedure but its not working. I was wondering if I had to execute it? here is the code CREATE OR REPLACE PROCEDURE CR_TDL_CONV ( POST_DT IN DATE ) IS /* variable declarations based on their associated column counterparts*/ KCOL_NAME...

Hello, I am creating a Procudure to move data from a current table to a new table. Right now I am test and I was wondering is there a way I can move just a few lines to test instead of the whole table? Thanks,

Hello, I am very very new to BO and I am trying to create a file with a list of recurring schedule reports by users. Currently I am doing everything manually and I search through the SAPs website and I found out that you can export a list of reports by user but you would need a Author Column...

Hello, Is it posible to create a last full Month function in Sql? If so can someone please help me? Here is the code that I am trying to make into a function add_months((last_day(sysdate))+1,-2) AND add_months((last_day(sysdate)),-1) Thank You!

Hello, I am having issues with a sub-report. My main report looks like this: GH#1a: Group#1 Name (Visit Provider) GH#1b:(Name)(MRN)(ApptTime)(CompletedAppt)(Canceled)(NoShow)(LWOBS) (Those are just field headers) GH#2: (Supress)...

Hello, I am trying to see only the customers that are being helped at the same time with the same person. I am not sure if how I can do this in crystal. so if {customers} has the same {Sales person} at the same {Time} Then I want them to show up. I hope this makes sense.

Hello, I am trying to get data from 12am to 12:59am from the pervoius week. I am able to get last week but not the time. Can someone help me?

Hello, I have 3 groups G-1=Department G-2=Pat G-3=Order On group one I need to display how many pats and orders are in that dep. I am running into an issue with the orders, it is counting the dups for the orders by pat. How can i have it where it only counts the distinct orders by pat? I...

Hello, I am doing a flat file and when I export the report to text the rows are cut off. Does anyone know how I can unwrapped these rows in crystal?