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!

Recent content by cjbrown815

  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

Part and Inventory Search

Back
Top