Search:
Type: Posts; User: jade1977
Search:
Search took 0.03 seconds.
-
June 29th, 2010, 04:52 AM
I'm sorry I miss understood! I do that a lot since I read these in the morning. I honestly cannot think of a way to do that, unless you have the same information twice, once on a hidden line, with...
-
June 26th, 2010, 09:30 AM
I'm just checking... you do have Adobe installed, right? Some times its the simplest errors that drive me the craziest!
-
June 26th, 2010, 09:28 AM
If I'm following you... yes it is possible. I have a similar report which shows dates and a total amount on one line, when you click on the date (or amount) it drills down to show each amount broken...
-
June 22nd, 2010, 05:20 AM
Sounds like you need to use a running total, and in the condition field place the (Currentdate - {TranDate}) >= 180
-
Try placing a space between the " ". Don't know why that works sometimes for me, but I suspect that is because our database was not very well designed, and users would use a space to delete data.
-
You only use the select formula, no if statements needed. Also you will get two Cs in the report because the formula is going to show for every record. Maybe you need to place the formula in a group...
-
Try
{records.entrance_date} in {?entrance_date} to {?entrance_date2}
-
First off, it is THEN not THAN.
To find the sum of field 2 you'll need to create a running total, and then use that if field 1=c.
Finally, I would think a select statement would work better here....
-
I think what you want is to break this into two formulas.
shared numbervar v1;
f1 = x1 * y1 / z3;
v1:=v1+f1;
f1
-
What I think is happening is that on one report the field is a datetime and on the other it is a date. If you make them both the same type, you'll then see the field listed in the Select data based...
-
Just use a cross tab report. For the columns you will need to change the results of the parameters to formulas I believe, but then it should give you what you need.
-
April 29th, 2010, 05:36 AM
If you first create a subreport, just to build the array from that table, then pass the shared variable to the main report it can be done.
-
April 29th, 2010, 05:35 AM
Without knowing the particulars of your report, I don't think anyone can truly help you.
I'm not sure what you mean by being at the mercy of the database. The report can only gather information...
-
April 21st, 2010, 07:46 AM
Make the field in a subreport a formula using a shared variable. On the main report also place that same shared formula.. so
Subreport
shared variableName = {field.name}
Main Report
-
April 21st, 2010, 07:41 AM
Did you try changing the table join from an Inner Join to either a Left Outter or Right Outter Join?
-
April 21st, 2010, 05:22 AM
First of all, replace your + with &. From what I remember from classes, + should really only be used in mathematical formulas and the & should be used for concatenations.
Now, in the subreport...
-
April 21st, 2010, 05:18 AM
I believe the only way to output data horizontally is with a cross tab table.
-
April 16th, 2010, 04:41 AM
I'm not even sure if I'm following you question, but I don't think you can do what you want to do.
-
April 13th, 2010, 05:15 AM
The only way to do it is with cross tabs. If you look around in the Cross Tab Expert, on the last tab (sorry, I can't remember the name right now), there is an option to suppress Row Total or Column...
-
April 9th, 2010, 10:44 AM
Group the report Client.
Create a running total.
Field to summarize: the date field
Type of Summary: Maximum
Evaluate: Use a formula {type.field}="Transfer"
On change of group.
I believe...
-
April 9th, 2010, 07:14 AM
It depends on what version of Crystal Reports you have.
-
April 2nd, 2010, 06:00 AM
Now I think I'm following. I don't know if this can be done, at least not directly in CR. Maybe using VB or something else, but I can't help you there, sorry.
-
April 1st, 2010, 07:43 AM
That is easy enough. Create your parameter and then in the select expert
{?parameter} = {department.number}
-
April 1st, 2010, 05:55 AM
Need more information about the report to give an answer.
-
April 1st, 2010, 05:54 AM
It's just because your ) is in the wrong place. Try
Trim({Personen.bisB_PersonalNumber}) = ""
And yes, the English version also calls it the details section :)
You could also try
...
|
Click Here to Expand Forum to Full Width
|