Search results for query: *

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/...

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...

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...

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...

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

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//...

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

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...

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...

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...

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...

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...

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...

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

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

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...

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

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

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...

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