Recent content by haqyunus

Hi, Here is a code snippet for adding a PivotTable MS Office control in a (ASP)webpage: ------------------------------------------- Function Window_OnLoad() Set c = PTable.Constants 'Connect to the data source. PTable.ConnectionString = _ "provider=msolap;data source=YourServer;inital...

Hi, Here is a code snippet for adding a PivotTable MS Office control in a (ASP)webpage: ------------------------------------------- Function Window_OnLoad() Set c = PTable.Constants 'Connect to the data source. PTable.ConnectionString = _ "provider=msolap;data...

Thanks billchris but the coe u have given me will work for only row with id: @RecordId. U mean to apply this to the whole table i have to use a loop that will iterate through the rows by incrementing @RecordId? But dont u think this will be too inefficient for 10000 rows? -------- Thanks...

thanks JamesLean... but will it work if i want to do this (which is my actual question). "Let I = 0 i update single row with id I, after the updating the row I, i want to up date the rest of the same column with some value. Now i came to the second row i.e. I++. This row should have be...

thanks for ur reply. I mean to say : "the rest of the column ColA for rest of the rows". as on the other hand u r right as there is no use of upadting rest of the table with identical values. i want to do something like this: UPDATE tblA SET colA = newvalue, set rest...

Helo, I have a complex UPDATE problem. Suppose i have a table 'tblA' and there is a column 'ColA' in it. Now when i update a single cell of 'ColA' of a certain row of 'tblA' with 'newvalue', i also want to update (at the same time) the rest of the column 'ColA'(of rest of the rows) with...

Helo, I have a complex UPDATE problem. Suppose i have a table 'tblA' and there is a column 'ColA' in it. Now when i update a single cell of 'ColA' of a certain row of 'tblA' with 'newvalue', i also want to update (at the same time) the rest of the column (of rest of the rows) with 'newvalue/2'...

Hello, I am trying to display a Map (simple, based on US states) in a report made in CR8 with an ASP page. But only a blank space is shown (instead of the map) on the webpage while the rest of the report appears fine. Also, charts are successfully displayed on the ASP page. I am using IE 6.0...

Hello, Though my query is not directly linked to what you people are discussing but still it has a link. Can anyone of you tell me that these 'WhileReadingRecords/WhilePrintingRecords' have any effect on Maps in CR8? Or any link with the displaying of these maps in ASP pages? thanks...haq

Hello, I am trying to display a Map (simple, based on US states) in a report made in CR8 with an ASP page. But only a blank space is shown on (instead of the map) the webpage while the rest of the report appears fine. Also, charts are successfully displayed on the ASP page. I am using IE 6.0 and...

Hello, I am trying to display a Map (simple, based on US states) in a report made in CR8 with an ASP page. But only a blank space is shown on the webpage while the rest of the report appears fine. Also, charts are successfully displayed on the ASP page. I am using IE 6.0. Please help me. Thanks. Haq