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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.