Search results for query: *

SSRS 2005 Oracle 10.0 db We have a report that is showing a bar chart that we added custom colors to. It has a category and series group, and when the first bar on the X axis does not have data for all the series, that color for that value does not show in the legend. The label shows in the...

CR 10 We are trying to come up with a temporary reporting solution and have two options for our database, Ms Access or Mysql. This solution would need to work with both Crystal Reports and be deliverable in Crystal Enterprise, as well as MS SQL Server Reporting Services. I know that the Access...

I have finally found a solution after many trials and errors, at least for the oracle connection, I wanted to post it in case it would benefit anyone else. I set the data source as Oracle, put in my connection, then on the datasheet window I put the following in the query window...

Thanks but it didn't work, same error. All the microsoft documentation says that this is supported but I have yet to see an example.

I am getting the following error: An error occured while retrieving the parameters in the query. ORA-00911:invalid character ORA-06512: at "SYS.DBMS_UTILITY",line 114 ORA-06512: at line 1 I have selected stored procedure and typed the following in the command query: STOREDPROCNAME('01-NOV-08')...

SQL Server Business Intelligence Studio 8 Oracle 10 Informix I am a current Crystal user who is getting moved to Sql server reporting. I am testing a few things and having issues connecting to my existing stored procedures that are behind my current Crystal reports. I have some stored...

I am using CR10 with a spreadsheet for the data. My issue is that I am trying to create a dual Y axis chart showing a time field on the left and a % field on the right. I cannot get the time side to work correctly with the chart. The field is pulling in as a date/time and when I add it to...

Thanks so much lbass!!! I knew it had to be simple.

CR10 Excel spreadsheet as the data source I have a cross tab that I have the following code converting a time value to HH:MM: NumberVar totalmins := ({'CIO_Data_'.MEAN} * 60); NumberVar dys := totalmins \ 1440; NumberVar hrs := (totalmins mod 1440)\ 60; numbervar totalhours := hrs + (dys *...

Thanks a lot Ken!! I used that logic and found arrow symbols in wingdings listed on the web, from there I got the numeric codes, then I used the following code: @Arrowfield if {'CIO_Data_'.FLAG} = 0 then "<font face='Symbol' color=yellow>&#222</font>" else if {'CIO_Data_'.FLAG} = 1 then "<font...

I am using CR10 & excel. I have a report that works easily with a cross tab except for one field. They want an indicator, which is an up, down, or across (no change) arrow on the side. I have this stored as a numerical value in the spreadsheet, 0 = no change, 1=up arrow, and 2 = down arrow...

I am using CR10 Oracle 9. The report I am creating is displaying some charts that were created in another application and they are giving them to me in .jpg format. Is there anyway to link this into the report dynamically so that every month when they update the .jpg it will refresh in my...

No, it wasn't, that fixed it! Thanks a lot lbass!!!

I am using oracle 8 and crystal 10. I have the following code in a formula: @description: if {fieldname} like "*>Actions to Avoid Further Outages*" then replace({fieldname},">Actions to Avoid Further Outages", "</br><B>Actions to Avoid Further Outages</B>") else {fieldname}; This worked fine to...

I am using CR10 with an oracle 9 database. I was just tasked with calculating the standard deviation of total resolution time for closed tickets in our system. From there I need to calculate the mean, plot both of those on a chart and then show the monthly average. I know crystal has the...

I just wanted to post that I was able to figure this one out using formulas. I created the following formula: @101test if isnull({Observation.101}) then totext("a") else if {Observation.101} = 0 then totext("b") else if {Observation.101} = 1 then totext("c"); Then I used the original formulas...

I've tried it with the null first and the sum still comes back blank, which in turn makes the final % blank. I am trying to figure out if I can set the null to something else without it being counted in the final calculation. Any other suggestions??

I cannot set the nulls to 0, then it would count them in the final totals, they have to be excluded. I've tried the running totals, the final calculation for the percentage that I need does not show up as a selection to display on the chart.

I am using CR10 and an access database created by users so I am forced to code around the table set up. The users have a questionnaire that they rank each question, either 1, 0, or NA. When the value is NA there is a null in the field in the database. There are 40 different questions that are...

Thanks lbass, I found the problem, user had spelled outages incorrectly, everything works now!