Hello World!
I have 2 crosstabs on my crystal report. My crosstabs are using only one table. But, I want my second crosstab to retrieve only distinct values. Is this possible? If not, my other option is to create another query (Views) to retrieve only distinct values and call both tables but I don't know how to pass 2 tables to the crystal report. Actually my 1st crosstab works fine but my second crosstab don't show my expected result. I want my 2nd crosstab to get all the sum of the items but the only way to do is to use distinct keyword in my sql statement and it works fine if I create another CR and place my 2nd crosstab there. But my client wants to see them both on a single report.
Please give me an advice on how to do it.
By the way, I'm using SQL Server 2005.
Waiting for your replies. Thanks in advance!
I have 2 crosstabs on my crystal report. My crosstabs are using only one table. But, I want my second crosstab to retrieve only distinct values. Is this possible? If not, my other option is to create another query (Views) to retrieve only distinct values and call both tables but I don't know how to pass 2 tables to the crystal report. Actually my 1st crosstab works fine but my second crosstab don't show my expected result. I want my 2nd crosstab to get all the sum of the items but the only way to do is to use distinct keyword in my sql statement and it works fine if I create another CR and place my 2nd crosstab there. But my client wants to see them both on a single report.
Please give me an advice on how to do it.
By the way, I'm using SQL Server 2005.
Waiting for your replies. Thanks in advance!