- Data:
- 2009-07-06 14:15:34 (17 years ago)
- Lokalizacja:
- trunk
- Pliki:
-
- 11 zmodyfikowane
- 1 skopiowane
-
BazaReklam/Classes/Helpers/AdHelper.cs (zmodyfikowane) (4 diffs)
-
BazaReklam/OrderDetails.cs (zmodyfikowane) (2 diffs)
-
BazaReklam/Raporty/ReportsTree.xml (zmodyfikowane) (1 diff)
-
BazaReklam/app.config (zmodyfikowane) (1 diff)
-
BazaReklamSetup/BazaReklamSetup.vdproj (zmodyfikowane) (20 diffs)
-
RaportySQL/ListaReklamA3.rdl (zmodyfikowane) (11 diffs)
-
RaportySQL/ListaReklamA3.rdl.data (zmodyfikowane) (poprzedni)
-
RaportySQL/ListaReklamA4.rdl (skopiowane) (skopiowane from trunk/RaportySQL/ListaReklamA3.rdl) (31 diffs)
-
RaportySQL/ListaReklamNaWydanieNr.rdl (zmodyfikowane) (10 diffs)
-
RaportySQL/ListaReklamNaWydanieNr.rdl.data (zmodyfikowane) (poprzedni)
-
RaportySQL/RaportySQL.rptproj (zmodyfikowane) (2 diffs)
-
SQL/StoredProcedures/sp_GetListaReklamNaWydanie.txt (zmodyfikowane) (4 diffs)
Legenda:
- Bez zmian
- Dodane
- Usunięte
-
trunk/BazaReklam/Classes/Helpers/AdHelper.cs
r732 r738 6 6 public struct AdSize 7 7 { 8 public intWidth;9 public intHeight;8 public decimal Width; 9 public decimal Height; 10 10 } 11 11 … … 24 24 } 25 25 26 intwidth = 0;27 intheight = 0;26 decimal width = 0; 27 decimal height = 0; 28 28 29 29 if (module.Section.Title.ShortName == "AMT") … … 39 39 //max 2 x 4 40 40 width = ((horizontal - 1) * 3) + (horizontal * 105); 41 height = Convert.To Int32(((vertical - 1) * 3) + (vertical * 72.5));41 height = Convert.ToDecimal(((vertical - 1) * 3) + (vertical * 72.5)); 42 42 } 43 43 else … … 54 54 //max 2 x 4 55 55 width = ((horizontal - 1) * 3) + (horizontal * 105); 56 height = Convert.To Int32(((vertical - 1) * 3) + (vertical * 72.5));56 height = Convert.ToDecimal(((vertical - 1) * 3) + (vertical * 72.5)); 57 57 } 58 58 else -
trunk/BazaReklam/OrderDetails.cs
r732 r738 1031 1031 SelectedModule); 1032 1032 1033 sZERTextBox.Text = adSize.Width.ToString( );1034 wYSTextBox.Text = adSize.Height.ToString( );1033 sZERTextBox.Text = adSize.Width.ToString("#0.00"); 1034 wYSTextBox.Text = adSize.Height.ToString("#0.00"); 1035 1035 } 1036 1036 … … 1754 1754 AdSize adSize = AdHelper.GetAdSize(horizontal, vertical, SelectedModule); 1755 1755 1756 sZERTextBox.Text = adSize.Width.ToString( );1757 wYSTextBox.Text = adSize.Height.ToString( );1756 sZERTextBox.Text = adSize.Width.ToString("#0.00"); 1757 wYSTextBox.Text = adSize.Height.ToString("#0.00"); 1758 1758 } 1759 1759 } -
trunk/BazaReklam/Raporty/ReportsTree.xml
r691 r738 51 51 <Report text="Reklamy do dodania" path="ReklamyDoDodania" rights="" /> 52 52 <Report text="Reklama w Internecie" path="ReklamaWInternecie" rights="" /> 53 <Report text="Lista reklam A4" path="ListaReklamA4" rights="" /> 53 54 <Report text="Lista reklam A3" path="ListaReklamA3" rights="" /> 54 55 </Report> -
trunk/BazaReklam/app.config
r737 r738 9 9 <clear /> 10 10 <add name="BAZA_REKLAM" connectionString="Data Source=sql.ct.com.pl;Initial Catalog=BAZA_REKLAM;Persist Security Info=True" 11 providerName="System.Data.SqlClient" />12 <add name="Baza_Reklam.Properties.Settings.Baza_ReklamConnectionString"13 connectionString="Data Source=sql.ct.com.pl;Initial Catalog=Baza_Reklam;User ID=sa;Password=9ar6u$ek"14 11 providerName="System.Data.SqlClient" /> 15 12 </connectionStrings> -
trunk/BazaReklamSetup/BazaReklamSetup.vdproj
r732 r738 16 16 "Entry" 17 17 { 18 "MsmKey" = "8:_135B2D9B7FCFB80D465861D39A152401" 19 "OwnerKey" = "8:_EB843BFFB9344F29AF52E5F834254602" 20 "MsmSig" = "8:_UNDEFINED" 21 } 22 "Entry" 23 { 24 "MsmKey" = "8:_135B2D9B7FCFB80D465861D39A152401" 25 "OwnerKey" = "8:_C68843D336D1FA86D4CB277E88BE49CE" 26 "MsmSig" = "8:_UNDEFINED" 27 } 28 "Entry" 29 { 30 "MsmKey" = "8:_135B2D9B7FCFB80D465861D39A152401" 31 "OwnerKey" = "8:_78F7FF4DBAE741BDB144A21AB75A662F" 32 "MsmSig" = "8:_UNDEFINED" 33 } 34 "Entry" 35 { 36 "MsmKey" = "8:_135B2D9B7FCFB80D465861D39A152401" 37 "OwnerKey" = "8:_E949949BEB2DFFD45A0493C54D411F71" 38 "MsmSig" = "8:_UNDEFINED" 39 } 40 "Entry" 41 { 18 42 "MsmKey" = "8:_15C4040CC2276248801B89EABAE2C08B" 19 "OwnerKey" = "8:_ 64F2494A3F7471FFE0251D304E2D9EC7"43 "OwnerKey" = "8:_C68843D336D1FA86D4CB277E88BE49CE" 20 44 "MsmSig" = "8:_UNDEFINED" 21 45 } … … 34 58 "Entry" 35 59 { 36 "MsmKey" = "8:_417AC05C5D1B7D3F2998D77D2847724C"37 "OwnerKey" = "8:_AA4022385237E4501A89AC0D13FEF94D"38 "MsmSig" = "8:_UNDEFINED"39 }40 "Entry"41 {42 "MsmKey" = "8:_417AC05C5D1B7D3F2998D77D2847724C"43 "OwnerKey" = "8:_64F2494A3F7471FFE0251D304E2D9EC7"44 "MsmSig" = "8:_UNDEFINED"45 }46 "Entry"47 {48 "MsmKey" = "8:_417AC05C5D1B7D3F2998D77D2847724C"49 "OwnerKey" = "8:_78F7FF4DBAE741BDB144A21AB75A662F"50 "MsmSig" = "8:_UNDEFINED"51 }52 "Entry"53 {54 "MsmKey" = "8:_417AC05C5D1B7D3F2998D77D2847724C"55 "OwnerKey" = "8:_8C96984BF8E1FE9643D1021B3C804DA1"56 "MsmSig" = "8:_UNDEFINED"57 }58 "Entry"59 {60 60 "MsmKey" = "8:_591691C9896FA27184B009788E05FC3A" 61 "OwnerKey" = "8:_8C96984BF8E1FE9643D1021B3C804DA1" 62 "MsmSig" = "8:_UNDEFINED" 63 } 64 "Entry" 65 { 66 "MsmKey" = "8:_64F2494A3F7471FFE0251D304E2D9EC7" 67 "OwnerKey" = "8:_78F7FF4DBAE741BDB144A21AB75A662F" 61 "OwnerKey" = "8:_E949949BEB2DFFD45A0493C54D411F71" 68 62 "MsmSig" = "8:_UNDEFINED" 69 63 } … … 89 83 { 90 84 "MsmKey" = "8:_81209E5699A9F4F3741B8B24D034F5A2" 91 "OwnerKey" = "8:_AA4022385237E4501A89AC0D13FEF94D" 92 "MsmSig" = "8:_UNDEFINED" 93 } 94 "Entry" 95 { 96 "MsmKey" = "8:_8C96984BF8E1FE9643D1021B3C804DA1" 97 "OwnerKey" = "8:_AA4022385237E4501A89AC0D13FEF94D" 98 "MsmSig" = "8:_UNDEFINED" 99 } 100 "Entry" 101 { 102 "MsmKey" = "8:_8C96984BF8E1FE9643D1021B3C804DA1" 103 "OwnerKey" = "8:_64F2494A3F7471FFE0251D304E2D9EC7" 104 "MsmSig" = "8:_UNDEFINED" 105 } 106 "Entry" 107 { 108 "MsmKey" = "8:_8C96984BF8E1FE9643D1021B3C804DA1" 109 "OwnerKey" = "8:_78F7FF4DBAE741BDB144A21AB75A662F" 85 "OwnerKey" = "8:_EB843BFFB9344F29AF52E5F834254602" 110 86 "MsmSig" = "8:_UNDEFINED" 111 87 } … … 118 94 "Entry" 119 95 { 120 "MsmKey" = "8:_AA4022385237E4501A89AC0D13FEF94D" 96 "MsmKey" = "8:_B7492250D3DFC9E86EDFC1F888FB6225" 97 "OwnerKey" = "8:_135B2D9B7FCFB80D465861D39A152401" 98 "MsmSig" = "8:_UNDEFINED" 99 } 100 "Entry" 101 { 102 "MsmKey" = "8:_C68843D336D1FA86D4CB277E88BE49CE" 121 103 "OwnerKey" = "8:_78F7FF4DBAE741BDB144A21AB75A662F" 122 "MsmSig" = "8:_UNDEFINED"123 }124 "Entry"125 {126 "MsmKey" = "8:_B7492250D3DFC9E86EDFC1F888FB6225"127 "OwnerKey" = "8:_417AC05C5D1B7D3F2998D77D2847724C"128 104 "MsmSig" = "8:_UNDEFINED" 129 105 } … … 142 118 "Entry" 143 119 { 120 "MsmKey" = "8:_E949949BEB2DFFD45A0493C54D411F71" 121 "OwnerKey" = "8:_EB843BFFB9344F29AF52E5F834254602" 122 "MsmSig" = "8:_UNDEFINED" 123 } 124 "Entry" 125 { 126 "MsmKey" = "8:_E949949BEB2DFFD45A0493C54D411F71" 127 "OwnerKey" = "8:_C68843D336D1FA86D4CB277E88BE49CE" 128 "MsmSig" = "8:_UNDEFINED" 129 } 130 "Entry" 131 { 132 "MsmKey" = "8:_E949949BEB2DFFD45A0493C54D411F71" 133 "OwnerKey" = "8:_78F7FF4DBAE741BDB144A21AB75A662F" 134 "MsmSig" = "8:_UNDEFINED" 135 } 136 "Entry" 137 { 138 "MsmKey" = "8:_EB843BFFB9344F29AF52E5F834254602" 139 "OwnerKey" = "8:_78F7FF4DBAE741BDB144A21AB75A662F" 140 "MsmSig" = "8:_UNDEFINED" 141 } 142 "Entry" 143 { 144 144 "MsmKey" = "8:_UNDEFINED" 145 145 "OwnerKey" = "8:_78F7FF4DBAE741BDB144A21AB75A662F" … … 167 167 { 168 168 "MsmKey" = "8:_UNDEFINED" 169 "OwnerKey" = "8:_ 64F2494A3F7471FFE0251D304E2D9EC7"169 "OwnerKey" = "8:_C68843D336D1FA86D4CB277E88BE49CE" 170 170 "MsmSig" = "8:_UNDEFINED" 171 171 } … … 173 173 { 174 174 "MsmKey" = "8:_UNDEFINED" 175 "OwnerKey" = "8:_ AA4022385237E4501A89AC0D13FEF94D"175 "OwnerKey" = "8:_EB843BFFB9344F29AF52E5F834254602" 176 176 "MsmSig" = "8:_UNDEFINED" 177 177 } … … 179 179 { 180 180 "MsmKey" = "8:_UNDEFINED" 181 "OwnerKey" = "8:_ 8C96984BF8E1FE9643D1021B3C804DA1"181 "OwnerKey" = "8:_E949949BEB2DFFD45A0493C54D411F71" 182 182 "MsmSig" = "8:_UNDEFINED" 183 183 } … … 185 185 { 186 186 "MsmKey" = "8:_UNDEFINED" 187 "OwnerKey" = "8:_ 417AC05C5D1B7D3F2998D77D2847724C"187 "OwnerKey" = "8:_135B2D9B7FCFB80D465861D39A152401" 188 188 "MsmSig" = "8:_UNDEFINED" 189 189 } … … 284 284 "File" 285 285 { 286 "{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_135B2D9B7FCFB80D465861D39A152401" 287 { 288 "AssemblyRegister" = "3:1" 289 "AssemblyIsInGAC" = "11:FALSE" 290 "AssemblyAsmDisplayName" = "8:Interop.Office, Version=2.1.0.0, Culture=neutral, processorArchitecture=MSIL" 291 "ScatterAssemblies" 292 { 293 "_135B2D9B7FCFB80D465861D39A152401" 294 { 295 "Name" = "8:Interop.Office.dll" 296 "Attributes" = "3:512" 297 } 298 } 299 "SourcePath" = "8:Interop.Office.dll" 300 "TargetName" = "8:" 301 "Tag" = "8:" 302 "Folder" = "8:_A71B9F4A6F7A4846B9A8121692FB34D3" 303 "Condition" = "8:" 304 "Transitive" = "11:FALSE" 305 "Vital" = "11:TRUE" 306 "ReadOnly" = "11:FALSE" 307 "Hidden" = "11:FALSE" 308 "System" = "11:FALSE" 309 "Permanent" = "11:FALSE" 310 "SharedLegacy" = "11:FALSE" 311 "PackageAs" = "3:1" 312 "Register" = "3:1" 313 "Exclude" = "11:FALSE" 314 "IsDependency" = "11:TRUE" 315 "IsolateTo" = "8:" 316 } 286 317 "{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_15C4040CC2276248801B89EABAE2C08B" 287 318 { … … 335 366 "IsolateTo" = "8:" 336 367 } 337 "{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_417AC05C5D1B7D3F2998D77D2847724C" 368 "{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_591691C9896FA27184B009788E05FC3A" 369 { 370 "SourcePath" = "8:VBE6EXT.OLB" 371 "TargetName" = "8:VBE6EXT.OLB" 372 "Tag" = "8:" 373 "Folder" = "8:_A71B9F4A6F7A4846B9A8121692FB34D3" 374 "Condition" = "8:" 375 "Transitive" = "11:FALSE" 376 "Vital" = "11:TRUE" 377 "ReadOnly" = "11:FALSE" 378 "Hidden" = "11:FALSE" 379 "System" = "11:FALSE" 380 "Permanent" = "11:FALSE" 381 "SharedLegacy" = "11:FALSE" 382 "PackageAs" = "3:1" 383 "Register" = "3:1" 384 "Exclude" = "11:FALSE" 385 "IsDependency" = "11:TRUE" 386 "IsolateTo" = "8:" 387 } 388 "{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_6C6DB793A8DA3CF4F3943CD8BBC6D521" 338 389 { 339 390 "AssemblyRegister" = "3:1" 340 391 "AssemblyIsInGAC" = "11:FALSE" 341 "AssemblyAsmDisplayName" = "8: Interop.Office, Version=2.1.0.0, Culture=neutral, processorArchitecture=MSIL"392 "AssemblyAsmDisplayName" = "8:Microsoft.ReportViewer.WinForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL" 342 393 "ScatterAssemblies" 343 394 { 344 "_ 417AC05C5D1B7D3F2998D77D2847724C"345 { 346 "Name" = "8: Interop.Office.dll"395 "_6C6DB793A8DA3CF4F3943CD8BBC6D521" 396 { 397 "Name" = "8:Microsoft.ReportViewer.WinForms.dll" 347 398 "Attributes" = "3:512" 348 399 } 349 400 } 350 "SourcePath" = "8: Interop.Office.dll"401 "SourcePath" = "8:Microsoft.ReportViewer.WinForms.dll" 351 402 "TargetName" = "8:" 352 403 "Tag" = "8:" … … 366 417 "IsolateTo" = "8:" 367 418 } 368 "{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_ 591691C9896FA27184B009788E05FC3A"369 { 370 "SourcePath" = "8: VBE6EXT.OLB"371 "TargetName" = "8: VBE6EXT.OLB"419 "{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_81209E5699A9F4F3741B8B24D034F5A2" 420 { 421 "SourcePath" = "8:EXCEL9.OLB" 422 "TargetName" = "8:EXCEL9.OLB" 372 423 "Tag" = "8:" 373 424 "Folder" = "8:_A71B9F4A6F7A4846B9A8121692FB34D3" … … 386 437 "IsolateTo" = "8:" 387 438 } 388 "{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_64F2494A3F7471FFE0251D304E2D9EC7" 439 "{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_90355BBD5BDA4A8FB195EB7C7A954ADA" 440 { 441 "SourcePath" = "8:..\\BazaReklam\\cab.ico" 442 "TargetName" = "8:cab.ico" 443 "Tag" = "8:" 444 "Folder" = "8:_A71B9F4A6F7A4846B9A8121692FB34D3" 445 "Condition" = "8:" 446 "Transitive" = "11:FALSE" 447 "Vital" = "11:TRUE" 448 "ReadOnly" = "11:FALSE" 449 "Hidden" = "11:FALSE" 450 "System" = "11:FALSE" 451 "Permanent" = "11:FALSE" 452 "SharedLegacy" = "11:FALSE" 453 "PackageAs" = "3:1" 454 "Register" = "3:1" 455 "Exclude" = "11:FALSE" 456 "IsDependency" = "11:FALSE" 457 "IsolateTo" = "8:" 458 } 459 "{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_B7492250D3DFC9E86EDFC1F888FB6225" 460 { 461 "SourcePath" = "8:MSO9.DLL" 462 "TargetName" = "8:MSO9.DLL" 463 "Tag" = "8:" 464 "Folder" = "8:_A71B9F4A6F7A4846B9A8121692FB34D3" 465 "Condition" = "8:" 466 "Transitive" = "11:FALSE" 467 "Vital" = "11:TRUE" 468 "ReadOnly" = "11:FALSE" 469 "Hidden" = "11:FALSE" 470 "System" = "11:FALSE" 471 "Permanent" = "11:FALSE" 472 "SharedLegacy" = "11:FALSE" 473 "PackageAs" = "3:1" 474 "Register" = "3:1" 475 "Exclude" = "11:FALSE" 476 "IsDependency" = "11:TRUE" 477 "IsolateTo" = "8:" 478 } 479 "{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_C68843D336D1FA86D4CB277E88BE49CE" 389 480 { 390 481 "AssemblyRegister" = "3:1" … … 393 484 "ScatterAssemblies" 394 485 { 395 "_ 64F2494A3F7471FFE0251D304E2D9EC7"486 "_C68843D336D1FA86D4CB277E88BE49CE" 396 487 { 397 488 "Name" = "8:Interop.Word.dll" … … 417 508 "IsolateTo" = "8:" 418 509 } 419 "{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_ 6C6DB793A8DA3CF4F3943CD8BBC6D521"510 "{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_CC2D346B584D9209A0B0C23E19E16393" 420 511 { 421 512 "AssemblyRegister" = "3:1" 422 "AssemblyIsInGAC" = "11: FALSE"423 "AssemblyAsmDisplayName" = "8:Microsoft.ReportViewer. WinForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL"513 "AssemblyIsInGAC" = "11:TRUE" 514 "AssemblyAsmDisplayName" = "8:Microsoft.ReportViewer.ProcessingObjectModel, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL" 424 515 "ScatterAssemblies" 425 516 { 426 "_ 6C6DB793A8DA3CF4F3943CD8BBC6D521"427 { 428 "Name" = "8:Microsoft.ReportViewer. WinForms.dll"517 "_CC2D346B584D9209A0B0C23E19E16393" 518 { 519 "Name" = "8:Microsoft.ReportViewer.ProcessingObjectModel.dll" 429 520 "Attributes" = "3:512" 430 521 } 431 522 } 432 "SourcePath" = "8:Microsoft.ReportViewer. WinForms.dll"523 "SourcePath" = "8:Microsoft.ReportViewer.ProcessingObjectModel.dll" 433 524 "TargetName" = "8:" 434 525 "Tag" = "8:" … … 448 539 "IsolateTo" = "8:" 449 540 } 450 "{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_81209E5699A9F4F3741B8B24D034F5A2" 451 { 452 "SourcePath" = "8:EXCEL9.OLB" 453 "TargetName" = "8:EXCEL9.OLB" 454 "Tag" = "8:" 455 "Folder" = "8:_A71B9F4A6F7A4846B9A8121692FB34D3" 456 "Condition" = "8:" 457 "Transitive" = "11:FALSE" 458 "Vital" = "11:TRUE" 459 "ReadOnly" = "11:FALSE" 460 "Hidden" = "11:FALSE" 461 "System" = "11:FALSE" 462 "Permanent" = "11:FALSE" 463 "SharedLegacy" = "11:FALSE" 464 "PackageAs" = "3:1" 465 "Register" = "3:1" 466 "Exclude" = "11:FALSE" 467 "IsDependency" = "11:TRUE" 468 "IsolateTo" = "8:" 469 } 470 "{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_8C96984BF8E1FE9643D1021B3C804DA1" 541 "{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_E949949BEB2DFFD45A0493C54D411F71" 471 542 { 472 543 "AssemblyRegister" = "3:1" … … 475 546 "ScatterAssemblies" 476 547 { 477 "_ 8C96984BF8E1FE9643D1021B3C804DA1"548 "_E949949BEB2DFFD45A0493C54D411F71" 478 549 { 479 550 "Name" = "8:Interop.VBIDE.dll" … … 499 570 "IsolateTo" = "8:" 500 571 } 501 "{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_90355BBD5BDA4A8FB195EB7C7A954ADA" 502 { 503 "SourcePath" = "8:..\\BazaReklam\\cab.ico" 504 "TargetName" = "8:cab.ico" 505 "Tag" = "8:" 506 "Folder" = "8:_A71B9F4A6F7A4846B9A8121692FB34D3" 507 "Condition" = "8:" 508 "Transitive" = "11:FALSE" 509 "Vital" = "11:TRUE" 510 "ReadOnly" = "11:FALSE" 511 "Hidden" = "11:FALSE" 512 "System" = "11:FALSE" 513 "Permanent" = "11:FALSE" 514 "SharedLegacy" = "11:FALSE" 515 "PackageAs" = "3:1" 516 "Register" = "3:1" 517 "Exclude" = "11:FALSE" 518 "IsDependency" = "11:FALSE" 519 "IsolateTo" = "8:" 520 } 521 "{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_AA4022385237E4501A89AC0D13FEF94D" 572 "{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_EB843BFFB9344F29AF52E5F834254602" 522 573 { 523 574 "AssemblyRegister" = "3:1" … … 526 577 "ScatterAssemblies" 527 578 { 528 "_ AA4022385237E4501A89AC0D13FEF94D"579 "_EB843BFFB9344F29AF52E5F834254602" 529 580 { 530 581 "Name" = "8:Interop.Excel.dll" … … 533 584 } 534 585 "SourcePath" = "8:Interop.Excel.dll" 535 "TargetName" = "8:"536 "Tag" = "8:"537 "Folder" = "8:_A71B9F4A6F7A4846B9A8121692FB34D3"538 "Condition" = "8:"539 "Transitive" = "11:FALSE"540 "Vital" = "11:TRUE"541 "ReadOnly" = "11:FALSE"542 "Hidden" = "11:FALSE"543 "System" = "11:FALSE"544 "Permanent" = "11:FALSE"545 "SharedLegacy" = "11:FALSE"546 "PackageAs" = "3:1"547 "Register" = "3:1"548 "Exclude" = "11:FALSE"549 "IsDependency" = "11:TRUE"550 "IsolateTo" = "8:"551 }552 "{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_B7492250D3DFC9E86EDFC1F888FB6225"553 {554 "SourcePath" = "8:MSO9.DLL"555 "TargetName" = "8:MSO9.DLL"556 "Tag" = "8:"557 "Folder" = "8:_A71B9F4A6F7A4846B9A8121692FB34D3"558 "Condition" = "8:"559 "Transitive" = "11:FALSE"560 "Vital" = "11:TRUE"561 "ReadOnly" = "11:FALSE"562 "Hidden" = "11:FALSE"563 "System" = "11:FALSE"564 "Permanent" = "11:FALSE"565 "SharedLegacy" = "11:FALSE"566 "PackageAs" = "3:1"567 "Register" = "3:1"568 "Exclude" = "11:FALSE"569 "IsDependency" = "11:TRUE"570 "IsolateTo" = "8:"571 }572 "{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_CC2D346B584D9209A0B0C23E19E16393"573 {574 "AssemblyRegister" = "3:1"575 "AssemblyIsInGAC" = "11:TRUE"576 "AssemblyAsmDisplayName" = "8:Microsoft.ReportViewer.ProcessingObjectModel, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL"577 "ScatterAssemblies"578 {579 "_CC2D346B584D9209A0B0C23E19E16393"580 {581 "Name" = "8:Microsoft.ReportViewer.ProcessingObjectModel.dll"582 "Attributes" = "3:512"583 }584 }585 "SourcePath" = "8:Microsoft.ReportViewer.ProcessingObjectModel.dll"586 586 "TargetName" = "8:" 587 587 "Tag" = "8:" -
trunk/RaportySQL/ListaReklamA3.rdl
r735 r738 16 16 </Values> 17 17 </DefaultValue> 18 <AllowBlank>true</AllowBlank> 19 <Prompt>tytul</Prompt> 18 <Prompt>TytuÅ:</Prompt> 20 19 <ValidValues> 21 20 <DataSetReference> … … 29 28 <DataType>String</DataType> 30 29 <AllowBlank>true</AllowBlank> 31 <Prompt> nr wydania</Prompt>30 <Prompt>Nr wydania:</Prompt> 32 31 </ReportParameter> 33 32 <ReportParameter Name="agencja"> 34 33 <DataType>String</DataType> 35 34 <Nullable>true</Nullable> 36 <Prompt> agencja</Prompt>35 <Prompt>Agencja:</Prompt> 37 36 <ValidValues> 38 37 <DataSetReference> … … 46 45 <DataType>String</DataType> 47 46 <Nullable>true</Nullable> 48 <Prompt> agent</Prompt>47 <Prompt>Agent:</Prompt> 49 48 <ValidValues> 50 49 <DataSetReference> … … 57 56 <ReportParameter Name="grzbiet"> 58 57 <DataType>Integer</DataType> 59 <Nullable>true</Nullable> 60 <Prompt>grzbiet</Prompt> 58 <DefaultValue> 59 <DataSetReference> 60 <DataSetName>ListaGrzebietow</DataSetName> 61 <ValueField>ID</ValueField> 62 </DataSetReference> 63 </DefaultValue> 64 <Prompt>Grzbiet:</Prompt> 61 65 <ValidValues> 62 66 <DataSetReference> … … 66 70 </DataSetReference> 67 71 </ValidValues> 72 <MultiValue>true</MultiValue> 73 </ReportParameter> 74 <ReportParameter Name="dzial"> 75 <DataType>String</DataType> 76 <DefaultValue> 77 <DataSetReference> 78 <DataSetName>ListaDzialow</DataSetName> 79 <ValueField>Id</ValueField> 80 </DataSetReference> 81 </DefaultValue> 82 <AllowBlank>true</AllowBlank> 83 <Prompt>DziaÅy:</Prompt> 84 <ValidValues> 85 <DataSetReference> 86 <DataSetName>ListaDzialow</DataSetName> 87 <ValueField>Id</ValueField> 88 <LabelField>Name</LabelField> 89 </DataSetReference> 90 </ValidValues> 91 <MultiValue>true</MultiValue> 68 92 </ReportParameter> 69 93 <ReportParameter Name="sortuj"> … … 88 112 </ParameterValues> 89 113 </ValidValues> 90 </ReportParameter>91 <ReportParameter Name="dzial">92 <DataType>String</DataType>93 <DefaultValue>94 <DataSetReference>95 <DataSetName>ListaDzialow</DataSetName>96 <ValueField>Id</ValueField>97 </DataSetReference>98 </DefaultValue>99 <AllowBlank>true</AllowBlank>100 <Prompt>DziaÅy:</Prompt>101 <ValidValues>102 <DataSetReference>103 <DataSetName>ListaDzialow</DataSetName>104 <ValueField>Id</ValueField>105 <LabelField>Name</LabelField>106 </DataSetReference>107 </ValidValues>108 <MultiValue>true</MultiValue>109 114 </ReportParameter> 110 115 </ReportParameters> … … 344 349 FROM GRZBIETY 345 350 WHERE Active=1 AND TytulId=@tytul 346 UNION347 SELECT NULL ,'Wszystkie'348 351 ORDER BY Nazwa</CommandText> 349 352 <QueryParameters> … … 391 394 </DataSet> 392 395 </DataSets> 393 <Code /> 394 <Width>25.5cm</Width> 396 <Code>Public Function GetMultiSelectLabels(P as Parameter) as String 397 Dim i As Integer 398 Dim s As String 399 s = p.Label(0) 400 For i = 1 to Ubound(P.Value) 401 s = s + ", " + p.Label(i) 402 Next i 403 Return s 404 End Function</Code> 405 <Width>24.52646cm</Width> 395 406 <Body> 396 407 <ColumnSpacing>1cm</ColumnSpacing> 397 408 <ReportItems> 409 <Textbox Name="textbox3"> 410 <Top>1.2cm</Top> 411 <Width>2.55cm</Width> 412 <Style> 413 <FontSize>12pt</FontSize> 414 <FontWeight>700</FontWeight> 415 <Format>d</Format> 416 <TextAlign>Left</TextAlign> 417 <PaddingLeft>2pt</PaddingLeft> 418 <PaddingRight>2pt</PaddingRight> 419 <PaddingTop>2pt</PaddingTop> 420 <PaddingBottom>2pt</PaddingBottom> 421 <Language>pl-PL</Language> 422 </Style> 423 <ZIndex>4</ZIndex> 424 <CanGrow>true</CanGrow> 425 <Height>0.75cm</Height> 426 <Value>Grzbiet(y):</Value> 427 </Textbox> 428 <Textbox Name="textbox7"> 429 <Top>1.2cm</Top> 430 <Width>21.45cm</Width> 431 <Style> 432 <FontSize>12pt</FontSize> 433 <Format>d</Format> 434 <TextAlign>Left</TextAlign> 435 <PaddingLeft>2pt</PaddingLeft> 436 <PaddingRight>2pt</PaddingRight> 437 <PaddingTop>2pt</PaddingTop> 438 <PaddingBottom>2pt</PaddingBottom> 439 <Language>pl-PL</Language> 440 </Style> 441 <ZIndex>3</ZIndex> 442 <CanGrow>true</CanGrow> 443 <Left>2.55cm</Left> 444 <Height>0.75cm</Height> 445 <Value>=Code.GetMultiSelectLabels(Parameters!grzbiet)</Value> 446 </Textbox> 398 447 <Textbox Name="textbox6"> 399 448 <Top>0.25cm</Top> … … 410 459 <Language>pl-PL</Language> 411 460 </Style> 412 <ZIndex> 3</ZIndex>461 <ZIndex>2</ZIndex> 413 462 <CanGrow>true</CanGrow> 414 463 <Left>15.5cm</Left> 415 464 <Height>0.75cm</Height> 416 465 <Value>=Today</Value> 417 </Textbox>418 <Textbox Name="textbox5">419 <Top>0.25cm</Top>420 <Width>4.5cm</Width>421 <Style>422 <FontSize>12pt</FontSize>423 <FontWeight>700</FontWeight>424 <Format>d</Format>425 <TextAlign>Left</TextAlign>426 <PaddingLeft>2pt</PaddingLeft>427 <PaddingRight>2pt</PaddingRight>428 <PaddingTop>2pt</PaddingTop>429 <PaddingBottom>2pt</PaddingBottom>430 <Language>pl-PL</Language>431 </Style>432 <ZIndex>2</ZIndex>433 <CanGrow>true</CanGrow>434 <Left>11.5cm</Left>435 <Height>0.75cm</Height>436 <Value>="Grzbiet: " & Parameters!grzbiet.Label</Value>437 466 </Textbox> 438 467 <Textbox Name="textbox17"> … … 457 486 <Table Name="table1"> 458 487 <DataSetName>ListaReklam</DataSetName> 459 <Top>1.25cm</Top> 460 <Width>24.52646cm</Width> 488 <Top>2.1cm</Top> 461 489 <Details> 462 490 <TableRows> … … 1316 1344 </Table> 1317 1345 </ReportItems> 1318 <Height> 2.88492cm</Height>1346 <Height>3.73492cm</Height> 1319 1347 </Body> 1320 1348 <Language>pl-PL</Language> -
trunk/RaportySQL/ListaReklamA4.rdl
r735 r738 16 16 </Values> 17 17 </DefaultValue> 18 <AllowBlank>true</AllowBlank> 19 <Prompt>tytul</Prompt> 18 <Prompt>TytuÅ:</Prompt> 20 19 <ValidValues> 21 20 <DataSetReference> … … 28 27 <ReportParameter Name="nrwydania"> 29 28 <DataType>String</DataType> 30 <AllowBlank>true</AllowBlank> 31 <Prompt>nr wydania</Prompt> 29 <Prompt>Nr wydania:</Prompt> 32 30 </ReportParameter> 33 31 <ReportParameter Name="agencja"> 34 32 <DataType>String</DataType> 35 33 <Nullable>true</Nullable> 36 <Prompt> agencja</Prompt>34 <Prompt>Agencja:</Prompt> 37 35 <ValidValues> 38 36 <DataSetReference> … … 46 44 <DataType>String</DataType> 47 45 <Nullable>true</Nullable> 48 <Prompt> agent</Prompt>46 <Prompt>Agent:</Prompt> 49 47 <ValidValues> 50 48 <DataSetReference> … … 57 55 <ReportParameter Name="grzbiet"> 58 56 <DataType>Integer</DataType> 59 <Nullable>true</Nullable> 60 <Prompt>grzbiet</Prompt> 57 <DefaultValue> 58 <DataSetReference> 59 <DataSetName>ListaGrzebietow</DataSetName> 60 <ValueField>ID</ValueField> 61 </DataSetReference> 62 </DefaultValue> 63 <Prompt>Grzbiet:</Prompt> 61 64 <ValidValues> 62 65 <DataSetReference> … … 66 69 </DataSetReference> 67 70 </ValidValues> 71 <MultiValue>true</MultiValue> 68 72 </ReportParameter> 69 73 <ReportParameter Name="sortuj"> … … 75 79 </DefaultValue> 76 80 <AllowBlank>true</AllowBlank> 77 <Prompt> sortuj</Prompt>81 <Prompt>Sortuj:</Prompt> 78 82 <ValidValues> 79 83 <ParameterValues> … … 117 121 <BottomMargin>1cm</BottomMargin> 118 122 <rd:ReportID>c8c9d8c9-35ad-4718-921a-81280b453acf</rd:ReportID> 119 <PageWidth>2 9.7cm</PageWidth>123 <PageWidth>21cm</PageWidth> 120 124 <DataSets> 121 125 <DataSet Name="ListaReklam"> … … 344 348 FROM GRZBIETY 345 349 WHERE Active=1 AND TytulId=@tytul 346 UNION347 SELECT NULL ,'Wszystkie'348 350 ORDER BY Nazwa</CommandText> 349 351 <QueryParameters> … … 391 393 </DataSet> 392 394 </DataSets> 393 <Code /> 394 <Width>25.5cm</Width> 395 <Code>Public Function GetMultiSelectLabels(P as Parameter) as String 396 Dim i As Integer 397 Dim s As String 398 s = p.Label(0) 399 For i = 1 to Ubound(P.Value) 400 s = s + ", " + p.Label(i) 401 Next i 402 Return s 403 End Function</Code> 404 <Width>18.97646cm</Width> 395 405 <Body> 396 406 <ColumnSpacing>1cm</ColumnSpacing> 397 407 <ReportItems> 408 <Textbox Name="textbox4"> 409 <Top>1.05cm</Top> 410 <Width>2.55cm</Width> 411 <Style> 412 <FontSize>12pt</FontSize> 413 <FontWeight>700</FontWeight> 414 <Format>d</Format> 415 <TextAlign>Left</TextAlign> 416 <PaddingLeft>2pt</PaddingLeft> 417 <PaddingRight>2pt</PaddingRight> 418 <PaddingTop>2pt</PaddingTop> 419 <PaddingBottom>2pt</PaddingBottom> 420 <Language>pl-PL</Language> 421 </Style> 422 <ZIndex>4</ZIndex> 423 <CanGrow>true</CanGrow> 424 <Height>0.75cm</Height> 425 <Value>Grzbiet(y):</Value> 426 </Textbox> 398 427 <Textbox Name="textbox6"> 399 <Top>0. 25cm</Top>428 <Top>0.3cm</Top> 400 429 <Width>3cm</Width> 401 430 <Style> … … 412 441 <ZIndex>3</ZIndex> 413 442 <CanGrow>true</CanGrow> 414 <Left>15. 5cm</Left>443 <Left>15.9cm</Left> 415 444 <Height>0.75cm</Height> 416 445 <Value>=Today</Value> 417 446 </Textbox> 418 447 <Textbox Name="textbox5"> 419 <Top> 0.25cm</Top>420 <Width> 4.5cm</Width>448 <Top>1.05cm</Top> 449 <Width>16.35cm</Width> 421 450 <Style> 422 451 <FontSize>12pt</FontSize> 423 <FontWeight>700</FontWeight>424 452 <Format>d</Format> 425 453 <TextAlign>Left</TextAlign> … … 432 460 <ZIndex>2</ZIndex> 433 461 <CanGrow>true</CanGrow> 434 <Left> 11.5cm</Left>462 <Left>2.55cm</Left> 435 463 <Height>0.75cm</Height> 436 <Value>= "Grzbiet: " & Parameters!grzbiet.Label</Value>464 <Value>=Code.GetMultiSelectLabels(Parameters!grzbiet)</Value> 437 465 </Textbox> 438 466 <Textbox Name="textbox17"> … … 457 485 <Table Name="table1"> 458 486 <DataSetName>ListaReklam</DataSetName> 459 <Top>1.25cm</Top> 460 <Width>24.52646cm</Width> 487 <Top>1.95cm</Top> 461 488 <Details> 462 489 <TableRows> … … 465 492 <TableCell> 466 493 <ReportItems> 467 <Textbox Name="agencja">468 <rd:DefaultName>agencja</rd:DefaultName>469 <Style>470 <BorderColor>471 <Default>LightGrey</Default>472 </BorderColor>473 <BorderStyle>474 <Default>Solid</Default>475 </BorderStyle>476 <BorderWidth>477 <Default>0.5pt</Default>478 </BorderWidth>479 <FontSize>7pt</FontSize>480 <VerticalAlign>Middle</VerticalAlign>481 <PaddingLeft>2pt</PaddingLeft>482 <PaddingRight>2pt</PaddingRight>483 <PaddingTop>2pt</PaddingTop>484 <PaddingBottom>2pt</PaddingBottom>485 <Language>pl-PL</Language>486 </Style>487 <ZIndex>11</ZIndex>488 <CanGrow>true</CanGrow>489 <Value>=Left(Fields!agencja.Value,10)</Value>490 </Textbox>491 </ReportItems>492 </TableCell>493 <TableCell>494 <ReportItems>495 494 <Textbox Name="ID_REKLAMY"> 496 495 <rd:DefaultName>ID_REKLAMY</rd:DefaultName> … … 515 514 <Language>pl-PL</Language> 516 515 </Style> 517 <ZIndex> 10</ZIndex>516 <ZIndex>9</ZIndex> 518 517 <CanGrow>true</CanGrow> 519 518 <Value>=Fields!ID_REKLAMY.Value</Value> … … 545 544 <Language>pl-PL</Language> 546 545 </Style> 547 <ZIndex> 9</ZIndex>546 <ZIndex>8</ZIndex> 548 547 <CanGrow>true</CanGrow> 549 548 <Value>=Fields!SZER.Value</Value> … … 575 574 <Language>pl-PL</Language> 576 575 </Style> 577 <ZIndex> 8</ZIndex>576 <ZIndex>7</ZIndex> 578 577 <CanGrow>true</CanGrow> 579 578 <Value>=Fields!WYS.Value</Value> 579 </Textbox> 580 </ReportItems> 581 </TableCell> 582 <TableCell> 583 <ReportItems> 584 <Textbox Name="ogl_dzial"> 585 <rd:DefaultName>ogl_dzial</rd:DefaultName> 586 <Style> 587 <BorderColor> 588 <Default>LightGrey</Default> 589 </BorderColor> 590 <BorderStyle> 591 <Default>Solid</Default> 592 </BorderStyle> 593 <BorderWidth> 594 <Default>0.5pt</Default> 595 </BorderWidth> 596 <FontSize>7pt</FontSize> 597 <TextAlign>Center</TextAlign> 598 <VerticalAlign>Middle</VerticalAlign> 599 <PaddingLeft>2pt</PaddingLeft> 600 <PaddingRight>2pt</PaddingRight> 601 <PaddingTop>2pt</PaddingTop> 602 <PaddingBottom>2pt</PaddingBottom> 603 </Style> 604 <ZIndex>6</ZIndex> 605 <CanGrow>true</CanGrow> 606 <Value>=Fields!Dzial.Value</Value> 607 </Textbox> 608 </ReportItems> 609 </TableCell> 610 <TableCell> 611 <ReportItems> 612 <Textbox Name="ogl_rozdzial"> 613 <rd:DefaultName>ogl_rozdzial</rd:DefaultName> 614 <Style> 615 <BorderColor> 616 <Default>LightGrey</Default> 617 </BorderColor> 618 <BorderStyle> 619 <Default>Solid</Default> 620 </BorderStyle> 621 <BorderWidth> 622 <Default>0.5pt</Default> 623 </BorderWidth> 624 <FontSize>7pt</FontSize> 625 <TextAlign>Center</TextAlign> 626 <VerticalAlign>Middle</VerticalAlign> 627 <PaddingLeft>2pt</PaddingLeft> 628 <PaddingRight>2pt</PaddingRight> 629 <PaddingTop>2pt</PaddingTop> 630 <PaddingBottom>2pt</PaddingBottom> 631 </Style> 632 <ZIndex>5</ZIndex> 633 <CanGrow>true</CanGrow> 634 <Value>=Fields!Rozdzial.Value</Value> 635 </Textbox> 636 </ReportItems> 637 </TableCell> 638 <TableCell> 639 <ReportItems> 640 <Textbox Name="lokalizacja"> 641 <rd:DefaultName>lokalizacja</rd:DefaultName> 642 <Style> 643 <BorderColor> 644 <Default>LightGrey</Default> 645 </BorderColor> 646 <BorderStyle> 647 <Default>Solid</Default> 648 </BorderStyle> 649 <BorderWidth> 650 <Default>0.5pt</Default> 651 </BorderWidth> 652 <FontSize>7pt</FontSize> 653 <TextAlign>Center</TextAlign> 654 <VerticalAlign>Middle</VerticalAlign> 655 <PaddingLeft>2pt</PaddingLeft> 656 <PaddingRight>2pt</PaddingRight> 657 <PaddingTop>2pt</PaddingTop> 658 <PaddingBottom>2pt</PaddingBottom> 659 <Language>pl-PL</Language> 660 </Style> 661 <ZIndex>4</ZIndex> 662 <CanGrow>true</CanGrow> 663 <Value>=Fields!lokalizacja1.Value</Value> 664 </Textbox> 665 </ReportItems> 666 </TableCell> 667 <TableCell> 668 <ReportItems> 669 <Textbox Name="textbox16"> 670 <Style> 671 <BorderColor> 672 <Default>LightGrey</Default> 673 </BorderColor> 674 <BorderStyle> 675 <Default>Solid</Default> 676 </BorderStyle> 677 <BorderWidth> 678 <Default>0.5pt</Default> 679 </BorderWidth> 680 <FontSize>7pt</FontSize> 681 <TextAlign>Center</TextAlign> 682 <VerticalAlign>Middle</VerticalAlign> 683 <PaddingLeft>2pt</PaddingLeft> 684 <PaddingRight>2pt</PaddingRight> 685 <PaddingTop>2pt</PaddingTop> 686 <PaddingBottom>2pt</PaddingBottom> 687 <Language>pl-PL</Language> 688 </Style> 689 <ZIndex>3</ZIndex> 690 <CanGrow>true</CanGrow> 691 <Value>=Fields!lokalizacja.Value</Value> 692 </Textbox> 693 </ReportItems> 694 </TableCell> 695 <TableCell> 696 <ReportItems> 697 <Textbox Name="textbox20"> 698 <rd:DefaultName>textbox20</rd:DefaultName> 699 <Style> 700 <BorderColor> 701 <Default>LightGrey</Default> 702 </BorderColor> 703 <BorderStyle> 704 <Default>Solid</Default> 705 </BorderStyle> 706 <BorderWidth> 707 <Default>0.5pt</Default> 708 </BorderWidth> 709 <FontSize>7pt</FontSize> 710 <TextAlign>Center</TextAlign> 711 <VerticalAlign>Middle</VerticalAlign> 712 <PaddingLeft>2pt</PaddingLeft> 713 <PaddingRight>2pt</PaddingRight> 714 <PaddingTop>2pt</PaddingTop> 715 <PaddingBottom>2pt</PaddingBottom> 716 </Style> 717 <ZIndex>2</ZIndex> 718 <CanGrow>true</CanGrow> 719 <Value>=Left(Fields!NICK_NAME.Value,15)</Value> 580 720 </Textbox> 581 721 </ReportItems> … … 604 744 <Language>pl-PL</Language> 605 745 </Style> 606 <ZIndex> 7</ZIndex>746 <ZIndex>1</ZIndex> 607 747 <CanGrow>true</CanGrow> 608 748 <Value>=Fields!MOD_TYP.Value</Value> 609 </Textbox>610 </ReportItems>611 </TableCell>612 <TableCell>613 <ReportItems>614 <Textbox Name="NICK_NAME">615 <rd:DefaultName>NICK_NAME</rd:DefaultName>616 <Style>617 <BorderColor>618 <Default>LightGrey</Default>619 </BorderColor>620 <BorderStyle>621 <Default>Solid</Default>622 </BorderStyle>623 <BorderWidth>624 <Default>0.5pt</Default>625 </BorderWidth>626 <FontSize>7pt</FontSize>627 <TextAlign>Center</TextAlign>628 <VerticalAlign>Middle</VerticalAlign>629 <PaddingLeft>2pt</PaddingLeft>630 <PaddingRight>2pt</PaddingRight>631 <PaddingTop>2pt</PaddingTop>632 <PaddingBottom>2pt</PaddingBottom>633 <Language>pl-PL</Language>634 </Style>635 <ZIndex>6</ZIndex>636 <CanGrow>true</CanGrow>637 <Value>=Left(Fields!NICK_NAME.Value,15)</Value>638 </Textbox>639 </ReportItems>640 </TableCell>641 <TableCell>642 <ReportItems>643 <Textbox Name="ogl_dzial">644 <rd:DefaultName>ogl_dzial</rd:DefaultName>645 <Style>646 <BorderColor>647 <Default>LightGrey</Default>648 </BorderColor>649 <BorderStyle>650 <Default>Solid</Default>651 </BorderStyle>652 <BorderWidth>653 <Default>0.5pt</Default>654 </BorderWidth>655 <FontSize>7pt</FontSize>656 <TextAlign>Center</TextAlign>657 <VerticalAlign>Middle</VerticalAlign>658 <PaddingLeft>2pt</PaddingLeft>659 <PaddingRight>2pt</PaddingRight>660 <PaddingTop>2pt</PaddingTop>661 <PaddingBottom>2pt</PaddingBottom>662 </Style>663 <ZIndex>5</ZIndex>664 <CanGrow>true</CanGrow>665 <Value>=Fields!Dzial.Value</Value>666 </Textbox>667 </ReportItems>668 </TableCell>669 <TableCell>670 <ReportItems>671 <Textbox Name="ogl_rozdzial">672 <rd:DefaultName>ogl_rozdzial</rd:DefaultName>673 <Style>674 <BorderColor>675 <Default>LightGrey</Default>676 </BorderColor>677 <BorderStyle>678 <Default>Solid</Default>679 </BorderStyle>680 <BorderWidth>681 <Default>0.5pt</Default>682 </BorderWidth>683 <FontSize>7pt</FontSize>684 <TextAlign>Center</TextAlign>685 <VerticalAlign>Middle</VerticalAlign>686 <PaddingLeft>2pt</PaddingLeft>687 <PaddingRight>2pt</PaddingRight>688 <PaddingTop>2pt</PaddingTop>689 <PaddingBottom>2pt</PaddingBottom>690 </Style>691 <ZIndex>4</ZIndex>692 <CanGrow>true</CanGrow>693 <Value>=Fields!Rozdzial.Value</Value>694 </Textbox>695 </ReportItems>696 </TableCell>697 <TableCell>698 <ReportItems>699 <Textbox Name="lokalizacja">700 <rd:DefaultName>lokalizacja</rd:DefaultName>701 <Style>702 <BorderColor>703 <Default>LightGrey</Default>704 </BorderColor>705 <BorderStyle>706 <Default>Solid</Default>707 </BorderStyle>708 <BorderWidth>709 <Default>0.5pt</Default>710 </BorderWidth>711 <FontSize>7pt</FontSize>712 <TextAlign>Center</TextAlign>713 <VerticalAlign>Middle</VerticalAlign>714 <PaddingLeft>2pt</PaddingLeft>715 <PaddingRight>2pt</PaddingRight>716 <PaddingTop>2pt</PaddingTop>717 <PaddingBottom>2pt</PaddingBottom>718 <Language>pl-PL</Language>719 </Style>720 <ZIndex>3</ZIndex>721 <CanGrow>true</CanGrow>722 <Value>=Fields!lokalizacja1.Value</Value>723 </Textbox>724 </ReportItems>725 </TableCell>726 <TableCell>727 <ReportItems>728 <Textbox Name="textbox16">729 <Style>730 <BorderColor>731 <Default>LightGrey</Default>732 </BorderColor>733 <BorderStyle>734 <Default>Solid</Default>735 </BorderStyle>736 <BorderWidth>737 <Default>0.5pt</Default>738 </BorderWidth>739 <FontSize>7pt</FontSize>740 <TextAlign>Center</TextAlign>741 <VerticalAlign>Middle</VerticalAlign>742 <PaddingLeft>2pt</PaddingLeft>743 <PaddingRight>2pt</PaddingRight>744 <PaddingTop>2pt</PaddingTop>745 <PaddingBottom>2pt</PaddingBottom>746 <Language>pl-PL</Language>747 </Style>748 <ZIndex>2</ZIndex>749 <CanGrow>true</CanGrow>750 <Value>=Fields!lokalizacja.Value</Value>751 </Textbox>752 </ReportItems>753 </TableCell>754 <TableCell>755 <ReportItems>756 <Textbox Name="STRONA">757 <rd:DefaultName>STRONA</rd:DefaultName>758 <Style>759 <BorderColor>760 <Default>LightGrey</Default>761 </BorderColor>762 <BorderStyle>763 <Default>Solid</Default>764 </BorderStyle>765 <BorderWidth>766 <Default>0.5pt</Default>767 </BorderWidth>768 <FontSize>7pt</FontSize>769 <TextAlign>Center</TextAlign>770 <VerticalAlign>Middle</VerticalAlign>771 <PaddingLeft>2pt</PaddingLeft>772 <PaddingRight>2pt</PaddingRight>773 <PaddingTop>2pt</PaddingTop>774 <PaddingBottom>2pt</PaddingBottom>775 <Language>pl-PL</Language>776 </Style>777 <ZIndex>1</ZIndex>778 <CanGrow>true</CanGrow>779 <Value>=Fields!STRONA.Value</Value>780 749 </Textbox> 781 750 </ReportItems> … … 805 774 </Style> 806 775 <CanGrow>true</CanGrow> 807 <Value>=Fields! nazwaGrzbietu.Value</Value>776 <Value>=Fields!STRONA.Value</Value> 808 777 </Textbox> 809 778 </ReportItems> … … 828 797 <TableCells> 829 798 <TableCell> 830 <ColSpan> 6</ColSpan>799 <ColSpan>5</ColSpan> 831 800 <ReportItems> 832 801 <Textbox Name="textbox37"> … … 856 825 <Language>pl-PL</Language> 857 826 </Style> 858 <ZIndex>2 5</ZIndex>827 <ZIndex>21</ZIndex> 859 828 <CanGrow>true</CanGrow> 860 829 <Value>=Count(Fields!ReklamaID.Value) & " REK" & " " & Sum(Fields!WYS.Value*Fields!SZER.Value) & " MOD" & " " & Round(Sum(Fields!WYS.Value*Fields!SZER.Value)/64) & " stron"</Value> … … 863 832 </TableCell> 864 833 <TableCell> 865 <ColSpan> 6</ColSpan>834 <ColSpan>5</ColSpan> 866 835 <ReportItems> 867 836 <Textbox Name="textbox24"> … … 891 860 <PaddingBottom>2pt</PaddingBottom> 892 861 </Style> 893 <ZIndex>2 4</ZIndex>862 <ZIndex>20</ZIndex> 894 863 <CanGrow>true</CanGrow> 895 864 <Value>=Sum(Fields!CENA_JEDN.Value) - Sum(Fields!RABAT_WARTOÅÄ.Value)</Value> … … 904 873 <TableCell> 905 874 <ReportItems> 906 <Textbox Name="textbox1">907 <rd:DefaultName>textbox1</rd:DefaultName>908 <Style>909 <BackgroundColor>WhiteSmoke</BackgroundColor>910 <BorderColor>911 <Default>LightGrey</Default>912 </BorderColor>913 <BorderStyle>914 <Default>Solid</Default>915 </BorderStyle>916 <BorderWidth>917 <Default>0.5pt</Default>918 </BorderWidth>919 <FontSize>7pt</FontSize>920 <FontWeight>700</FontWeight>921 <TextAlign>Center</TextAlign>922 <VerticalAlign>Middle</VerticalAlign>923 <PaddingLeft>2pt</PaddingLeft>924 <PaddingRight>2pt</PaddingRight>925 <PaddingTop>2pt</PaddingTop>926 <PaddingBottom>2pt</PaddingBottom>927 <Language>pl-PL</Language>928 </Style>929 <ZIndex>23</ZIndex>930 <CanGrow>true</CanGrow>931 <Value>Agencja</Value>932 </Textbox>933 </ReportItems>934 </TableCell>935 <TableCell>936 <ReportItems>937 875 <Textbox Name="textbox25"> 938 876 <rd:DefaultName>textbox25</rd:DefaultName> … … 958 896 <Language>pl-PL</Language> 959 897 </Style> 960 <ZIndex> 22</ZIndex>898 <ZIndex>19</ZIndex> 961 899 <CanGrow>true</CanGrow> 962 900 <Value>Symbol </Value> … … 989 927 <Language>pl-PL</Language> 990 928 </Style> 991 <ZIndex> 21</ZIndex>929 <ZIndex>18</ZIndex> 992 930 <CanGrow>true</CanGrow> 993 931 <Value>S</Value> … … 1020 958 <Language>pl-PL</Language> 1021 959 </Style> 1022 <ZIndex> 20</ZIndex>960 <ZIndex>17</ZIndex> 1023 961 <CanGrow>true</CanGrow> 1024 962 <Value>W</Value> 963 </Textbox> 964 </ReportItems> 965 </TableCell> 966 <TableCell> 967 <ReportItems> 968 <Textbox Name="textbox26"> 969 <rd:DefaultName>textbox26</rd:DefaultName> 970 <Style> 971 <BackgroundColor>WhiteSmoke</BackgroundColor> 972 <BorderColor> 973 <Default>LightGrey</Default> 974 </BorderColor> 975 <BorderStyle> 976 <Default>Solid</Default> 977 </BorderStyle> 978 <BorderWidth> 979 <Default>0.5pt</Default> 980 </BorderWidth> 981 <FontSize>7pt</FontSize> 982 <FontWeight>700</FontWeight> 983 <TextAlign>Center</TextAlign> 984 <VerticalAlign>Middle</VerticalAlign> 985 <PaddingLeft>2pt</PaddingLeft> 986 <PaddingRight>2pt</PaddingRight> 987 <PaddingTop>2pt</PaddingTop> 988 <PaddingBottom>2pt</PaddingBottom> 989 </Style> 990 <ZIndex>16</ZIndex> 991 <CanGrow>true</CanGrow> 992 <Value>DziaÅ</Value> 993 </Textbox> 994 </ReportItems> 995 </TableCell> 996 <TableCell> 997 <ReportItems> 998 <Textbox Name="textbox21"> 999 <rd:DefaultName>textbox21</rd:DefaultName> 1000 <Style> 1001 <BackgroundColor>WhiteSmoke</BackgroundColor> 1002 <BorderColor> 1003 <Default>LightGrey</Default> 1004 </BorderColor> 1005 <BorderStyle> 1006 <Default>Solid</Default> 1007 </BorderStyle> 1008 <BorderWidth> 1009 <Default>0.5pt</Default> 1010 </BorderWidth> 1011 <FontSize>7pt</FontSize> 1012 <FontWeight>700</FontWeight> 1013 <TextAlign>Center</TextAlign> 1014 <VerticalAlign>Middle</VerticalAlign> 1015 <PaddingLeft>2pt</PaddingLeft> 1016 <PaddingRight>2pt</PaddingRight> 1017 <PaddingTop>2pt</PaddingTop> 1018 <PaddingBottom>2pt</PaddingBottom> 1019 </Style> 1020 <ZIndex>15</ZIndex> 1021 <CanGrow>true</CanGrow> 1022 <Value>Roz</Value> 1023 </Textbox> 1024 </ReportItems> 1025 </TableCell> 1026 <TableCell> 1027 <ReportItems> 1028 <Textbox Name="textbox10"> 1029 <rd:DefaultName>textbox10</rd:DefaultName> 1030 <Style> 1031 <BackgroundColor>WhiteSmoke</BackgroundColor> 1032 <BorderColor> 1033 <Default>LightGrey</Default> 1034 </BorderColor> 1035 <BorderStyle> 1036 <Default>Solid</Default> 1037 </BorderStyle> 1038 <BorderWidth> 1039 <Default>0.5pt</Default> 1040 </BorderWidth> 1041 <FontSize>7pt</FontSize> 1042 <FontWeight>700</FontWeight> 1043 <TextAlign>Center</TextAlign> 1044 <VerticalAlign>Middle</VerticalAlign> 1045 <PaddingLeft>2pt</PaddingLeft> 1046 <PaddingRight>2pt</PaddingRight> 1047 <PaddingTop>2pt</PaddingTop> 1048 <PaddingBottom>2pt</PaddingBottom> 1049 <Language>pl-PL</Language> 1050 </Style> 1051 <ZIndex>14</ZIndex> 1052 <CanGrow>true</CanGrow> 1053 <Value>Lokalizacja</Value> 1054 </Textbox> 1055 </ReportItems> 1056 </TableCell> 1057 <TableCell> 1058 <ReportItems> 1059 <Textbox Name="textbox14"> 1060 <rd:DefaultName>textbox14</rd:DefaultName> 1061 <Style> 1062 <BackgroundColor>WhiteSmoke</BackgroundColor> 1063 <BorderColor> 1064 <Default>LightGrey</Default> 1065 </BorderColor> 1066 <BorderStyle> 1067 <Default>Solid</Default> 1068 </BorderStyle> 1069 <BorderWidth> 1070 <Default>0.5pt</Default> 1071 </BorderWidth> 1072 <FontSize>7pt</FontSize> 1073 <FontWeight>700</FontWeight> 1074 <TextAlign>Center</TextAlign> 1075 <VerticalAlign>Middle</VerticalAlign> 1076 <PaddingLeft>2pt</PaddingLeft> 1077 <PaddingRight>2pt</PaddingRight> 1078 <PaddingTop>2pt</PaddingTop> 1079 <PaddingBottom>2pt</PaddingBottom> 1080 </Style> 1081 <ZIndex>13</ZIndex> 1082 <CanGrow>true</CanGrow> 1083 <Value>Uwagi</Value> 1084 </Textbox> 1085 </ReportItems> 1086 </TableCell> 1087 <TableCell> 1088 <ReportItems> 1089 <Textbox Name="textbox9"> 1090 <rd:DefaultName>textbox9</rd:DefaultName> 1091 <Style> 1092 <BackgroundColor>WhiteSmoke</BackgroundColor> 1093 <BorderColor> 1094 <Default>LightGrey</Default> 1095 </BorderColor> 1096 <BorderStyle> 1097 <Default>Solid</Default> 1098 </BorderStyle> 1099 <BorderWidth> 1100 <Default>0.5pt</Default> 1101 </BorderWidth> 1102 <FontSize>7pt</FontSize> 1103 <FontWeight>700</FontWeight> 1104 <TextAlign>Center</TextAlign> 1105 <VerticalAlign>Middle</VerticalAlign> 1106 <PaddingLeft>2pt</PaddingLeft> 1107 <PaddingRight>2pt</PaddingRight> 1108 <PaddingTop>2pt</PaddingTop> 1109 <PaddingBottom>2pt</PaddingBottom> 1110 </Style> 1111 <ZIndex>12</ZIndex> 1112 <CanGrow>true</CanGrow> 1113 <Value>Klient</Value> 1025 1114 </Textbox> 1026 1115 </ReportItems> … … 1051 1140 <Language>pl-PL</Language> 1052 1141 </Style> 1053 <ZIndex>1 9</ZIndex>1142 <ZIndex>11</ZIndex> 1054 1143 <CanGrow>true</CanGrow> 1055 1144 <Value>ModuÅ</Value> 1056 </Textbox>1057 </ReportItems>1058 </TableCell>1059 <TableCell>1060 <ReportItems>1061 <Textbox Name="textbox13">1062 <rd:DefaultName>textbox13</rd:DefaultName>1063 <Style>1064 <BackgroundColor>WhiteSmoke</BackgroundColor>1065 <BorderColor>1066 <Default>LightGrey</Default>1067 </BorderColor>1068 <BorderStyle>1069 <Default>Solid</Default>1070 </BorderStyle>1071 <BorderWidth>1072 <Default>0.5pt</Default>1073 </BorderWidth>1074 <FontSize>7pt</FontSize>1075 <FontWeight>700</FontWeight>1076 <TextAlign>Center</TextAlign>1077 <VerticalAlign>Middle</VerticalAlign>1078 <PaddingLeft>2pt</PaddingLeft>1079 <PaddingRight>2pt</PaddingRight>1080 <PaddingTop>2pt</PaddingTop>1081 <PaddingBottom>2pt</PaddingBottom>1082 <Language>pl-PL</Language>1083 </Style>1084 <ZIndex>18</ZIndex>1085 <CanGrow>true</CanGrow>1086 <Value>Klient</Value>1087 </Textbox>1088 </ReportItems>1089 </TableCell>1090 <TableCell>1091 <ReportItems>1092 <Textbox Name="textbox26">1093 <rd:DefaultName>textbox26</rd:DefaultName>1094 <Style>1095 <BackgroundColor>WhiteSmoke</BackgroundColor>1096 <BorderColor>1097 <Default>LightGrey</Default>1098 </BorderColor>1099 <BorderStyle>1100 <Default>Solid</Default>1101 </BorderStyle>1102 <BorderWidth>1103 <Default>0.5pt</Default>1104 </BorderWidth>1105 <FontSize>7pt</FontSize>1106 <FontWeight>700</FontWeight>1107 <TextAlign>Center</TextAlign>1108 <VerticalAlign>Middle</VerticalAlign>1109 <PaddingLeft>2pt</PaddingLeft>1110 <PaddingRight>2pt</PaddingRight>1111 <PaddingTop>2pt</PaddingTop>1112 <PaddingBottom>2pt</PaddingBottom>1113 </Style>1114 <ZIndex>17</ZIndex>1115 <CanGrow>true</CanGrow>1116 <Value>DziaÅ</Value>1117 </Textbox>1118 </ReportItems>1119 </TableCell>1120 <TableCell>1121 <ReportItems>1122 <Textbox Name="textbox21">1123 <rd:DefaultName>textbox21</rd:DefaultName>1124 <Style>1125 <BackgroundColor>WhiteSmoke</BackgroundColor>1126 <BorderColor>1127 <Default>LightGrey</Default>1128 </BorderColor>1129 <BorderStyle>1130 <Default>Solid</Default>1131 </BorderStyle>1132 <BorderWidth>1133 <Default>0.5pt</Default>1134 </BorderWidth>1135 <FontSize>7pt</FontSize>1136 <FontWeight>700</FontWeight>1137 <TextAlign>Center</TextAlign>1138 <VerticalAlign>Middle</VerticalAlign>1139 <PaddingLeft>2pt</PaddingLeft>1140 <PaddingRight>2pt</PaddingRight>1141 <PaddingTop>2pt</PaddingTop>1142 <PaddingBottom>2pt</PaddingBottom>1143 </Style>1144 <ZIndex>16</ZIndex>1145 <CanGrow>true</CanGrow>1146 <Value>Roz</Value>1147 </Textbox>1148 </ReportItems>1149 </TableCell>1150 <TableCell>1151 <ReportItems>1152 <Textbox Name="textbox10">1153 <rd:DefaultName>textbox10</rd:DefaultName>1154 <Style>1155 <BackgroundColor>WhiteSmoke</BackgroundColor>1156 <BorderColor>1157 <Default>LightGrey</Default>1158 </BorderColor>1159 <BorderStyle>1160 <Default>Solid</Default>1161 </BorderStyle>1162 <BorderWidth>1163 <Default>0.5pt</Default>1164 </BorderWidth>1165 <FontSize>7pt</FontSize>1166 <FontWeight>700</FontWeight>1167 <TextAlign>Center</TextAlign>1168 <VerticalAlign>Middle</VerticalAlign>1169 <PaddingLeft>2pt</PaddingLeft>1170 <PaddingRight>2pt</PaddingRight>1171 <PaddingTop>2pt</PaddingTop>1172 <PaddingBottom>2pt</PaddingBottom>1173 <Language>pl-PL</Language>1174 </Style>1175 <ZIndex>15</ZIndex>1176 <CanGrow>true</CanGrow>1177 <Value>Lokalizacja</Value>1178 </Textbox>1179 </ReportItems>1180 </TableCell>1181 <TableCell>1182 <ReportItems>1183 <Textbox Name="textbox14">1184 <rd:DefaultName>textbox14</rd:DefaultName>1185 <Style>1186 <BackgroundColor>WhiteSmoke</BackgroundColor>1187 <BorderColor>1188 <Default>LightGrey</Default>1189 </BorderColor>1190 <BorderStyle>1191 <Default>Solid</Default>1192 </BorderStyle>1193 <BorderWidth>1194 <Default>0.5pt</Default>1195 </BorderWidth>1196 <FontSize>7pt</FontSize>1197 <FontWeight>700</FontWeight>1198 <TextAlign>Center</TextAlign>1199 <VerticalAlign>Middle</VerticalAlign>1200 <PaddingLeft>2pt</PaddingLeft>1201 <PaddingRight>2pt</PaddingRight>1202 <PaddingTop>2pt</PaddingTop>1203 <PaddingBottom>2pt</PaddingBottom>1204 </Style>1205 <ZIndex>14</ZIndex>1206 <CanGrow>true</CanGrow>1207 <Value>Uwagi</Value>1208 </Textbox>1209 </ReportItems>1210 </TableCell>1211 <TableCell>1212 <ReportItems>1213 <Textbox Name="textbox4">1214 <rd:DefaultName>textbox4</rd:DefaultName>1215 <Style>1216 <BackgroundColor>WhiteSmoke</BackgroundColor>1217 <BorderColor>1218 <Default>LightGrey</Default>1219 </BorderColor>1220 <BorderStyle>1221 <Default>Solid</Default>1222 </BorderStyle>1223 <BorderWidth>1224 <Default>0.5pt</Default>1225 </BorderWidth>1226 <FontSize>7pt</FontSize>1227 <FontWeight>700</FontWeight>1228 <TextAlign>Center</TextAlign>1229 <VerticalAlign>Middle</VerticalAlign>1230 <PaddingLeft>2pt</PaddingLeft>1231 <PaddingRight>2pt</PaddingRight>1232 <PaddingTop>2pt</PaddingTop>1233 <PaddingBottom>2pt</PaddingBottom>1234 <Language>pl-PL</Language>1235 </Style>1236 <ZIndex>13</ZIndex>1237 <CanGrow>true</CanGrow>1238 <Value>Str</Value>1239 1145 </Textbox> 1240 1146 </ReportItems> … … 1265 1171 <Language>pl-PL</Language> 1266 1172 </Style> 1267 <ZIndex>1 2</ZIndex>1268 <CanGrow>true</CanGrow> 1269 <Value> Grzbiet</Value>1173 <ZIndex>10</ZIndex> 1174 <CanGrow>true</CanGrow> 1175 <Value>Str</Value> 1270 1176 </Textbox> 1271 1177 </ReportItems> … … 1277 1183 </Header> 1278 1184 <TableColumns> 1279 <TableColumn>1280 <Width>1.35cm</Width>1281 </TableColumn>1282 1185 <TableColumn> 1283 1186 <Width>2cm</Width> … … 1288 1191 <TableColumn> 1289 1192 <Width>0.5cm</Width> 1290 </TableColumn>1291 <TableColumn>1292 <Width>1.27646cm</Width>1293 </TableColumn>1294 <TableColumn>1295 <Width>4.35cm</Width>1296 1193 </TableColumn> 1297 1194 <TableColumn> … … 1308 1205 </TableColumn> 1309 1206 <TableColumn> 1310 <Width> 1.05cm</Width>1207 <Width>2.25cm</Width> 1311 1208 </TableColumn> 1312 1209 <TableColumn> 1313 <Width>1.8cm</Width> 1210 <Width>1.27646cm</Width> 1211 </TableColumn> 1212 <TableColumn> 1213 <Width>0.75cm</Width> 1314 1214 </TableColumn> 1315 1215 </TableColumns> 1316 1216 </Table> 1317 1217 </ReportItems> 1318 <Height> 2.88492cm</Height>1218 <Height>3.58492cm</Height> 1319 1219 </Body> 1320 1220 <Language>pl-PL</Language> 1321 1221 <TopMargin>1cm</TopMargin> 1322 <PageHeight> 42cm</PageHeight>1222 <PageHeight>29.7cm</PageHeight> 1323 1223 </Report> -
trunk/RaportySQL/ListaReklamNaWydanieNr.rdl
r733 r738 11 11 <ReportParameter Name="tytul"> 12 12 <DataType>String</DataType> 13 <Nullable>true</Nullable>14 13 <DefaultValue> 15 14 <Values> … … 57 56 <ReportParameter Name="grzbiet"> 58 57 <DataType>String</DataType> 59 <Nullable>true</Nullable> 58 <DefaultValue> 59 <DataSetReference> 60 <DataSetName>ListaGrzebietow</DataSetName> 61 <ValueField>ID</ValueField> 62 </DataSetReference> 63 </DefaultValue> 60 64 <Prompt>Grzbiet:</Prompt> 61 65 <ValidValues> … … 66 70 </DataSetReference> 67 71 </ValidValues> 72 <MultiValue>true</MultiValue> 68 73 </ReportParameter> 69 74 <ReportParameter Name="sortuj"> … … 182 187 </Field> 183 188 <Field Name="agencja"> 184 <DataField> agencja</DataField>189 <DataField>Agencja</DataField> 185 190 <rd:TypeName>System.String</rd:TypeName> 186 191 </Field> … … 220 225 <DataField>zafakturowana</DataField> 221 226 <rd:TypeName>System.Boolean</rd:TypeName> 227 </Field> 228 <Field Name="Dzial"> 229 <DataField>Dzial</DataField> 230 <rd:TypeName>System.String</rd:TypeName> 231 </Field> 232 <Field Name="Rozdzial"> 233 <DataField>Rozdzial</DataField> 234 <rd:TypeName>System.String</rd:TypeName> 222 235 </Field> 223 236 </Fields> … … 337 350 FROM GRZBIETY 338 351 WHERE Active=1 AND TytulId=@tytul 339 UNION340 SELECT NULL ,'Wszystkie'341 352 ORDER BY Nazwa</CommandText> 342 353 <QueryParameters> … … 384 395 </DataSet> 385 396 </DataSets> 386 <Code /> 387 <Width>25cm</Width> 397 <Code>Public Function GetMultiSelectLabels(P as Parameter) as String 398 Dim i As Integer 399 Dim s As String 400 s = p.Label(0) 401 For i = 1 to Ubound(P.Value) 402 s = s + ", " + p.Label(i) 403 Next i 404 Return s 405 End Function</Code> 406 <Width>23.61254cm</Width> 388 407 <Body> 389 408 <ColumnSpacing>1cm</ColumnSpacing> 390 409 <ReportItems> 410 <Textbox Name="textbox5"> 411 <Top>1.05cm</Top> 412 <Width>2.55cm</Width> 413 <Style> 414 <FontSize>12pt</FontSize> 415 <FontWeight>700</FontWeight> 416 <Format>d</Format> 417 <TextAlign>Left</TextAlign> 418 <PaddingLeft>2pt</PaddingLeft> 419 <PaddingRight>2pt</PaddingRight> 420 <PaddingTop>2pt</PaddingTop> 421 <PaddingBottom>2pt</PaddingBottom> 422 <Language>pl-PL</Language> 423 </Style> 424 <ZIndex>4</ZIndex> 425 <CanGrow>true</CanGrow> 426 <Height>0.75cm</Height> 427 <Value>Grzbiet(y):</Value> 428 </Textbox> 429 <Textbox Name="textbox14"> 430 <Top>1.05cm</Top> 431 <Width>16.35cm</Width> 432 <Style> 433 <FontSize>12pt</FontSize> 434 <Format>d</Format> 435 <TextAlign>Left</TextAlign> 436 <PaddingLeft>2pt</PaddingLeft> 437 <PaddingRight>2pt</PaddingRight> 438 <PaddingTop>2pt</PaddingTop> 439 <PaddingBottom>2pt</PaddingBottom> 440 <Language>pl-PL</Language> 441 </Style> 442 <ZIndex>3</ZIndex> 443 <CanGrow>true</CanGrow> 444 <Left>2.55cm</Left> 445 <Height>0.75cm</Height> 446 <Value>=Code.GetMultiSelectLabels(Parameters!grzbiet)</Value> 447 </Textbox> 391 448 <Textbox Name="textbox6"> 392 449 <Top>0.25cm</Top> … … 403 460 <Language>pl-PL</Language> 404 461 </Style> 405 <ZIndex> 3</ZIndex>462 <ZIndex>2</ZIndex> 406 463 <CanGrow>true</CanGrow> 407 <Left>1 6.2cm</Left>464 <Left>15.9cm</Left> 408 465 <Height>0.75cm</Height> 409 466 <Value>=Today</Value> 410 </Textbox>411 <Textbox Name="textbox5">412 <Top>0.25cm</Top>413 <Width>4.5cm</Width>414 <Style>415 <FontSize>12pt</FontSize>416 <FontWeight>700</FontWeight>417 <Format>d</Format>418 <TextAlign>Left</TextAlign>419 <PaddingLeft>2pt</PaddingLeft>420 <PaddingRight>2pt</PaddingRight>421 <PaddingTop>2pt</PaddingTop>422 <PaddingBottom>2pt</PaddingBottom>423 <Language>pl-PL</Language>424 </Style>425 <ZIndex>2</ZIndex>426 <CanGrow>true</CanGrow>427 <Left>11.5cm</Left>428 <Height>0.75cm</Height>429 <Value>="Grzbiet: " & Parameters!grzbiet.Label</Value>430 467 </Textbox> 431 468 <Textbox Name="textbox17"> … … 450 487 <Table Name="table1"> 451 488 <DataSetName>ListaReklam</DataSetName> 452 <Top>1.25cm</Top> 453 <Width>23.61255cm</Width> 489 <Top>1.95cm</Top> 454 490 <Details> 455 491 <TableRows> … … 1579 1615 </Table> 1580 1616 </ReportItems> 1581 <Height> 2.88492cm</Height>1617 <Height>3.58492cm</Height> 1582 1618 </Body> 1583 1619 <Language>pl-PL</Language> -
trunk/RaportySQL/RaportySQL.rptproj
r732 r738 234 234 </ProjectItem> 235 235 <ProjectItem> 236 <Name>SprzedazProwizje.rdl</Name> 237 <FullPath>SprzedazProwizje.rdl</FullPath> 238 </ProjectItem> 239 <ProjectItem> 236 240 <Name>SprzedazReklam.rdl</Name> 237 241 <FullPath>SprzedazReklam.rdl</FullPath> … … 418 422 </ProjectItem> 419 423 <ProjectItem> 420 <Name> SprzedazProwizje.rdl</Name>421 <FullPath> SprzedazProwizje.rdl</FullPath>424 <Name>ListaReklamA4.rdl</Name> 425 <FullPath>ListaReklamA4.rdl</FullPath> 422 426 </ProjectItem> 423 427 </Reports> -
trunk/SQL/StoredProcedures/sp_GetListaReklamNaWydanie.txt
r734 r738 17 17 @agencja INT = NULL, 18 18 @agent INT = NULL, 19 @grzbiet INT= NULL19 @grzbiet VARCHAR(2000) = NULL 20 20 21 21 AS … … 29 29 Id int 30 30 ) 31 31 32 32 IF @dzial='0' 33 33 SET @dzial=NULL … … 44 44 IF (SELECT Count(Id) FROM @dzialTable) > 0 45 45 SET @wszystkieDzialy=1 46 47 DECLARE @grzbietTable TABLE 48 ( 49 Id int 50 ) 51 52 IF @grzbiet='0' OR @grzbiet IS NULL 53 SET @grzbiet=NULL 54 55 IF @dzial IS NOT NULL 56 BEGIN 57 INSERT INTO @grzbietTable 58 SELECT * FROM [BAZA_REKLAM].[dbo].[SplitAsTable] (@grzbiet, ',') 59 END 46 60 47 61 -- Insert statements for procedure here … … 90 104 AND 91 105 ( 92 (@agencja IS NULL AND @agent IS NULL AND @grzbiet IS NULL)106 (@agencja IS NULL AND @agent IS NULL) 93 107 OR 94 (@agencja IS NULL AND @agent IS NULL AND R.GRZBIET = @grzbiet) 95 OR 96 (@agencja IS NULL AND A2.ID_AGENTA = @agent AND @grzbiet IS NULL) 108 (@agencja IS NULL AND A2.ID_AGENTA = @agent) 97 109 OR 98 ( @agencja IS NULL AND A2.ID_AGENTA = @agent AND R.GRZBIET = @grzbiet)110 (A.Id_agencji = @agencja AND @agent IS NULL) 99 111 OR 100 (A.Id_agencji = @agencja AND @agent IS NULL AND @grzbiet IS NULL) 101 OR 102 (A.Id_agencji = @agencja AND @agent IS NULL AND R.GRZBIET = @grzbiet) 103 OR 104 (A.Id_agencji = @agencja AND A2.ID_AGENTA = @agent AND @grzbiet IS NULL) 105 OR 106 (A.Id_agencji = @agencja AND A2.ID_AGENTA = @agent AND R.GRZBIET = @grzbiet) 112 (A.Id_agencji = @agencja AND A2.ID_AGENTA = @agent) 107 113 ) 108 114 AND 109 115 (@wszystkieDzialy = 0 OR R.ogl_dzial IN (SELECT Id FROM @dzialTable) OR R.ogl_dzial IS NULL) 116 AND 117 (R.GRZBIET IN (SELECT Id FROM @grzbietTable)) 110 118 111 119 ORDER BY R.[ID REKLAMY]
