Search results for query: *

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.

I have tried breaking up into separate commands but still giving the same results. I need the results exclusive to one user not for all the users

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...

Thank you. I am getting the results in the following way : 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 As there are...

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...

can we insert crosstab as part of the report as there are some other columns belonging to other tables?

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...