Search results for query: *

Hi, I am new to postgresql and need some advice on its capabilities. We are looking at importing delimited files into postgresql. However, there is some tranformation which needs to be done on the way. Are there any options like that available? Looking for something similar to MS DTS or...

Hi, I created a report in the designer with three parameters in a dynamic cascading prompt. When i preview the report from CR XI designer, i see all parameter values. But for some reason, when i publish it in infoview, it seems to truncate the values and doesnt show all the values. Any idea...

Hi, I seem to have run into trouble again with these cascading prompts. I have a Union query in my ado command which returns more than 20000 rows. I have set the registry value for limiting dynamic parameter values at 2 million. Inspite of that I am my last parameter is truncating values. I...

Bob.. Thanks a lot. Works perfectly. I had tried to group by the Month name, but it didnt strike me to use the specified order sort. Thanks. rrgkanth.

Thanks Bob. It comes up as 1/2005, 2/2005 etc instead of 1.0, 2.0. But I would still like to show it as Jan, Feb, Mar. How can that be done? Thanks, rrgkanth

Hi, I am using Crystal Reports XI. My report shows count of members for each status per month. I did show the counts on change of Month which is a formula that returns the month part of the status date. My chart displays it as 1.00, 2.00, etc.. I want it to display Jan, Feb, Mar. Or...

Hi, I am using CR XI and BOE XI. database is on SQL Server. I have a report which seems to be a bit heavy on the server. Complex params, plus subreport involved etc. The problem is when i try to run it on Infoview, i get this error sometimes. An error has occurred: Request timed out. How do...

Hi, I have a few mailing label reports which print correctly 11 rows 3 cols to the size I need when I print from CR designer. However, my users only get to see the report from infoview and need to print from there. at worst, they can export to some format to print it.. the problem is that it...

MG, How does ur actual table look? That might give a different solution. The cross tab will not look the way you want it to.

Hi, I am not sure about CR 10, because I have CR xi. But I am sure, there must be a similar method of doing this. What you need is a cross tab. Insert->Cross-tab and drop in your report header. Right click and go to cross-tab expert. Select Main Item for columns, Component for rows and Qty...

Hi, I understood that u didnt add the field to the report but to the text field. you can go into edit mode of the text field (doubleclick), highlight field1, rightclick it and do as mentioned in my prev post.

Hi, it's simple. In your text field, right click field1 Format Field1 In the format editor, select number format as -1123. I think that shd work. -rrgkanth.

Hi, Tried changing to left outer join.. changed query is: SELECT "FRU_Officer"."FRUID", "FRU_Officer"."RecordYear", "FRU_OfficerSetup"."OfficerSetupID", "FRU_OfficerSetup"."OfficerDesc", "FRU_OfficerSetup"."FRUTypeCd" FROM "MMMS"."dbo"."FRU_OfficerSetup" "FRU_OfficerSetup" LEFT OUTER JOIN...

I have 2 tables FRU_Officer FRU_OfficerSetup. The setup tables is the main tables, contains officersetupid, frutypecd, officerdesc. The main aim of using that table is for me to retreive the officer desc. The other table fru_Officer has data which basically refers to the officersetupid of the...

Hi, Here are the details. CR XI. db - sql server Parameters passed: ------------------ FRUID RecordYear - formula for current year FRUTypeCd OfficerSetupId My query being passed: ------------------------ SELECT "FRU_Officer"."FRUID", "FRU_Officer"."RecordYear", "FRU_Officer"."IndividualID"...

Hi, My report uses 2 tables that have a right outer join. I have a set of selection conditions checking for parameter values where i checked for null values in the inner table too. I am trying to display one of the fields of the outer table. If i enter parameter values, such that i get...

Hi, Right click on the subreport box in ur main report and change subreport links. Select client Id or name on the left(available fields) and pass it to the right side (fields to link to). Below, check select data in subreport based on field and select the client id or name field as u need...

From the first set of data, it looks as if it hasnt been grouped at all. What you need to do is create 3 groups: Player Club Ball. You can supress the group headers and footers for all but Ball and put your Player, Club, Ball and summary field in that footer. I am not sure if I understood...

You can use a running total. In the running total expert, give the field to summarize - loan number, select distinct count for type of summary, evaluate using a formula {record.CreatedDate} Between Group.StartDate AND Group.EndDate reset on change of group

Do an edit->find and enter Dept and find. It's possible that it may have been hidden under a bigger field or item.