Система бизнес-аналитики Stimulsoft | Форум

Инструмент бизнес-аналитики от компании Stimulsoft. Программное обеспечение для создания дашбордов и отчетов. Инструменты отчетности для любой платформы.
https://forum.stimulsoft.ru/

UseCache

https://forum.stimulsoft.ru/viewtopic.php?t=1222

Страница 2 из 2

UseCache

Добавлено: 28 сен 2010, 03:27
Vasiliy Goncharenko
Пожалуйста проверьте в режиме отладки, вызывается ли данное событие и правильно ли загружается отчёт MyReport.
Если всё верно, то пришлите нам строку отчёта, полученную при помощи функции SC.SCData.ExecuteScalar...
Вроде ошибок нет.
Ниже строка отчета:

Код: Выделить всё

 


 


EazyQA_Aces 
Data Source=HOST_DELL;Initial Catalog=EazyQA_Aces;Persist Security Info=True;User ID=funnylogin;Password=funnypassword 
EazyQA_Aces 
False 




Users 

UserID,System.Int32 
FirstName,System.String 
LastName,System.String 
FullName,System.String 
UserAbbreviation,System.String 
LoginName,System.String 
LoginPassword,System.String 
UserTitleID,System.Int32 
Contacts_Phone_Work,System.String 
Contacts_Phone_WorkExt,System.String 
Contacts_Phone_Home,System.String 
Contacts_Phone_Cell,System.String 
Contacts_Pager,System.String 
Contacts_Fax,System.String 
Contacts_eMail,System.String 
SecurityGroupID,System.Int32 
Cla_LimitedToClientID,System.Int32 
Cla_LimitTransactionMaxAmount,System.Int32 
Cla_MaxAmount_PaymentInd,System.Decimal 
Cla_MaxAmount_PaymentExp,System.Decimal 
Cla_MaxAmount_PaymentRec,System.Decimal 
Cla_MaxAmount_ReserveChangeInd,System.Decimal 
Cla_MaxAmount_ReserveChangeExp,System.Decimal 
RT_Paycheck_Rate,System.Decimal 
RT_DiaryList_ShowCompleted,System.Int32 
RT_DiaryList_ShowExpired,System.Int32 
RT_SlipsList_ShowDescription,System.Int32 
RT_Slip_Rate,System.Decimal 
RT_Slip_MinimumSlipTime,System.Int32 
RT_Slip_AutostartTimerWithNewSlip,System.Int32 
RT_Slip_TimeDiscrete_Minutes,System.Int32 
QA_TicketsList_ShowDescription,System.Int32 
QA_eMail_MyTicket_NotifyWhenActivityHappened,System.Int32 
QA_eMail_MyTicket_NotifyWhenStatusChanged,System.Int32 
QA_eMail_MyTicket_NotifyWhenTicketClosed,System.Int32 
QA_eMail_NotifyWhenNewTicketAssigned,System.Int32 
AccountDisabled,System.Int32 
DateEntered,System.DateTime 
DateChanged,System.DateTime 

 
Users 
EazyQA_Aces.Users 


Tickets 

TicketID,System.Int32 
TicketTypeID,System.Int32 
ProductID,System.Int32 
ProductVersionID,System.Int32 
VersionNumber,System.String 
VersionDate,System.DateTime 
VersionNumberAndDate,System.String 
Title,System.String 
Description,System.String 
HowToReproduce,System.String 
UserEnvironment,System.String 
AttachedFile,System.String 
Link,System.String 
TicketSeverityID,System.Int32 
TicketPriorityID,System.Int32 
ReportedByUserID,System.Int32 
ResponsibleUserID,System.Int32 
ResponsibleUserName,System.String 
CompletionOrder,System.Int32 
CompletionOrder_str,System.String 
TicketedByUserName,System.String 
TicketedByUserAbbreviation,System.String 
ProductName,System.String 
ProductCode,System.String 
TicketTypeName,System.String 
TicketTypeColor,System.String 
DateUpdated,System.DateTime 
UpdateDays,System.Int32 
DaysSinceLastUpdate,System.Int32 
TicketClosed,System.Int32 
DateClosed,System.DateTime 
TicketStageID,System.Int32 
TicketStageName,System.String 
TicketPrevStageID,System.Int32 
TicketPrevStageName,System.String 
TicketPrevStageManagerID,System.Int32 
TicketPrevStageManagerName,System.String 
TicketStageManagerID,System.Int32 
TicketStageManagerName,System.String 
TicketAssignedToUserID,System.Int32 
TicketAssignedToUserName,System.String 
EstimatedCompletion_Days,System.Int32 
EstimatedCompletion_Hours,System.Decimal 
EstimatedCompletion_TotalHours,System.Decimal 
TicketPriorityName,System.String 
TicketSeverityName,System.String 
DateEnterd,System.DateTime 
DateChanged,System.DateTime 
FullName,System.String 
CurrentStageID,System.Int32 
StageName,System.String 
ReportedByClients,System.String 
CurrentStageJobTypeID,System.Int32 

 
Tickets 
EazyQA_Aces.Tickets 


Tickets Resolution 

RecordID,System.Int32 
TicketID,System.Int32 
SlipID,System.Int32 
StageJobTypeID,System.Int32 
AssignedToUserID,System.Int32 
ResponsibleForTicket,System.Boolean 
Time_Duration,System.DateTime 
SlipText,System.String 
Old_PriorityID,System.Int32 
Old_SeverityID,System.Int32 
New_PriorityID,System.Int32 
New_SeverityID,System.Int32 
JobTypeName,System.String 
JobTypeCode,System.String 
AssignedToUserName,System.String 
AssignedToUserCode,System.String 
QA_Stages_StageName,System.String 
NextStage_LastStage,System.Int32 
NextStage_FirstStage,System.Int32 
NextStage_StageName,System.String 
QA_Stages_LastStage,System.Int32 
QA_Stages_FirstStage,System.Int32 
EstimatedCompletion_Days,System.Int32 
EstimatedCompletion_Hours,System.Decimal 
DateChanged,System.DateTime 
DateEntered,System.DateTime 
EnteredByUserID,System.Int32 
EnteredByUserName,System.String 
EnteredByUserCode,System.String 

 
Tickets Resolution 
EazyQA_Aces.Tickets Resolution 




Tickets 

TicketID 

 
 
Tickets 
Tickets Resolution 

TicketID 

 


 
 

EngineV2 
 
 


None;Black;2;Solid;False;4;Black 
White 


Transparent 
0,0.2,7.72,0.7 


Transparent 
0,0,0.8,0.2 
 
Arial,10 
0,0,0,0 
Text5 
 
 
PageNumber 
Black 


Transparent 
0.8,0,0.5,0.2 
 
Arial,10 
0,0,0,0 
Text6 
 
 
{PageNumber} 
Black 


Transparent 
4.9,0,0.8,0.2 
 
Arial,10 
0,0,0,0 
Text10 
 
 
{PageNofM} 
Black 


Transparent 
5.9,0,1,0.2 
 
Arial,10 
0,0,0,0 
Text11 
 
 
TotalPageCount 
Black 


Transparent 
6.9,0,0.8,0.2 
 
Arial,10 
0,0,0,0 
Text12 
 
 
{TotalPageCount} 
Black 


Transparent 
2.9,0,0.7,0.2 
 
Arial,10 
0,0,0,0 
Text13 
 
 
IsFirstPage 
Black 


Transparent 
1.5,0,0.7,0.2 
 
Arial,10 
0,0,0,0 
Text7 
 
 
IsLastPage 
Black 


Transparent 
2.2,0,0.5,0.2 
 
Arial,10 
0,0,0,0 
Text8 
 
 
{IsLastPage} 
Black 


Transparent 
0,0.3,0.7,0.2 
 
Arial,10 
0,0,0,0 
Text15 
 
 
ReportAlias 
Black 


Transparent 
0.7,0.3,0.8,0.2 
 
Arial,10 
0,0,0,0 
Text16 
 
 
{ReportAlias} 
Black 


Transparent 
4.2,0,0.7,0.2 
 
Arial,10 
0,0,0,0 
Text23 
 
 
PageNofM 
Black 


Transparent 
3.6,0,0.4,0.2 
 
Arial,10 
0,0,0,0 
Text24 
 
 
{IsFirstPage} 
Black 


Transparent 
1.7,0.3,0.8,0.2 
 
Arial,10 
0,0,0,0 
Text9 
 
 
ReportAuthor 
Black 


Transparent 
2.5,0.3,0.8,0.2 
 
Arial,10 
0,0,0,0 
Text14 
 
 
{ReportAuthor} 
Black 


Transparent 
0,0.5,0.9,0.2 
 
Arial,10 
0,0,0,0 
Text25 
 
 
ReportCreated 
Black 


Transparent 
0.9,0.5,0.8,0.2 
 
Arial,10 
0,0,0,0 
Text26 
 
 
{ReportCreated} 
Black 


Transparent 
5.4,0.3,1.1,0.2 
 
Arial,10 
0,0,0,0 
Text17 
 
 
ReportDescription 
Black 


Transparent 
6.5,0.3,0.8,0.2 
 
Arial,10 
0,0,0,0 
Text18 
 
 
{ReportDescription} 
Black 


Transparent 
3.5,0.3,0.8,0.2 
 
Arial,10 
0,0,0,0 
Text21 
 
 
ReportName 
Black 


Transparent 
4.3,0.3,0.8,0.2 
 
Arial,10 
0,0,0,0 
Text22 
 
 
{ReportName} 
Black 


Transparent 
1.9,0.5,1,0.2 
 
Arial,10 
0,0,0,0 
Text27 
 
 
ReportChanged 
Black 


Transparent 
2.9,0.5,0.8,0.2 
 
Arial,10 
0,0,0,0 
Text28 
 
 
{ReportChanged} 
Black 


Transparent 
4,0.5,0.4,0.2 
 
Arial,10 
0,0,0,0 
Text29 
 
 
Time 
Black 


Transparent 
4.4,0.5,0.8,0.2 
 
Arial,10 
0,0,0,0 
Text30 
 
 
{Time} 
Black 


Transparent 
5.4,0.5,0.4,0.2 
 
Arial,10 
0,0,0,0 
Text31 
 
 
Today 
Black 


Transparent 
5.8,0.5,0.8,0.2 
 
Arial,10 
0,0,0,0 
Text32 
 
 
{Today} 
Black 


 
PageHeaderBand1 
 
 


Transparent 
 
0,1.3,7.72,0.3 


Transparent 
0.2,0.1,0.5,0.2 
 
Arial,10 
0,0,0,0 
Text1 
 
 
UserID 
Black 


Transparent 
0.7,0.1,0.8,0.2 
 
Arial,10 
0,0,0,0 
Text2 
 
 
{Users.UserID} 
Black 


Transparent 
1.6,0.1,0.7,0.2 
 
Arial,10 
0,0,0,0 
Text3 
 
 
FirstName 
Black 


Transparent 
2.3,0.1,0.8,0.2 
 
Arial,10 
0,0,0,0 
Text4 
 
 
{Users.FirstName} 
Black 


 
Users 
 
Data1 
 
 
 


Transparent 
12.5,3.5,1,0.2 
 
Arial,10 
0,0,0,0 
Text19 
 
 
ReportChanged 
Black 


Transparent 
13.5,3.5,0.8,0.2 
 
Arial,10 
0,0,0,0 
Text20 
 
 
{ReportChanged} 
Black 


 
F43550158512F6829ED6BCBC1E8C612E 
0.39,0.39,0.39,0.39 
Page1 
11 
8.5 
 

Arial,10 
Black 



 

System.Dll 
System.Drawing.Dll 
System.Windows.Forms.Dll 
System.Data.Dll 
System.Xml.Dll 
Stimulsoft.Controls.Dll 
Stimulsoft.Base.Dll 
Stimulsoft.Report.Dll 

My Report Name 
9/8/2010 11:59:50 PM 
9/8/2010 11:59:50 PM 
Report.mrt 
8eb913b62ad4e20e9611bcbc1ea2e060 
My Report Name 
Inches 
2010.2.761 
Imports System Imports System.Drawing Imports System.Windows.Forms Imports System.Data Imports Stimulsoft.Controls Imports Stimulsoft.Base.Drawing Imports Stimulsoft.Report Imports Stimulsoft.Report.Dialogs Imports Stimulsoft.Report.Components Namespace Reports Public Class My_Report_Name Inherits Stimulsoft.Report.StiReport Public Sub New() MyBase.New Me.InitializeComponent End Sub #Region "StiReport Designer generated code - do not modify"#End Region 'StiReport Designer generated code - do not modify End Class End Namespace 
VB

UseCache

Добавлено: 01 окт 2010, 10:18
Vladimir
Здравствуйте,

Извините за задержку ответа.

Мы протестировали присланный вами отчёт, всё работает корректно. Возможно, дело в формате строки, возвращаемой из базы данных. Если формат строки UTF-8, то в начале строки могут содержаться три служебных символа, в этом случае отчёт загрузится с ошибкой. Проверьте пожалуйста этот момент.

Спасибо.

UseCache

Добавлено: 01 окт 2010, 12:02
Vasiliy Goncharenko
Спасибо за ответ. Я проверю и сообщу ... для общего ликбеза. :)

UseCache

Добавлено: 01 окт 2010, 13:51
Andrew
Спасибо!
Часовой пояс: UTC+03:00
Страница 2 из 2

Создано на основе phpBB® Forum Software © phpBB Limited