Select FirstName + ' ' + LastName, ... from Tbl

quote:

---

Originally posted by harsh_athalye

Be clear about the use of both tools: Crystal and SQL Server

SQL Server is best at retrieving related data in best possible manner and least amount of time whereas Crystal Reports is better at neatly presenting that data.

So, I would suggest you bring all the required values in the query in raw format and then apply whatever formulas you want on them in the Crystal Report. e.g. If you have LastName and FirstName fields in the table, but in the report you want to show as FirstName + ' ' + LastName, Don't use query like this:

Select FirstName + ' ' + LastName, ... from Tbl

Instead bring individual fields and then write formula in Crystal to concatenate them.

Harsh Athalye
India.
"Nothing is Impossible"

---

quote:

---

Originally posted by harsh_athalye

I already explained that!

SQL Server is not very good in terms of speed when it comes to string manipulation...So whenever there are formatting changes or string splitting or concatenation, it's good to do it in front-end. Also, it gives you more flexibility in terms of handling changes.
Suppose in my example, instead of FirstName + ' ' + LastName, you want sequence to be LastName + ' ' + FirstName, you will have to change the query. Whereas, if you just bring in FirstName and LastName as separate fields and then concatenate them in Crystal using formula, you will have to just change formula.

thank u so much.

Anyway, it was just a simple example...you can get into more complex situations than this where implementing those chages at back-end level is simply unacceptable.


Harsh Athalye
India.
"Nothing is Impossible"

---

quote:

---

Originally posted by madhivanan

>> why i should write in formula.

It depends on what you want to do. You should use formulae, if you want to generate

1 Concatenation
2 Running Total
3 Serial No
4 Suppres Duplicate values
5

Madhivanan

Failing to plan is Planning to fail

---

quote:

---

Originally posted by jsmith8858

Simple rule of thumb: Your goal in SQL Server is to generate a concise but complete set of data for your reporting tool to process. You should filter, join, and summarize the data in SQL, and then return those raw results to your reporting tool. Then, your reporting tool can handle additional calculations, formatting, totaling, grouping, and so on.

- Jeff

---

quote:

---

Originally posted by PhoeNIx

quote:

---

Originally posted by harsh_athalye

I already explained that!

SQL Server is not very good in terms of speed when it comes to string manipulation...So whenever there are formatting changes or string splitting or concatenation, it's good to do it in front-end. Also, it gives you more flexibility in terms of handling changes.
Suppose in my example, instead of FirstName + ' ' + LastName, you want sequence to be LastName + ' ' + FirstName, you will have to change the query. Whereas, if you just bring in FirstName and LastName as separate fields and then concatenate them in Crystal using formula, you will have to just change formula.

thank u so much.

Anyway, it was just a simple example...you can get into more complex situations than this where implementing those chages at back-end level is simply unacceptable.


Harsh Athalye
India.
"Nothing is Impossible"

---

---