Recent content by shadabrauf

I have one data source but having 20 command object and each command object is running a sql query (it is same with different where clauses for every command). Can you give me an idea If write a SP then how it will work? I am using Oracle database so the way u suggest work with oracle for...

Hi I am using CR 10 and I am working on a Balance sheet, This report is a one page report and It has 20 Columns, For each column I have written a Command (seperate query). Now my issue is I want when I will run this report It should as a Parameter "As of Date" default would be current date, And...

Hi It is really great to know Add Command...It worked. Thanks alot and it is wonderfull, now I have full command over it. I have another issue I need to have a report parameter as "Date" and that parameter I want to define on report level and want to pass the same parameter in each query...

My database is Oracle. And i am using Crystal Report 10. Could u please let me know steps how to add the "GROUP BY "GLSUMMARY"."ACCOUNTNO" in crystal report. I am trying to use "Group Selection Formula". but hetting error. It is urgent for me please suggest . shadab

I am new in crystal report, It is taking time to try that idea. I am looking in some documents to apply your idea, I am getting error. Please suggest if I can do SELECT (sum(BalanceYtd)) FROM "RWC"."GLSUMMARY" "GLSUMMARY" WHERE ("GLSUMMARY"."ACCOUNTNO">='1000' AND...

Please let me know if possible, I am waiting for your suggestion Thanks

Is there any way to write following query SELECT (sum(BalanceYtd)) FROM "RWC"."GLSUMMARY" "GLSUMMARY" WHERE ("GLSUMMARY"."ACCOUNTNO">='1000' AND "GLSUMMARY"."ACCOUNTNO"<='2000') Your help is appreciated. Thanks

Thanks I did the same, After that my SQL query is showing following SELECT "GLSUMMARY"."ACCOUNTNO", (sum(BalanceYtd)) FROM "RWC"."GLSUMMARY" "GLSUMMARY" WHERE ("GLSUMMARY"."ACCOUNTNO">='1000' AND "GLSUMMARY"."ACCOUNTNO"<='2000') I am getting error "Not a Sigle Group Function" Please...

My requirement is I need to hardcode the parameters. Could you please explain this little bit in detail , I am new in crystal report. Thanks.

I need to write following query in a report. How to write This report has only one column and I need to show data based on following query. select sum(balanceYtd) from temp where temp.accountno >='1000' and temp.accountNo <='2000'; Can some one let me know How do i write this query in crystal...

Thanks alot. It will solve my problem. Since I am new in the report writer so just asking Is this is the only way to run a query for each row? Shadab

I am trying to write a Balance Sheet, My issue is I am trying to write seperate query for each row of this report. I have 10 rows in the report like ASSETS ============= CASH & CASH EQUIVALENT <seperate sql query for this row> NOTES RECEIVABLE <seperate sql query for this row> TRADE...