Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: cjbrown815
  • Content: Threads
  • Order by date
  1. cjbrown815

    Excel O365 - Need to separate data in a column into 3 columns

    Hello, I have a spreadsheet that has 3 pieces of data (text)(Sample Type ID, Description, Suite) in column A, I need to separate that data based on row location into separate columns (Column A = Sample Type ID, Column B = Description, Column C = Suite) Sample Type ID/ Description/...
  2. cjbrown815

    Report links extracted for review

    Hello, CRXIr2 (still) Is there a way to extract the report table links within Crystal? We want to review all the report table links, thanks -CJ SQL2014// CR Pro 11.5.0.313// Windows 7 Enterprise "Progress lies not in enhancing what is, but in advancing toward what will be" -KHALIL GIBRAN...
  3. cjbrown815

    Export to excel without excel creating blank rows

    Hello, After much tedious work, I finally have the report exporting to excel without merging the column cells, but I cant get it to not create blank rows between the populated rows. I have the section in the CR report as tight as I can get it to the fields, any ideas on how to solve this one...
  4. cjbrown815

    Crystal does not see datasource

    Hi, I have windows 7 enterprise SP1 64-bit OS, CR Pro 11.5.0.313. I created a data source using ODBC SQL Server driver locally, the reports are on a file share (I have RWE rights). When I open Crystal it does not see the new data source. Any thoughts on what I can try? thanks -CJ SQL2005//...
  5. cjbrown815

    Cannot export to PDF

    I am using CRXIr2 on a Dell Latitude E3440. I have not been able to export to PDF since the new laptop. Any thoughts at what I can look at? thanks -CJ SQL2005// CRXIr2// XP Pro "Progress lies not in enhancing what is, but in advancing toward what will be" -KHALIL GIBRAN 1883-1931
  6. cjbrown815

    Windows 10 updates removed Surface Pro 4 screen auto-rotation

    Hi, Last night I received from updates from MS and they automatically installed on my Surface Pro 4. Now the screen won't auto-rotate and there is no option in the "All Settings" to turn it on or off. Anyone out there have the same problem or a fix or a way to back out the update without loosing...
  7. cjbrown815

    Excel copying all cells instead of just the ones returned from a filter

    Excel 2010, I have a long list of tests, I'm doing a text filter (contains) on a portion of the test name, then I cut the rows that are returned and paste them in another worksheet. All of a sudden, excel is cutting all rows including the ones that are hidden. What changed? How can I get excel...
  8. cjbrown815

    Windows 7 32 bit or 64?

    Hi, We just had 3 PC's donated from a local organization. Now I get to set them up. I cant get passed the admin login account, I've tried everything. I think I need to buy Windows 7 and reinstall the operating system. Windows 7 is currently loaded, but that's all I know. Does it matter as far as...
  9. cjbrown815

    How do you add multiple fields in the data label properties in a line graph?

    VS2008, I have a line graph and I want to add an expression that will display values from two separate fields on the graph next to the data points. Thanks -CJ SQL2005// CRXIr2// XP Pro "Progress lies not in enhancing what is, but in advancing toward what will be" -KHALIL GIBRAN 1883-1931
  10. cjbrown815

    Generate a list of all reports in the source reports folder

    Hello, Is there a way to print/view a list of all reports in the source reports folder through report manager? thanks -CJ SQL2005// CRXIr2// XP Pro "Progress lies not in enhancing what is, but in advancing toward what will be" -KHALIL GIBRAN 1883-1931
  11. cjbrown815

    Flip a shape

    Hi, I'm using Visio 2010. I inserted PC monitor shapes and they are backwards. I know I can rotate the shape, but is there a way to flip them? thanks -CJ SQL2005// CRXIr2// XP Pro "Progress lies not in enhancing what is, but in advancing toward what will be" -KHALIL GIBRAN 1883-1931
  12. cjbrown815

    How do I group a chart to show a chart for each component

    Hi, How do I group a chart to show a line graph for each tank and test? I attached a screenshot because its a lot easier to show than explain. Thanks -CJ SQL2005// CRXIr2// XP Pro "Progress lies not in enhancing what is, but in advancing toward what will be" -KHALIL GIBRAN 1883-1931
  13. cjbrown815

    Line graph from exported data

    I exported data from a crystal report and there are blank cells. the column values are (Production Date, Quality Code, Test, Result. I need to create a line graph that shows the date field in the x-axis. a range for the y-axis (0 - 100)(may change) and the graph body would be the results per...
  14. cjbrown815

    Count total values between -1.00 and 1.00

    Excel 2010- I have 14 columns, each row has 14 values under each column. I need a count of all values that are between -1.00 (negative one) and 1.00 thanks -CJ SQL2005// CRXIr2// XP Pro "Progress lies not in enhancing what is, but in advancing toward what will be" -KHALIL GIBRAN 1883-1931
  15. cjbrown815

    Prompt for the first 5 digits of a 12 digit lot code

    Hello, I'm using CRXIr2. Our lot codes are 12 digits long, the first 5 digits are the YYJJJ (151660108111). I need to setup a prompt that only requires the end user to type the first 5 characters, how can I do this? thanks -CJ SQL2005// CRXIr2// XP Pro "Progress lies not in enhancing what...
  16. cjbrown815

    Conditional formatting for the entire spreadsheet

    Hello, I have an excel 2010 spreadsheet, I need it to highlight all cells in a row red if the column "O" is less then 0 (zero) and green if its equal to or greater than o (zero). This was working, but as new records are added, the conditional formatting doesn't update the new rows. So I need to...
  17. cjbrown815

    Outlook 2010 meeting organizer change

    Hello, I'm handing-off duties to another associate. I have a years worth of meetings in which I am the organizer. I want to change the organizer to the other associate. Is this possible? I have meeting rooms booked and don't want to lose them if I just cancel the meetings. thanks -CJ...
  18. cjbrown815

    Excel 2010 - highlight greater than 40 characters

    Hello, I have a spreadsheet that has a columnB of text. I need to highlight any row with text greater than 40 characters (including spaces). Please help, thanks -CJ SQL2005// CRXIr2// XP Pro "Progress lies not in enhancing what is, but in advancing toward what will be" -KHALIL GIBRAN 1883-1931
  19. cjbrown815

    Excel 2010 - convert <1 to 0 and >xxx to numeric value

    Hello, I have a column that returns results that are numeric, text, string...you name it. I need to create a line graph. If the result is a <1 or <150 or whatever, its a 0. If its a "greater than" (example: >59000, >150, > whatever) I need it to be the numeric value that follows the ">" sign. If...
  20. cjbrown815

    Sorting a legend in a line graph

    Hello, how do I sort the legend in a line graph? I have three charts that are all the same, but from different facilities. I've managed to get the lines the same colors, but the legend is showing different sort for each. All grouping and record sorting is the same on all three. All the "on...

Part and Inventory Search

Back
Top