Search results for query: *

Thanks for your reply - However, I fixed the problem. Now I have 2 Report Headers. Report Header A for the sub-report and Report Header B for my column headings. MG.

I forgot to mention one thing though - When I run the report using Crystal client on my machine, it does display the column headings. However, when I export the data to Excel- data only the headings for some reason gets deleted. MG.

Hi, I have a simple problem ... I hope ;). In my report I have a sub-report in the Report Header section. I have the column headings or column labels in the Page Header Section and all the data in Details section. The problem is that my output shows the Sub-report and all the data. However, it...

Hi, Im using Crystal 10 and when Im running one of my reports by scheduling the report. However, when I run the report it takes its time to run and towards the end it fails with the error - "Object failed to run due to an unresponsive Job Server child process" I read in the thread...

Actually I've been adding 10 fields every run and now I've reached 100 fields and so far its been working. But I want to see if there is a better solution. Synapse - To answer your question (In youir example, the component becomes the row, and the main item becomes the column, you get rid of...

Synapse - I cannot simply use a standar report for this purpose. The reason that I had included a previous link was for the purpose of providing a sample data - Output of my query is like this - Main Item Component Qty Supplier Price Car Tire 4...

CR Version - 10 Database - Proprietary OODB the reason I provided the link was to provide a reason for using Crosstab instead of simply dumping all fields in teh detail section of the report. I dont want to post all the 100+ fields on this post as I see no value to it. The database doesnt allow...

Synapse, Like I mentioned in my previous post, I have a crosstab with approx 100 fields which I have placed in my report header section. When I run my report, CR abruptly terminates without displaying any output. I know there is no problem in my query coz if instead of using a crosstab, I...

I have a report with a crosstab which has approx ~100 columns. When I run the report, which takes about 8 minutes to run it terminates before it can display the output. However, if I place all these 100 fields directly in the detail section of the report it displays the output to me. I've...

This will just filter records. That is not what I want to do. I want suppress an entire Column condionally. MG

Well the condition is based on the users input. The user doesnt want to view some information and that I need to suppress. MG.

Hi, I have a Crosstab with about 20 rows and 1 column and 1 summarized field. In the Customize Style tab, I have Suppress Row Grand Totals and Suppress column grand totals as Yes. For all rows I have Suppress subtotal as Yes also. What I need to do is to not display some of the rows...

Well I already have a crosstab and it already has a field added to the column. So the output of my query is as follows - Item Main Item Qty Per Demand1 Demand2 A XYZ 1 100 200 B XYZ 1 150 200 A...

Well Crosstabs can accomodate different number of "CrossTab columns". However, what Im referring to is the no of fields that the query returns. MG

hi lbass, Actually the problem is that since the date range is variable, the number of columns returned by my query is also variable. So Im not sure how to put them on the report. So if I run the report it returns say 10 columns and if I re-run the report for different dates, it might return 15...

hi, Im using a crosstab to display a number of columns in my report. I have a query which can return a variable number of columns. For example, the input parameter is Demand Upto - where the user will input a date upto which I need to display weekly demand. So if the user enters 12/30/2006, I...

lbass - the hotfix did it. Problem now seems to be solved. thanks a lot for your help !! MG.

When I create a new report using Add Command and if I create all the parameters at once, it works fine. Just a big pain coz I have to redo almost all my reports now. Wish there was a simpler fix. MG.

I have a report with the SQL being a command where I've simply pasted my query. I have some input parameters for the query as well which I've created via Database Expert --> Edit Command --> Create. The problem that Im having is that now I want to create another parameter for the query. If I...

Hi Synapse, My CR version is 10. I installed Service Pack 2 but that didnt fix the problem :(. Also Im not calling crystal from another application. This is purely a Crystal report. Please do let me know if you can think of something that might help me fix this issue or if you need any more...