For example, say the table I currently have show the following data:

 

Application                John Doe                             Application

Hardware                 Joe Smith                            Hardware

Multiple                    John Doe                             1:Hardware, 2: Application

 

This is how the data is stored in the datatable itself.

Is there a way I can separate the 'Multiple' one to show individual info in different rows? ideally, the table I need is:

 

 

 

We are using MS SQL server. I am relatively well with sql queries, with the only problem that my department does not have sql express mgmt studio, nor access to modify the database. Basically, we use Remedy Action Request system, which is in a nutshell a more user friendly application that sits on top of ms sql. We connect crystal to remedy to pull data for analysis. My question is, is it possible to do sql commands and such in crystal reports as opposed to creating a table in the database in the format required? I am new to crystal, and with my first take it seems crystal can only do SELECTs and cannot do CREATE commands?

 

 

 

For "multiple" imacts, the greatest number of items for breakdown is less than ten.

 

Thanks,

 

Michael 

 

As a developer, I would really hate for someone to start creating/modifying data in the db for a report...especially someone who doesn't have authorization. On-the-other-hand, if he is creating a temp table in code that is going to disappear or some other structure in the report, I don't care as it should only impact his report, though it may suck up/lock resources on the db and thus drag down system performance...but that is less of a concern than alteration of data / db schema.

 

Actually, all of my reports gather / process their data from stored procs and the parameters are gathered from wizards in our application, so I don't have much need of the Command object, but was just wondering about how much else I don't know about Crystal.