Search results for query: *

Afternoon all, So I started a new job and I am working with PLSQL for the first time in many years. I understand basic SQL calls, select statements ETC. I am currently trying to adjust a package which I inherited from the previous admin. At a basic level, when the script sees a well that it...

Hi all, Not a programmer but am getting the "circular reference error" on a spreadsheet that I inherited. I am running the macro our former employee created, and I am getting: "RunTime error 2147467259 (80004005)': Circular Reference caused by alias 'Fiscal Year' in query definitions SELECT...

Hi guys, Not a programmer here but I have to work with some VBA script that was legacy from the previous guy. We added a new column, column I time and date field, into the spreadsheet and I made some adjustments but I am still getting a Type Mismatch error in line 405. I think its pretty...

Hey guys, So I have an excel pivot chart, dual axis, one showing average "uptime" percentage, and the other one shows totalcount of sites. I would like to be able to JUST show the number of sites without the bar (so basically just the label). Stuck right now... does anyone have ideas?

Hi all, I hope this is the best place to ask this, so I am working with regular old Microsoft Excel/ Office Professional 2010. So I have a regular old pivot table, and I have set the options to show "No Data" rather than the dreaded #DIV/0/. I have another sheet where I do % calculations based...

Afternoon all, Quick question for all those with Access experience: We have a 2010 access database that resides on one of our servers on our network. Our techs travel quite a bit and do not alway have internet access at the sites they travel to. They usually make updates when they return...

Hi All, Looking for a formula to turn this: 4 hours 38 minutes 14 seconds into seconds in excel? Anyone?

Hi, I have a fairly simple straightforward question: - I have about 200 forms in excel. - I have three cells in each workbook (same position in each spreadsheet) which I would like to combine into a "Summary" sheet in a separate workbook - Cells are "Time In", "Time Out" and "Driving Time"...

Hi all, CR 11, Oracle backend. I am posting a crystal report to the web by way of the crystal report add in in .net. Curious if there is a way to hard code in the password for the report so the people viewing the website dont have to type it in. Any ideas are appreciated!

Hello all, CR XI, Oracle backend. I am pulling a very simple query out of an oracle database to show time V production numbers. I am creating a simple line chart out of the data. I would like to show our "planned" numbers Vs our actuals. The problem is the Planned is not contained in a...

Hello All, CR 11/ Oracle backend This should be fairly straightforward, but I am at a loss yet again this AM. I am creating a report that is basically dealing with two fields. - Field 1 contains the meter name - Field 2 contains the amount of flow through the meter The grand total of all...

Hello, I am running Crystal XI, with a oracle 8 backend. I would like to display a crystal reports chart onto a regular HTML page on our company intranet. Does anyone know how I would go about doing this? I have heard .net or XML. Anyone familiar with this concept? Thx

Hi All, I am using a product called P2000 by PegaSys (its a security/badging software) It integrates Crystal 9 with a SQL server backend for its reporting solutions. I am wondering the following: In the reports I build with Paramaters, I use a column of data in the database to populate the...

Hello, Crystal XI SQL Server backend This SHOULD be simple, but I have spent way too much time trying to figure it out. - I have a chart in which the results per group can vary from 1 all the way up to 2500. - If I set the chart to Autoscale, when the number is 1 or 2, then the chart shows...

Good morning, I am trying to figure out how to show a chart using only whole numbers on the y axis. The chart is showing a count of instances on the Y axis, and the year on the x axis. My data has various ranges for different groups, but whenever the count is less than 5, it will split up the...

Hello All, Just had a quick question... does anyone know how to set a chart to only show whole numbers on the x axis? Should be simple, but my reptilian brain can't seem to figure it out :) Thanks in advance!

Hello all, Quick access question.... I have a form in Access 2003. On the bottom I have a series of tabbed panels. I want to say that if this particular field is equal to "KPI" that the SECOND tab will be in focus... and if not then the other tab will be in focus. Any idea how to do this?

Hello all, Quick access question.... I have a form in Access 2003. On the bottom I have a series of tabbed panels. I want to say that if this particular field is equal to "KPI" that the SECOND tab will be in focus... and if not then the other tab will be in focus. Any idea how to do...

Hey all, Just doing a quick report here at work and had a few questions that someone who knows more than I can probally answer rather quickly.... Here they are in a nutshell: - Server requirements (hardware/software required to run the product…itemize for each version [2003 & 2007]) -...

Is there a built in function to calculate the # of business days in CR X1? Just curious... thanks!