multiple formulas when suppressing a detail section

I have a report, details a and details b. i need details b to show when a series of formulas are met.

I am having trouble getting this to work:

{loan_main.datepurchased} <> {?Date Purchased} AND not ({loan_query.reivname} like "*wells*")

AND is not performing an AND...

help me please.

thank you :confused::eek: 'AND is not performing an AND...' ?

As you said, you want to show the records when

{loan_main.datepurchased} <> {?Date Purchased} AND not ({loan_query.reivname} like "*wells*")

Right?

I've created a similar formula and it works but in the apposit way: the records which met such a condition are suppressed.
So...... if you want to show those records may be you will change your formula like that:

{loan_main.datepurchased} = {?Date Purchased} AND {loan_query.reivname} like "*wells*" //?

...or correct me if I understood something wrong, please.|||You are correct. I need to show records that meet the criteria, thus i am suppressing records that are on either side.

so, i need to suppress all records

{loan_main.datepurchased} <> {?Date Purchased} AND not ({loan_query.reivname} like "*wells*")

so i would get all loans that are purchased on the date entered upon running the report AND all loans that reivname like wells...

i hope this makes sense.

i am suppressing all the records that do not meet the daily criteria.

thank you|||I've understood what you've written to mean that you want the records with a purchase date of ?DatePurchased, (note the comma) and you want names like wells. i.e. the date is irrelevant for 'wells'.
If so, you want an OR, not an AND.

I find it's easier to write the formula for what records you actually want, and then NOT the whole thing for the suppression formula. e.g.
not( <what you want> )|||I appreciate all help i can get ;)

is it possible to select only the records i want for one section? detail section A is working great, i am having this problem when working with detail section B.

If i can only select records for details section B, i am set...

if not, then besides having two reports, this is it... i think...

i have tried the OR. I need all records that are LIKE 'wells' and date selected is the date purchased.

any help and all help is appreciated.
thank you|||I'm afraid it's still not clear (to me!).

"so i would get all loans that are purchased on the date entered upon running the report AND all loans that reivname like wells..."
The stress on the AND implies to me that you want the union of two sets of data:
1) date entered
2) like wells
i.e. the date is irrelevant for the wells' records, get them all regardless of their date. For non-wells records, base it on the date.

But "I need all records that are LIKE 'wells' and date selected is the date purchased." implies to me that you want
1) date entered and like wells
i.e. only records which satisfy both criteria at once, being wells records for that date.

So which is it?

Maybe you could start at the beginning for us to understand better. e.g. what's in your record selection formula, what you want in detailsA, what you want in detailsB, and whether one record can appear in both detail sections or if they are mutually exclusive.
If mutually exclusive the suppression formulas would be almost the same, e.g. one would be "<formula>" while the other would be "not(<formula>)".|||yes, sorry for the confusion - this report confused me in the beginning too...

I need all records that fit both criteria, datepurchased and like wells.

not one or the other, has to be the date and like wells...

that is why i am trying to use the AND.

hope this makes sense.

thank you...

details A has no formula attached, it shows all records.

thank you|||So I think we've decided that the records you want to show in detailsB are the ones that match both criteria at once :)
The ones you want are therefore:
{loan_main.datepurchased} = {?Date Purchased} AND {loan_query.reivname} like "*wells*"

So the suppression formula is:
NOT (
{loan_main.datepurchased} = {?Date Purchased} AND {loan_query.reivname} like "*wells*"
)

And as someone suggested in a different forum, can either of these fields be NULL?
Also, could 'wells' actually be 'Wells' or 'WELLS' etc.?|||Thank you sooooo much. it worked... :)

i appreciate your help and patience.

thank you sooo much again. it means a lot for the help...|||Glad we got there!

And the reason I always use not(<what I want>) for suppression is because trying to work out the inverse yourself is messy.
e.g. your requirement was effectively "a=x AND b like y"
I believe the logical inverse of that is
not(A<>x OR not(b like y))
which is nearly what you started with, but is nowhere near as easy to understand as what you ended up with.|||I agree. I havent really worked much with crystal, so it is still a learning curve for me... i will deffo use the way you suggested for any future reports.

thank you

Multiple details sections, possible?

In a table the details section is called "table1_Details_Group". Is it possible to add a second details group so that I can have the two groups have different group properties?

I'm trying to avoid creating a second table and using an expression to only show one at a time.

Again Thanks.

possible
poss bile
poss-bile
possibler
possibly
Edit...
Revert to "possbile"

See this tutorial on adding groupings to a report. It uses a table for an example.

http://msdn2.microsoft.com/en-us/library/ms170623.aspx

|||Thanks but the details section of a table seems not to fit the general information you linked to. For instance I can change the name of any group except the details group and the details group is not grouped on any expression.

I don't think I can create a separate details group, something crystal allows, but was hoping there was a trick or process I was missing.

So to be brief, can one table have more than one details group? If so how is the second detail group created?

general
Gretal
generally
Gretel
rural
Edit...
Revert to "gereral"

separate
desperate
separator
serrate
sprat
Edit...
Revert to "seperate"

|||I don't think I am clear on what you mean by details group. A table can have multiple groups and each group will have it's own set of detail rows based on the grouping expression. Can you give me a better idea of what you are trying to accomplish?|||
Create a brand new table. This table will have 3 sections; a header, a details section/group/ and a footer. Right click on the details section and choose edit group. This will bring up the group information for the details section. For example the name of this group will probably be "table1_Details_Group".

I want to have a second details group in the same table which will have different properties from the first. Can I do this?

|||No it isn't possible. How do you want your data to be displayed? Maybe there is another path to the end result you are looking for.|||FYI, you can insert more rows for the detail group. These have their own properties but they aren't the same as a group. I don't know what particular group properties you are looking for.|||thanks.

Multiple Details In Crystal Report

Hi, I want to create a report which will have two details section in a master section . And I dont want to use subreport. The out put should look like this

MASTER ID - 1001

DETAIL - 1
A - 300
B - 200
C - 400

DETAIL - 2
X- 900
Y- 400
Z- 230

. I want the all the records of "DETAIL 1" to appear first and then all the records of "DETAIL 2" to print . How can I do this without using sub reports
Thanks for your help
-FerozIf possible group the report and suppress group header and details|||can you elaborate a little more .
Thanks|||Hi,

Kindly let me know if anybody has got the solution for this problem?

Thanks in advance|||Include both the tables in the report and link them accordingly.

Create a group Master->field and then its all records will be shown in the details section then the next group will come and its all records will be shown.

You can show the groups name in the Group Header and suppress its footer.|||Thanks a lot for your prompt reply.
Let me be a bit more clear about my requirement:

Hi, I want to create a report which will have two details sections ('Details a' and 'Details b') in a single report.

I am having two unrelated tables with multiple rows.

The out put should look like this:

DETAIL - a
A - 300
B - 200
C - 400

DETAIL - b
X- 900
Y- 400
Z- 230

I want the all the records of "DETAIL a" to appear first and then all the records of "DETAIL b" to print. There is no relationship between two tables. How can I do this without using sub reports.

Appreciate your help in advance!!!|||can you post the tables and report ?

Multiple Detail Sections

I have created a report that is using a table with multiple groupings. My
main result set from a stored procedure populates the detail section of the
table. I have a secondary result set that I would like to populate based on a
value from the first result set. For example:
Detail 1 Customer 1
Detail 2 Order 1
Order 2
Order 3
Detail 2 is populated based on the customer id.
How can I accomplish this using the report authoring tool?
Any help would be appreciated.Assuming you are not trying to do a table with groupings, this can be
accomplished with nested "List" items (a list inside of a list) which allow
a free form layout. You just bind each list to the correct dataset for your
detail. See the Sample Reports for an example.
"Scott2624" <Scott2624@.discussions.microsoft.com> wrote in message
news:8411C050-B2FE-48B1-8E26-755220D4FD06@.microsoft.com...
>I have created a report that is using a table with multiple groupings. My
> main result set from a stored procedure populates the detail section of
> the
> table. I have a secondary result set that I would like to populate based
> on a
> value from the first result set. For example:
> Detail 1 Customer 1
> Detail 2 Order 1
> Order 2
> Order 3
> Detail 2 is populated based on the customer id.
> How can I accomplish this using the report authoring tool?
> Any help would be appreciated.
>

multiple columns in details section

I have three fields in my report that make up each record. I would like to display these in detail section.

so instead of

1. alam Dept1 10000
2. khaiser dept2 20000
3. mujeeb dept2 20000

I would have

alam khaiser mujeeb ...
dept1 dept2 dept2 ...
10000 20000 20000 ..Use Crosstab Report|||1. Right-click on the dtails section, to open the Section Expert dialog box.

2. On the 'Sections' list, click the details section.

3. On the 'Common' tab, select 'Format with multiple columns' check box. A new tab called 'Layout' appears.

4. On the 'Layout' tab, specify the formatting for the columns:

Enter the width of the column in the 'Width' box. (you can set the height by dragging the section borders in the Design view of the report)

Enter the space between labels going across the page in the 'Horizontal gap' checkbox.

Enter the space between labels going down the page in the 'Vertical gap' box.

Select the printing direction, 'Across then Down' or 'Down then Across'.

Good Luck|||after using the Scetion expert i got mutliple columns but the sum of salary should be in right side but it is not coming ......

Multiple Column in two pages

I have 20 columns in my report. I want 10 columns in odd pages and 10 columns in the even pages. In the section expert i have two page headers and two details. i used the suppress formula pagenumber mod 2 to find the odd and even pages. My header is displayed correctly but my detail is displaying only the odd pages. Please help me to display the records in the even pages.
thanks...fdd|||Can you post the formula used?|||fdd
What does it mean?|||i don't understand.