I have a set of data that looks like:
ID Location
----------------
1 1
1 2
1 5
1 6
1 9
2 2
2 5
2 3
2 9
3 5
3 8
3 10
I obtain this data doing a
SELECT DISTINCT ID, Location FROM tblBooks
Now I want to create a view, that will...
I need to sort an array that contains multiple objects. I need to first sort it by Rank, then by Last name.
Ex
Array[0].rank = 3 Array[0].name = Jones
Array[1].rank = 2 Array[1].name = Adams
Array[2].rank = 3 Array[2].name = Scott
Array[3].rank = 1 Array[3].name = Murphy
Array[4].rank = 3...
Example Data:
Record 1- Class: CS Attendence: Steve Test: C++
Record 2- Class: CS Attendence: Joe Test: C++
Record 3- Class: CS Attendence: Mary Test: Java
Output:
Class: CS
Attendees: Steve
Joe
Mary
Test: C++
Java
P.S. I do not have the capability to Show SQL...
Crystal Version - 8.0
Database - ClearQuest MSSQL
Example Data - Field Name Attendence
Expected Output - I want to have a single value that I can insert into the report that contains all of the distinct names for the different attendees
Crystal Version - 8.0
Database - ClearQuest MSSQL
Example Data - Field Names: Class & Attendence & Tests
Expected Output -
Group Header (Class)
Group Header (Attendence)
Details Attendence.Name
Group Footer
Group Header (Tests)
Details Tests.Type
Group Footer
Group Footer
I am unfortunately unable to use sub reports because I am using a trimed down version of cyrstal reports. The version I am using is routed through Rational Clearquest. So I will still need to find another way around this.
I need to join a report field that contains a Memo value.
The field has multiple values that I need to join and I dont want to display them in the Details section.
How can I join them similarly to a ForEach() where I can join all of the Memo values together?
I am layering two different charts one on top of the other, by using the transparent background option for the top chart. How can I align the charts to be the same size in version CR 8.5?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.