Solved

Cross Tab Crystal Report 2008

Posted on 2009-04-14
3
504 Views
Last Modified: 2013-12-08
Title:
Cross-Tab Crystal Reports 2008Bookmark:Question:
I'm designing a report using Cross-Tab Expert in crystal reports  2008 and I m not finding the solution to leave those values always in the report.

the database field is, oitm.U_size and contains these values,

xs - s - m - l - xl - 99 - 31 - 32 - 33 - 34 - 36 -38 - 40 -42

I'm making an order report where shows me the order with sizes and colors but there are orders where the report doesn't show me all the sizes. I want to view all the sizes even though they weren't ordered.
there is formula to make it a fixed value on the report?
0
Comment
Question by:TonySUP07
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 15

Expert Comment

by:rob_farley
ID: 24144361
How about changing your query, a bit like this:

SELECT sizes.U_size, q..... /* Everything from q except U_size */
FROM
(
SELECT DISTINCT U_size
FROM ...
) as sizes
LEFT JOIN
(
SELECT .... /* Your current query */
) as q
ON q.U_size = sizes.U_size
;

This way, your results will contain every size value, even if there were no records for them in you particular report.

Rob
0
 

Author Comment

by:TonySUP07
ID: 24153523
There is another way because if i use a query in the report will take a long time to refresh.
0
 
LVL 15

Accepted Solution

by:
rob_farley earned 500 total points
ID: 24153698
Surely your report uses a query to get its data?

I'm not a big Crystal user, but if your data set doesn't contain all the different sizes, it's going to have a hard time trying to guess what other ones it should be displaying.

Rob
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
Let’s face it: one of the reasons your organization chose a SaaS solution (whether Microsoft Dynamics 365, Netsuite or SAP) is that it is subscription-based. The upkeep is done. Or so you think.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question