Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gagani

    asking for input parameters after supplied

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

    record selection formula is not picking up the newly added condition

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

    record selection formula is not picking up the newly added condition

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

    record selection formula is not picking up the newly added condition

    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} =...
  5. gagani

    replacing null with 0 currency in the formula

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

    order by

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

    group header

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

    stacked column char to be split into two pages

    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?
  9. gagani

    formula field

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

    invalid argument for database

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

    crosstab

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

    crosstab

    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?
  13. gagani

    crosstab

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

    crosstab

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

    crosstab

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

    same result with table change

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

    same result with table change

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

    selection of multiple products

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

    selection of multiple products

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

    selection of multiple products

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

Part and Inventory Search

Back
Top