Welcome to the fracta.net forum!

Share your coding ideas or ask questions.

Question Automate Designer Report (DATE range)

  • Doctore
  • Topic Author
  • Visitor
  • Visitor
8 years 4 months ago #584 by Doctore
Automate Designer Report (DATE range) was created by Doctore
Hi,
I already figured out how to download /automate real-time and historical reports but I came across an issue with designer report date range.
Here is the pice of my code:

cvsSrv.Reports.ACD = 1
Set INFO = cvsSrv.Reports.Reports(PATH)
b = cvsSrv.Reports.CreateReport(INFO, cvsRepProp)
If b Then
cvsRepProp.Window.Top = 11595
cvsRepProp.Window.Left = 15
cvsRepProp.Window.Width = 6450
cvsRepProp.Window.Height = 2850
cvsRepProp.TimeZone = "Europe/Dublin"
cvsRepProp.SetProperty "Agent Group", "" & REP & ""
cvsRepProp.SetProperty "Date", "" & 1 / 1 / 2016 - 3 / 1 / 2016 & ""

When adding the date format, the report doesnt read it and download what was previously entered manually in the report window (CMS).
Any solution for this?
All help will be mostly apreciatted... I cant figure out this thing :(

Thanks !

Please Log in or Create an account to join the conversation.

More
8 years 4 months ago #585 by roller
It doesn't look right the way you crafted the date string. The quickest way to figure this out is to save the CMS report as s script; .acsauto or whatever the extension is. Then use Notepad to open it. Post the content here. But you will see in the text file how the date property should be formatted

Please Log in or Create an account to join the conversation.

  • Doctore
  • Topic Author
  • Visitor
  • Visitor
8 years 4 months ago #586 by Doctore
Replied by Doctore on topic Automate Designer Report (DATE range)
Thanks for quick lookup Roller.
I have already tried doing this. It is working with "Regural" Group Reports but not with the designer one. Here is the format I also tried (copied from script)
Rep.Window.Top = 195
Rep.Window.Left = 1410
Rep.Window.Width = 16470
Rep.Window.Height = 13845
Rep.TimeZone = "Europe/Dublin"
Rep.SetProperty "Agent Group","C CORK ALL"
Rep.SetProperty "Dates","01/01/2016-06/01/2016"
b = Rep.Run

This doesnt work either.

Any clues?

Please Log in or Create an account to join the conversation.

More
8 years 4 months ago #587 by roller
In your vba you have Date but in avaya script it's Dates.

If you already fixed that the please post the full avaya script and your vba scripts in their entirely. That way i can compare both and maybe i can help.

Please Log in or Create an account to join the conversation.

Time to create page: 0.453 seconds
Powered by Kunena Forum