Search results for query: *

Hi, We are using Crystal Reports v10 with SQL Server 2000. Currently the reports are distributed over the web using a .NET applciation. I am trying to find a way where a user can click on the column header and the results of the report will be sorted by that column. Is there a way to do...

What are your data types for the following? {IV00102.LOCNCODE} {?Location} {IV30300.TRXLOCTN} {IV30300.TRNSTLOC} Kchaudhry

Can you please share the contents of the @name Secondly, why are you doing a sum? From the sample data it seems like you only have one value and you wont really need a sum here. Kchaudhry

Ok, then try something like this. Create a formula and place it in your group footer. @sub if not isnull({table.sub}) then sum({table.account},{table.group}) else 0 Kchaudhry

Create a string parameter that accepts single values, and then use a record selection formula like: {table.field} like "*"+{?parm}+"*" Kchaudhry

In order to check nulls in dates you can use isnull({table.date}) or {table.date} = date(0,0,0) As for sysdate you can use currentdate Kchaudhry

Have you tried adding a group on the main account and doing a sum in the group footer? Kchaudhry

You can use something like this: if {AF_PERIOD_OPERATING_STATEMENT.ACCT_CODE_KEY} <> "5419" and left({AF_PERIOD_OPERATING_STATEMENT.ACCT_CODE_KEY},1)= "5" then {AF_PERIOD_OPERATING_STATEMENT.SUM_ACCOUNTED_BUDGET} This is based on the assumption that you account key code field is a string...

I am trying to integrate CR 10 with ASP.NET using Visual Studio 2005 on a Windows 2003 server running IIS 6. I have tried to install every merge module provided by Business Objects. Default.aspx page only has a report viewer object and when this page is accessed from the delpoyed site .NET...

Turkbear, I looked for the installed options and all the formats are selected in there. I am able to export the report into different formats if I do it directly from Crystal. I see the error message when I try it from a web browser. KingfisherINC, I am pretty sure that I have the Advanced...

Try creating a formula like this and replacing it with the {Hours quantity} field in the report. @hours if isnull({Hours quantity}) then 0 else {Hours quantity} This should get you your desired resluts. Kchaudhry

Hello, We have some reports which were created in CR 10 and currently being distributed using CE 10 in a .NET application. The issue we are facing is that everytime a report is executed from the web browser and we click on the envelope sign to export the report and when we type the name and...

One thing I would check is that you dont have "Supress Blank Section" checked. You can do this by right clicking on the section and going to Section Expert => Common => Supress Blank Section. Kchaudhry

You can create formulas like this: if {table.category} = "Yellow Pages" then 1 else 0 Now insert a summary on this formula. Please note that you will have to create three formulas and then insert summaries on these formulas. Kchaudhry

If you only have four "Types" then you can add 4 report footers and add each summary in a separate report footer. Now you can conditionally supress the report footer if the summary is zero. Kchaudhry

Well the formula is only looking for 0100000 and you didnt include this in the sample data so the result "other" seems right to me. Please change your formula to something like this: if ({co.cust_num} = "0100000" ) then "Lowe's" else if ({co.cust_num} = "10001") then "FIRST DATA CORPORATION"...

What type of field is {co.cust_num}? If it is a string field then try: if ({co.cust_num} = "0100000" ) then "Lowe's" else "Other" Otherwise, provide the infromation. Kchaudhry

Why are you wrapping 0100000 in double quotes? Try this if ({co.cust_num} = 0100000 )then "Lowe's" else "Other" Kchaudhry

One option would be to add a new value in the default list for {?ClientID}. You can name it "ALL" Then change your record selection to something like this: {@ScreenDate} in {?StartDate} to {?EndDate} and (If {?ClientID} <> "ALL" then {Client.ClientID} = {?ClientID} else If {?ClientID} = "ALL"...

What happens when you copy and paste the "Qty" field in the group footer? Kchaudhry