Version imprimable
bonjour à tous!
après quelques rapides recherches j'ai toruvé la ligne qui permet d'insérer un peu de code javascript en code behind.
or ma ligne ne fonctionne pas:
sauriez vous me dire pourquoi?Code:Response.Write("<script language=javascript>document.forms[0].PivotTable1.XMLData = """ & xmla & """;</script>")
je dois le faire en javascript car en code behind le control "pivottable" n'est pas accessible, et la variable xmla contient exactement ce que je veux!
une idée??
merci!
Regarde dans ton navigateur le code source retourné pour voir si le java script généré est bien ce que tu attends.
il n'y a pas l'air d'y avoir de problème à ce niveau là.. enfin il ne me semble pas! la variable xmla contient une grande requète xml.
Citation:
<script language=javascript>document.forms[0].PivotTable1.XMLData = " <x:PivotTable> <x:OWCVersion>11.0.0.5531 </x:OWCVersion> <x:NoDisplayAlerts/> <x:DisplayScreenTips/> <x:CubeProvider>msolap.2</x:CubeProvider> <x:CacheDetails/> <x:ConnectionString>Provider=MSOLAP.2;Password=illico;User ID=cube-olap;Data Source=http://192.168.229.246/AppliOWC;Initial Catalog=C_AAIEG;Client Cache Size=25;Auto Synch Period=10000</x:ConnectionString> <x:DataMember>AAIEG</x:DataMember> <x:Name>Microsoft Office PivotTable 11.0</x:Name> <x:PivotField> <x:Name>Debut contrat stage</x:Name> <x:SourceName>[Debut contrat de stage].[Standard].[Debut contrat stage]</x:SourceName> <x:FilterCaption>Debut contrat de stage Standard</x:FilterCaption> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Debut de scolarite</x:Name> <x:SourceName>[Debut de scolarite].[Standard].[Debut de scolarite]</x:SourceName> <x:FilterCaption>Debut de scolarite Standard</x:FilterCaption> <x:Orientation>Column</x:Orientation> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Debut de session</x:Name> <x:SourceName>[Debut de Session].[Standard].[Debut de session]</x:SourceName> <x:FilterCaption>Debut de Session Standard</x:FilterCaption> <x:Orientation>Row</x:Orientation> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Debut prolongation Stage Contrat</x:Name> <x:SourceName>[Debut prolongation stage contrat].[Standard].[Debut prolongation Stage Contrat]</x:SourceName> <x:FilterCaption>Debut prolongation stage contrat Standard</x:FilterCaption> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Duree contrat stage</x:Name> <x:SourceName>[Duree contrat stage].[Standard].[Duree contrat stage]</x:SourceName> <x:FilterCaption>Duree contrat stage Standard</x:FilterCaption> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Duree_du_cursus</x:Name> <x:SourceName>[Duree du cursus].[Standard].[Duree_du_cursus]</x:SourceName> <x:FilterCaption>Duree du cursus Standard</x:FilterCaption> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Pays</x:Name> <x:SourceName>[Entreprise].[Standard].[Pays]</x:SourceName> <x:FilterCaption>Entreprise Standard</x:FilterCaption> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Departement</x:Name> <x:SourceName>[Entreprise].[Standard].[Departement]</x:SourceName> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Raison_Sociale</x:Name> <x:SourceName>[Entreprise].[Standard].[Raison_Sociale]</x:SourceName> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Fin de contrat de stage</x:Name> <x:SourceName>[Fin contrat de stage].[Standard].[Fin de contrat de stage]</x:SourceName> <x:FilterCaption>Fin contrat de stage Standard</x:FilterCaption> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Fin de scolarite</x:Name> <x:SourceName>[Fin de scolarite].[Standard].[Fin de scolarite]</x:SourceName> <x:FilterCaption>Fin de scolarite Standard</x:FilterCaption> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Fin_de_session</x:Name> <x:SourceName>[Fin de Session].[Standard].[Fin_de_session]</x:SourceName> <x:FilterCaption>Fin de Session Standard</x:FilterCaption> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Fin prolongation stage contrat</x:Name> <x:SourceName>[Fin prolongation stage contrat].[Standard].[Fin prolongation stage contrat]</x:SourceName> <x:FilterCaption>Fin prolongation stage contrat Standard</x:FilterCaption> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Maitre</x:Name> <x:SourceName>[Maitre dapprentissage].[Standard].[Maitre]</x:SourceName> <x:FilterCaption>Maitre dapprentissage Standard</x:FilterCaption> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Nationalite</x:Name> <x:SourceName>[Nationalite].[Standard].[Nationalite]</x:SourceName> <x:FilterCaption>Nationalite Standard</x:FilterCaption> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Niveau_scolaire</x:Name> <x:SourceName>[Niveau Scolaire].[Standard].[Niveau_scolaire]</x:SourceName> <x:FilterCaption>Niveau Scolaire Standard</x:FilterCaption> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Pays</x:Name> <x:SourceName>[Origine Geographique].[Standard].[Pays]</x:SourceName> <x:FilterCaption>Origine Geographique Standard</x:FilterCaption> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Departement</x:Name> <x:SourceName>[Origine Geographique].[Standard].[Departement]</x:SourceName> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Code_postal</x:Name> <x:SourceName>[Origine Geographique].[Standard].[Code_postal]</x:SourceName> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Origine_scolaire</x:Name> <x:SourceName>[Origine Scolaire].[Standard].[Origine_scolaire]</x:SourceName> <x:FilterCaption>Origine Scolaire Standard</x:FilterCaption> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Qualite</x:Name> <x:SourceName>[Qualite].[Standard].[Qualite]</x:SourceName> <x:FilterCaption>Qualite Standard</x:FilterCaption> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Rentree_des_classes</x:Name> <x:SourceName>[Rentree des classes].[Standard].[Rentree_des_classes]</x:SourceName> <x:FilterCaption>Rentree des classes Standard</x:FilterCaption> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Resultat Examen</x:Name> <x:SourceName>[Resultat examen].[Standard].[Resultat Examen]</x:SourceName> <x:FilterCaption>Resultat examen Standard</x:FilterCaption> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Etat</x:Name> <x:SourceName>[Rupture de Contrat].[Standard].[Etat]</x:SourceName> <x:FilterCaption>Rupture de Contrat Standard</x:FilterCaption> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Motif</x:Name> <x:SourceName>[Rupture de Contrat].[Standard].[Motif]</x:SourceName> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Date</x:Name> <x:SourceName>[Rupture de Contrat].[Standard].[Date]</x:SourceName> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Sexe</x:Name> <x:SourceName>[Sexe].[Standard].[Sexe]</x:SourceName> <x:FilterCaption>Sexe Standard</x:FilterCaption> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Sortie des classes</x:Name> <x:SourceName>[Sortie des classes].[Standard].[Sortie des classes]</x:SourceName> <x:FilterCaption>Sortie des classes Standard</x:FilterCaption> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Tranche_Age</x:Name> <x:SourceName>[Tranche age].[Standard].[Tranche_Age]</x:SourceName> <x:FilterCaption>Tranche age Standard</x:FilterCaption> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Type Contrat Stage</x:Name> <x:SourceName>[Type contrat].[Standard].[Type Contrat Stage]</x:SourceName> <x:FilterCaption>Type contrat Standard</x:FilterCaption> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Reseau</x:Name> <x:SourceName>[Type Inscription].[Standard].[Reseau]</x:SourceName> <x:FilterCaption>Type Inscription Standard</x:FilterCaption> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Site</x:Name> <x:SourceName>[Type Inscription].[Standard].[Site]</x:SourceName> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Session</x:Name> <x:SourceName>[Type Inscription].[Standard].[Session]</x:SourceName> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Formation</x:Name> <x:SourceName>[Type Inscription].[Standard].[Formation]</x:SourceName> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Section</x:Name> <x:SourceName>[Type Inscription].[Standard].[Section]</x:SourceName> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Situation</x:Name> <x:SourceName>[Type Inscription].[Standard].[Situation]</x:SourceName> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>Examen</x:Name> <x:SourceName>[Type Inscription].[Standard].[Examen]</x:SourceName> <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy> </x:PivotField> <x:PivotField> <x:Name>IdStagiaire</x:Name> <x:SourceName>[Measures].[IdStagiaire]</x:SourceName> <x:SourceHierarchy>[Measures].[IdStagiaire]</x:SourceHierarchy> </x:PivotField> <x:PivotField> <x:Name>Data</x:Name> <x:Orientation>Column</x:Orientation> <x:Position>-1</x:Position> <x:DataField/> </x:PivotField> <x:PivotField> <x:Name>IdStagiaire</x:Name> <x:TotalNumber>0</x:TotalNumber> <x:Orientation>Data</x:Orientation> <x:Position>1</x:Position> <x:ParentField>[Measures].[IdStagiaire]</x:ParentField> </x:PivotField> <x:PivotData> <x:Top>0.0</x:Top> <x:TopOffset>0</x:TopOffset> <x:Left>0.0</x:Left> <x:LeftOffset>0</x:LeftOffset> </x:PivotData> <x:PivotView> <x:IsNotFiltered/> </x:PivotView> </x:PivotTable>";</script>
Tout d'abord il est préférable d'utiliser les méthodes:
etCode:Page.RegisterClientScript
afin de placer le javascript au bon endroit.Code:Page.RegisterStartupScript
Est ce que tu n'aurais pas plutot un probleme de javascript?
Parce que si ca s'ecrit, c'est donc sur le client que tu as un probleme.
Essaye en remplaçant ton code javascritp par un message d'alert de javascript. S'il fonctionne, ce que je pense, alors c'est ta reqûete XML qui n'est pas bonne.
merci pour vos réponses!!!!
j'ai fini par trouvé! en fait mon problème c'est que ce code était dans un bouton. la page se rachargeait à chaque fois, et l'évenement "onload" de la page courcircuitait le code en javascript!
ce code est passé dans la page aspx et traité avant la fonction d'initialisation de la page dans le onload.
Merci beaucoup de votre aide! :D