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

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

I have a order_product table like this: orderid productid productname 100 1 A 100 2 B 100 3 C 101 1 A 102 3 C In the front end,user has a dropdown which has got product names. It's ok when user makes single selection (like A...

for a given fromdate and todate, i want the starting from 1st of january of that year to {?todate}, so i wrote if {table.date} in date(year({?FromDate}),1,1) to {?ToDate} then {table2.IDS} else tonumber({@null}) its working for some report but not for giving the right results for others...

In the crystal report, I have added a command which extracts rows from a table of another server through openquery select *from openquery(lnkserver,'select ltrim(rtrim(a.firstname))+'' ''+ltrim(rtrim(a.lastname)) as name from table a where a.date>={?fromdate} and a.date<={?todate} ') It is not...

I want to add tables in two different servers. Could anyone please let me know how to add second server so that the tables of it can be linked with the tables of first server.

I added a new command to the report. It's working fine when I write solddate>={?FromDate} and solddate<={?ToDate} in the query. But when I write, solddate>=date(year({?FromDate}),1,1) and solddate<={?ToDate} it's throwing an error: microsoft oledb provider for sql, date is not a recognized...

I have created some formulas based on the values returned from subreports and group counts and grand total counts of main report. When I used those formulas in page header and run the report, the first page is loaded fine. And when I try to view the second or last page, it is trying to load...

I have a group header and details. I could see headings in the first page itself. How do I get the headings in every page of the report? thanks

I have joined some tables with orderid as the common element in them and I filtered my report based on the condition of cancellation of orderstatus in 'order' table. There is another table called 'persons' with personid and orderid. I am in need of the total count of personids. If I join...

My crystal report has 3 parameter fields(branchname, fromdate, todate). it gives the orders sold between two dates for a particular branch. I am trying to create a formula field on the same report which does the count of orderids sold between two dates but for all branches. count(orderid) gives...