crystal report is asking for input parameters again when opening.
it's already been supplied. failing randomly once in many hits leading to asking for parameters.
In the SQL query, I could see userid as one of the column in the select statement. In the where condition of the select query, I could just see
conditions related to {ORDERS.ORDERSTATUSID}.
you mentioned as
Then try displaying {ORDERID.userid} and {?userid} in an extra detail line, to see...
I have added a new condition in the crystal report. It is not filtering based on the new criteria but instead filtering with the old criteria.
Record selection formula is as follows:
{ORDERS.SOLDDATE} >= {?from} and {%datepart to} <= {?to}
and {@surveyfee}
and {SALESBRANCHES.BRANCHNAME} =...
table1
orderid
listprice
table2
orderid
listprice
i am left joining table1 with table2 as table2 doesnot
have all the orderids.
i need a formula which adds both the listprices
{table1.listprice}+{table2.listprice} is not giving me
any values as table2 does not have all the orderids as...
For the given table
orderid customer_name
524091 KEITH
560111 JOHN
530076 HORN
804141 ADAM RUSSELL
when I use record sort expert- sort by--> customer_name,
I am getting the output as
530076 HORN
560111 JOHN
524091 KEITH
804141 ADAM RUSSELL
Is there anyway I can get the output as...
I have a report with
pageheader
groupheadersection1
details
groupfootersection1
report footer
page footer
groupheader is grouping by branchname
when i run the report, I could see the results of one
branch followed by the other branch.
user wants the results of one branch per page.
for now,it...
I have a stacked column chart with sales of every branch. There are about 40 branches, so it's becoming a bit difficult to view when the sales figures are displayed for each branch. Can I split the chart into two pages for better view with figures?
in the front end, user has a dropdown which allows him
to select multiple products,
product
A
B
C
D
E
F
G
and there another dropdown with type1 and type2.
user can select multiple products, lets say user
selected A and B,in the code behind
i am storing it as (A,B) as string.
now i have to...
I have added a stored procedure to the tables of the
crystal report.
it was working fine.now when i try to run the same report
it is showing
'Invalid Argument provided.
Failed to open a rowset.
Error in File ...rpt
invalid argument for database
when i removed the stored procedure, it's...
jobnumber orderid customername telephone area A B C D
ABC 100 X 000 UK 4 2
DEF 101 Y 001 FR 2 4
GHI 102 Z 002 USA 1 5
can we make crosstab as part of the report?
cross tab on its own is working fine
when the row is taken as orders.orderid and the column as product.product
I just need the column part from the crosstab and is to be displayed along with other
columns belonging to other tables.
sample table format is like this
jobnumber orderid customername...
orders table:
orderid product quantity trantimestamp
100 A 1 01/01/2001
100 B 2 02/02/2001
101 A 2 01/03/2001
100 A 3 01/02/2001
101 C 4 03/02/2001
102 A 1 04/02/2001
102 D 5...
I didn't understand by "BCCombined" , there is no column as B and C in table2, but I should get the quantity correspoinding to that product row for that orderid.
output should be like this with the consideration of table2:
100 1 3
101 1 1
And I cannot insert a crosstab as it has some other...
I am trying to explain the earlier and the current situations
Earlier
table1:
orderid A B C Active Customer
100 1 1 2 Y abc
101 1 0 1 Y def
The report is like this:
Orderid A combined({table1.B}+{table1.C})
100 1 3
101 1 1
In the current...
By following this order,
group#1 branch
group#2 id
group#3 type
Is there anyway I can summarize the results obtained into another group underneath as the results are obtained based on orderid individually.
If I can summarize the obtained results, it will solve my purpose.
thanks
yes, the productname which I am trying to test is within each ID
group.
But If I make the group order as
branch
type
ID
Then it is not reflecting anything with changes I need, group header of type has already got a field of distinctcount of orderid.
Group ID is making no difference being in...
Thank you for your time.
In the header section of Group Type, it has distinctcount(orderid) along with some other summary fields.
If I place Group #3 as ID, it is not giving the required results since it has already did the distinctcount of orderid in the previous group itself. Making Group...
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.