Search results for query: *

if the stored proc in sub report doesn't return any data, sub report is suppressed along with its header by checking if isnull({table.id}) then supress. However, if the stored proc in sub report does return data and I compare the columns and rows for any changes, if nothing is found, I have a...

Main report uses stored proc that returns data as follows: Cust_ID Activity_ID ------ -------- 101 200 102 200 103 200 104 200 GH1 in main report is grouped by Cust_ID and the id is linked to Sub Reprot 1 GH2 is grouped by Activity_ID and the id is linked...

Thanks again for the response. There are more than 10 sub reports embedded into the main report. Each of which has different heading. The one example I gave was CUSTOMER RECORDS. There are other ones like 'PRODUCT RECORDS', 'PAYMENT RECORDS' etc. Thanks. Sum

Thanks for the response lbass, really appreciate it. I already tried that. It works for only those records that have changed i.e. when the sub report returns the changed values. Will put it in a format as follows: Main Report: ---------------------- PH - ABC Company ----------------------...

Sorry for the confusion, let me try to be more descriptive. Main Report: PH - ABC Company --------------------------------------------- GH1 [Sub Report 1] - grouped by IDs (101, 102, 103 etc) --------------------------------------------- D -- suppressed...

Thanks for the response, however passing a parameter into sub report will not help. As I mentioned in my previous post, the only thing is passed into sub report is the id from main report. In the sub report, I do the comparison. I have to decide whether or not to suppress the header only after I...

using Crystal Version 10. Here is the typical scenario: Main report contains a sub report. Main passes multiple ids to process the sub report. Sub report uses stored proc to get data from SQL Server database. Stored Proc gets the data in following format from the database for ID 101: ID...

Hi Madawc, Thanks for your response. I also thought of the 2nd option, pass the locale type from application and handle in in Crystal, which works extremely well. However, for option 1, setting to default for a particular machine, thse reports are used for a .net app as web services. Windows...

Is there any way to format dates to different regional setting i.e. when a user in US runs report the date should show up as 3/23/2005. When a user in UK runs the same report this date should show up as 23/3/2005. Is there any way to do this ? I am using Crystal 10. Thanks.

Again Looked at the Set Data Location. This time typed the proc name on the 'Overridden Qualified Table Name' field and that worked ! Thanks friends.

Thanks for the tip, however, I did that already. Everything looks perfect. I even logged off of the current connections and history connections. Reconnected to new data source, did verify database, refresh and bla bla. Still have same prob. Don't know what's going on. I realized it was pointing...

Using Crystal 10. Have some reports written by someone else. I made changes to these reports. Now the reports keep pointing to old datasource even though I set data source location to a new server and database. I tried verify database plus every other possible things. Still keep pointing to old...

Thanks dude, it helped !!

Have a scenario as follows and I am using this as sub report. id item a item b item c item d -- ------ ------ ------ ------ 1 good xyz nnn VVV 1 good xyz nnn PPP 1 good xyz nnn QQQ 1 bad abc kkk VVV 1 bad abc kkk PPP 1 bad...

Thanks for the response. I am using verson 10. Database connectivity is SQl server ole db. Example data: usp_Customer will get 5 rows with distinct ids for the main report. Sub reports use 5 different stored proc that expects 5 different customer ids. sub_rpt_usp1 will get multiple...

Hi, Have a weird scenario. I have multiple sub reports embedded on a main report. Here is the typical scenario: Main report uses a stored proc to get rows with ids that need to be passed into 5 sub reports. Let's say customer_id needs to be passed into all of those sub reports and the sub...

You are right I needed to test for the nulls which I did and the formula worked for the scenario where the id is the same for all records but for the scenario below, I believe it didn't work: Columns ------- ID FName LName City State Row 1: 1 abc xyz...

Thanks for the response. I tried your formula but it doesn't seem to work. Regardless of anything changed or not or even when there is only one row, the header still shows up. I am running out of ideas. Pls hlp.

Hi, Columns ------- ID FName LName City State Row 1: 1 abc xyz 123 NY Row 2: 1 abc yyy 567 NY Row 3: 1 abc ccc 567 Null Row 4: 1 abc ccc 567 Null Given the above scenario...

Thanks for the valuable info. Had to tweak here and there but seems to work. Another question, After getting done developing on the following scenario: SQL Servername: ABC DatabaseName: XYZ The prodcution server is as follows: SQL Server: NNN Database: XYZ How to synchronize the data...