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 TouchToneTommy 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: *

  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

    Thank you all for your posts, the need for this is to give them the data to populate an excel workbook, from there they already have their charts, graphs and so on. I'm replacing a system and I need to make sure they can still get their data, its a band aid at this point until I can take the...
  4. 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...
  5. cjbrown815

    Crystal does not see datasource

    That worked, thanks LyleU -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 1883-1931
  6. 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//...
  7. 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
  8. 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...
  9. cjbrown815

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

    As an FYI, the cut feature cuts everything, the copy feature only copies the rows that are returned by the filter. Who knew. thanks all for the help as always. Great little community here -CJ SQL2005// CRXIr2// XP Pro "Progress lies not in enhancing what is, but in advancing toward what will...
  10. cjbrown815

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

    Thanks for the reply Skip, All this morning, I dumped the data from crystal reports into the excel workbook, then I started doing the text filter, cut, paste. My boss sat down and "showed me" a way of using the trim function to pull the first few letters from a column into another column, the...
  11. 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...
  12. 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...
  13. cjbrown815

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

    I solved this myself Right click the data point, left click on "series label properties" Enter an expression like =Fields!Result.Value & " " & Fields!SurveyDate.Value -CJ SQL2005// CRXIr2// XP Pro "Progress lies not in enhancing what is, but in advancing toward what will be" -KHALIL GIBRAN...
  14. 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
  15. 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
  16. cjbrown815

    Flip a shape

    I found it, thanks Flip a shape vertically 1.Select the shapes that you want to flip. 2.On the Home tab, in the Arrange group, click Position, point to Rotate Shapes, and select Flip Vertical. Flip a shape horizontally 1.Select the shapes that you want to flip. 2.On the Home tab, in...
  17. 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
  18. 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
  19. 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...
  20. 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

Part and Inventory Search

Back
Top