Search results for query: *

Hi Lbass, That is an alternative, But client need it to be that way. I am just looking out whether it is feasible to do so or else what are other alternative ways to acheive the format as defined in my first message. Thanks, Nagaraj

Hi Pgtek/Katy44, Pgtek. I understood that will create a drill down effect. Where by Drill down on first group will show up the second group on further drill down show group 3 and so on. But Here I want it in show up in different way. On Drill Down on Group1(i.e. Locations), It should display...

Hi All, I have a different scenario. I have to display the data as below Location 1 Count(Employees) Location 2 Count(Employees) OnDrill Down I want to display 2 groups.i.e. Location1 Region 1 Customer 1 OrderCount(5) Customer 2 OrderCount(10)...

Hi All, I got the solution. I had reduced the sections size for all sections of the subreports except on which was having formulas. I minimized them manually but not with Suppressing. As Suppress/Hiding was still leaving some whitespace, which was helping in increasing the size of the...

Hi Madwac, If I hide that section the forumlas in that subreport are not getting executed. If I suppress or even Hide they are not getting executed. Thanks, Nagaraj

Hi All, I had a report with 3 subreports placed in the Group Header. Each subreport has certain formulas to calculate and hold them in shared variables defined in main report. When I execute the report the subreport are growing in Group header section and moving the Group footer content of the...

Hi, I am using the stored procedure in main report and views in the subreport. After linking them at subreport linking it is giving be message saying "Not Supported". Thanks, Nagaraj Aengula

Hi All, Is there any kind of restirction in using stored procedures and views. I had created a report which has 6 subreports in it. I had connected a stored procedure to a main report and 3 subreports are connected to stored procedures and 3 are connected to views. When I am executing the...

Hi I am having a problem in keeping the groups together.I have Group1,Group2,Group3 data. When I have option "Keep Groups Together" checked for all the 3 groups. It is showing the every record of Group1 in one page and then showing other groups next page onwards. Why all groups not...

Hi Synapsevampire, I am using the OCX. I had a stored procedure, which has date parameter to accept. On attaching the stored procedure to the report, It created a parameter of type DateTime in Report. When I am passing DataTime parameter from VB to crystal it is giving me error. After going...

Hi All, I am facing a strange problem in passing DateTime() parameter from VB. I had written the following code to pass DateTime Parameter in crystal. .ParameterFields(4) = "Contract Status As of Date;DateTime(" & strYear & "," & strMonth & "," & strDay &...

Hi All, I am facing a strange problem in passing DateTime() parameter from VB. I had written the following code to pass DateTime Parameter in crystal. .ParameterFields(4) = "Contract Status As of Date;DateTime(" & strYear & "," & strMonth & "," & strDay &...

Hi Naith, I had tried them kept each of them in individual section. So for 4 sub reports i created 4 sections each hold the subreport with a shared variable.I created a 5th section and created a forumla which adds the 3 Subreport Shared values. I had another forumla in Section 1 which...

Hi Everybody, I had a problem related to sequence of execution of subreports. I have 4 subreports SubReport1 SubReport2 SubReport3 SubReport4 But I have Shared Variables which collection values in it in each 2nd,3rd and 4th sub-reports. There we collect value in Subreport 2, Subreport 3 and...

Hi Reebo, Thats correct. But this report which I am showing you is an subreport. To Show it in an Main report I have to collect it in a Shared Variable. But When I print the total score of store in Main report it is showing the default value. But not the actual value,which was evaluated in the...

Hi Dudes, Yes. That is true. But there is a restriction to not make any changes to the views which are created already. So that was reason i was try to resolve it from crystal end. You are correct synapsevampire*. I think i will try our williams idea also. Btw how to loop thru an Array and...

Hi I had a situation, where we want to show all the categories. I had 4 categories fixed. But when we bring the products report,we have the products in 3 categories and report is shown as below Categoies Products count Cat 1 23 Cat 2 30 Cat 4 33 But Since I want to show the...

Hi Reeboo, Getting the totals on top is causing the problem. Is there any way to show the added store points on top? I want the values of the formulas to be displayed on top. But the values are calculated later in the report. when i place them on report header to display it shows the inital...

Hi I want the values of the formulas to be displayed on top. But the values are calculated later in the report. when i place them on report header to display it shows the inital values. Here we are giving the points on the total order each store get. Now the situation is for total points we...

Hi Williams and ummul, Sol (b) is not possible. I think i will try to find out how subreport help in this aspect. Thanks Williams and ummul, Regards, Nagaraj