Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Fotoliste von Kursen kann nicht erstellt werden #1223

Open
SchILD-Kloppenburg opened this issue Dec 10, 2024 · 5 comments
Open

Fotoliste von Kursen kann nicht erstellt werden #1223

SchILD-Kloppenburg opened this issue Dec 10, 2024 · 5 comments

Comments

@SchILD-Kloppenburg
Copy link

Ich versuche, eine Fotoliste von Kursen wie in Schild2 zu erstellen.
Neuer Bericht - Datenquelle KursSchueler_Mit_Foto - DBImage (KursSchueler_Mit_Fotos - Foto) einfügen - Voransicht.
Es kommt die Fehlermeldung

Kann den Bericht nicht generieren
KursSchueler_Mit_Fotos: DataSet konnte nicht geöffnet werden
qryKursSchueler_Mit_Foto: Das Feld NotenKrzQuartal konnte nicht gefunden werden.

Ich nutze das Feld nicht und eine Suche im Quelltext mit einem Editor war ebenfalls negativ.
Mich irritiert das qryKursSchueler_Mit_Foto (ohne "s" am Ende). Kann es daran liegen?

@JuergenRichter
Copy link
Collaborator

Bitte mal die Vorlage hier posten

@SchILD-Kloppenburg
Copy link
Author

Leider kann ich den Report nicht anhängen. Hier ist jedoch der Quelltext:

object RepOrt: TppReport
AutoStop = False
DataPipeline = dmPipelines.ppKursSchueler_mit_Fotos
PrinterSetup.BinName = 'Default'
PrinterSetup.DocumentName = 'RepOrt'
PrinterSetup.Duplex = dpNone
PrinterSetup.PaperName = 'A4 210 x 297 mm'
PrinterSetup.PrinterName = 'Screen'
PrinterSetup.SaveDeviceSettings = False
PrinterSetup.mmMarginBottom = 10000
PrinterSetup.mmMarginLeft = 20000
PrinterSetup.mmMarginRight = 10000
PrinterSetup.mmMarginTop = 10000
PrinterSetup.mmPaperHeight = 297000
PrinterSetup.mmPaperWidth = 210000
PrinterSetup.PaperSize = 9
SaveAsTemplate = True
Template.FileName = 'C:\Users\kloppenburg\Documents\Fotoliste.rtm'
Template.Format = ftASCII
Units = utMillimeters
AllowPrintToArchive = True
AllowPrintToFile = True
ArchiveFileName = '($MyDocuments)\ReportArchive.raf'
DeviceType = 'Screen'
DefaultFileDeviceType = 'PDF'
EmailSettings.ReportFormat = 'PDF'
EmailSettings.ConnectionSettings.MailService = 'SMTP'
EmailSettings.ConnectionSettings.WebMail.GmailSettings.OAuth2.AuthStorage = [oasAccessToken, oasRefreshToken]
EmailSettings.ConnectionSettings.WebMail.GmailSettings.OAuth2.RedirectURI = 'http://localhost'
EmailSettings.ConnectionSettings.WebMail.GmailSettings.OAuth2.RedirectPort = 0
EmailSettings.ConnectionSettings.WebMail.Outlook365Settings.OAuth2.AuthStorage = [oasAccessToken, oasRefreshToken]
EmailSettings.ConnectionSettings.WebMail.Outlook365Settings.OAuth2.RedirectURI = 'http://localhost'
EmailSettings.ConnectionSettings.WebMail.Outlook365Settings.OAuth2.RedirectPort = 0
EmailSettings.ConnectionSettings.EnableMultiPlugin = False
EmailSettings.DeleteFile = False
EmailSettings.Enabled = True
EmailSettings.PreviewInEmailClient = False
EmailSettings.ShowEmailDialog = True
Icon.Data = {
0000010001002020100000000000E80200001600000028000000200000004000
0000010004000000000080020000000000000000000000000000000000000000
000000008000008000000080800080000000800080008080000080808000C0C0
C0000000FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
00000000C00000CC00000000000000000000000C0C000C00C000000000000000
0000000C00CCC00000000000000000000000000C000000000000000000000000
00007777C7770000000000000000000000007BBBCBB7000F0000000000000000
00007BCCBBB700FFF00000000000000000007BBBBBB700FFF000000000000000
00007BBBBBB700FF770000000000000000007333BBB7000F7B00000000000000
000070003BB70007B7700000000000000000999903B700007B70000000000000
0001999990770000B7B700000000000000019999900000000B77000000000000
0001999990000000000010000000000000011999900000000071700000000000
0000111100000000001710000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000FFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF7
CFFFFFEBB7FFFFEC3FFFFFEF9FFFFF008FFFFF0087FFFF0083FFFF0083FFFF00
81FFFF00C1FFFF00C0FFFE00E0FFFC00E07FFC03F07FFC03F03FFC03F83FFE07
F83FFF0FFC7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF}
LanguageID = 'Default'
OpenFile = False
OutlineSettings.CreateNode = True
OutlineSettings.CreatePageNodes = True
OutlineSettings.Enabled = True
OutlineSettings.Visible = True
ThumbnailSettings.Enabled = True
ThumbnailSettings.Visible = True
ThumbnailSettings.DeadSpace = 30
ThumbnailSettings.PageHighlight.Width = 3
ThumbnailSettings.ThumbnailSize = tsSmall
PDFSettings.Author = 'Schild-NrW'
PDFSettings.EmbedFontOptions = []
PDFSettings.EncryptSettings.AllowCopy = True
PDFSettings.EncryptSettings.AllowInteract = True
PDFSettings.EncryptSettings.AllowModify = True
PDFSettings.EncryptSettings.AllowPrint = True
PDFSettings.EncryptSettings.AllowExtract = True
PDFSettings.EncryptSettings.AllowAssemble = True
PDFSettings.EncryptSettings.AllowQualityPrint = True
PDFSettings.EncryptSettings.Enabled = False
PDFSettings.EncryptSettings.KeyLength = kl40Bit
PDFSettings.EncryptSettings.EncryptionType = etRC4
PDFSettings.DigitalSignatureSettings.SignPDF = False
PDFSettings.FontEncoding = feAnsi
PDFSettings.ImageCompressionLevel = 25
PDFSettings.PDFAFormat = pafNone
PreviewFormSettings.PageBorder.mmPadding = 0
PreviewFormSettings.SinglePageOnly = True
PreviewFormSettings.WindowState = wsMaximized
PreviewFormSettings.ZoomSetting = zs100Percent
RTFSettings.AppName = 'ReportBuilder'
RTFSettings.Author = 'ReportBuilder'
RTFSettings.DefaultFont.Charset = DEFAULT_CHARSET
RTFSettings.DefaultFont.Color = clWindowText
RTFSettings.DefaultFont.Height = -15
RTFSettings.DefaultFont.Name = 'Arial'
RTFSettings.DefaultFont.Style = []
RTFSettings.Title = 'Report'
TextFileName = '($MyDocuments)\RepOrt.pdf'
TextSearchSettings.DefaultString = ''
TextSearchSettings.Enabled = True
XLSSettings.AppName = 'ReportBuilder'
XLSSettings.Author = 'ReportBuilder'
XLSSettings.Subject = 'Report'
XLSSettings.Title = 'Report'
XLSSettings.WorksheetName = 'Report'
CloudDriveSettings.DropBoxSettings.OAuth2.AuthStorage = [oasAccessToken, oasRefreshToken]
CloudDriveSettings.DropBoxSettings.OAuth2.RedirectURI = 'http://localhost'
CloudDriveSettings.DropBoxSettings.OAuth2.RedirectPort = 0
CloudDriveSettings.DropBoxSettings.DirectorySupport = True
CloudDriveSettings.GoogleDriveSettings.OAuth2.AuthStorage = [oasAccessToken, oasRefreshToken]
CloudDriveSettings.GoogleDriveSettings.OAuth2.RedirectURI = 'http://localhost'
CloudDriveSettings.GoogleDriveSettings.OAuth2.RedirectPort = 0
CloudDriveSettings.GoogleDriveSettings.DirectorySupport = False
CloudDriveSettings.OneDriveSettings.OAuth2.AuthStorage = [oasAccessToken, oasRefreshToken]
CloudDriveSettings.OneDriveSettings.OAuth2.RedirectURI = 'http://localhost'
CloudDriveSettings.OneDriveSettings.OAuth2.RedirectPort = 0
CloudDriveSettings.OneDriveSettings.DirectorySupport = True
Left = 128
Top = 8
Version = '22.03'
mmColumnWidth = 0
DataPipelineName = 'ppKursSchueler_mit_Fotos'
object ppHeaderBand1: TppHeaderBand
Border.mmPadding = 0
mmBottomOffset = 0
mmHeight = 13229
mmPrintPosition = 0
object ppLabel1: TppLabel
DesignLayer = ppDesignLayer1
UserName = 'Label1'
Border.mmPadding = 0
Caption = 'Fotoliste der Kurse'
Font.Charset = DEFAULT_CHARSET
Font.Color = clBlack
Font.Name = 'Arial'
Font.Size = 10
Font.Style = []
FormFieldSettings.FormSubmitInfo.SubmitMethod = fstPost
FormFieldSettings.FormFieldType = fftNone
Transparent = True
mmHeight = 4234
mmLeft = 5027
mmTop = 6085
mmWidth = 29104
BandType = 0
LayerName = Foreground
end
end
object ppDetailBand1: TppDetailBand
Border.mmPadding = 0
PrintHeight = phDynamic
mmBottomOffset = 0
mmHeight = 43656
mmPrintPosition = 0
object ppDBImage1: TppDBImage
DesignLayer = ppDesignLayer1
UserName = 'DBImage1'
AlignHorizontal = ahCenter
AlignVertical = avCenter
MaintainAspectRatio = True
Stretch = True
Border.mmPadding = 0
DataPipeline = dmPipelines.ppKursSchueler_mit_Fotos
GraphicType = 'AutoDetect'
OnGetPicture = ReportImageOnGetPicture
DataPipelineName = 'ppKursSchueler_mit_Fotos'
mmHeight = 35693
mmLeft = 4233
mmTop = 1323
mmWidth = 25566
BandType = 4
LayerName = Foreground
end
object ppDBText1: TppDBText
DesignLayer = ppDesignLayer1
UserName = 'DBText1'
Border.mmPadding = 0
DataField = 'Name'
DataPipeline = dmPipelines.ppKursSchueler_mit_Fotos
Font.Charset = DEFAULT_CHARSET
Font.Color = clBlack
Font.Name = 'Arial'
Font.Size = 10
Font.Style = []
Transparent = True
DataPipelineName = 'ppKursSchueler_mit_Fotos'
mmHeight = 4233
mmLeft = 4233
mmTop = 39423
mmWidth = 17198
BandType = 4
LayerName = Foreground
end
end
object ppFooterBand1: TppFooterBand
Border.mmPadding = 0
mmBottomOffset = 0
mmHeight = 13229
mmPrintPosition = 0
end
object ppDesignLayers1: TppDesignLayers
object ppDesignLayer1: TppDesignLayer
UserName = 'Foreground'
LayerType = ltBanded
Index = 0
end
end
object ppParameterList1: TppParameterList
object ppArchivierung: TppParameter
AutoSearchSettings.LogicalPrefix = []
AutoSearchSettings.Mandatory = True
DataType = dtString
LookupList.Strings = (
'immer'
'nie'
'Schildvorgabe')
LookupSettings.DisplayType = dtNameOnly
LookupSettings.SortOrder = soName
Value = ''
UserName = 'Archivierung'
end
end
end

@Raffenberg
Copy link
Collaborator

Der Report sollet in gezippter Form hier angefügt werden können.

@SchILD-Kloppenburg
Copy link
Author

Das habe ich jetzt erst geschafft.
Kursliste_Foto.zip
Der Report ist nur rudimentär. Sollte die Datenquelle falsch sein und ich sie über einen Subreport einbinden müssen - habe ich schon probiert, es ändert sich nicht.

@AnneSchueller
Copy link
Collaborator

Hier mal der zugehörige Fehlerlog beim Generieren des Reports:

log.txt

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants