Thanks Steve I knew it would be something simple 🙂

Datasets in fetchxml are a right pain but if you know of any useful fetch training I'd be glad to hear...

Update: worked it out.  Just noticed error on the report ref aggregate datatypes.  Changed the expression on the chart, adding CDec() around the values (sum(CDec(Opening.Value)) and it works a treat.

Hurrah

If it were running off a sql database I'd absolutely do that, unfortunately Microsoft, in their omnipotent wisdom, are forcing me to use fetchxml as it's a D365 in-the-cloud CRM. ...

Hi Jeffrey

Thanks for the post and pointing me in Megan's direction.  I see there is a workaround but I really shouldn't have to do that should I?  When you say...

Hi Jeffrey

The field I'm using for the parameter is a date/time field and the parameter is set to date/time type.  It's allowing me to enter UK dates at Preview stage...

Hi John

I'm using fetchxml rather than sql as I'm querying Dynamics 365 online.  TBH Microsoft need to improve what you can do with fetch, it's not a patch on sql.

So...

Thank you both for your suggestions - I'm off to have a play now.

Best,

Jules

Gaz, you're a genius, thank you very much.

Cheers

Jules

Thanks very much. I think it was probably more of a 'task' for me to investigate, as we use DPM for all our live server backups now - I...

My boss wanted to know if we could use Policy Management to literally create maintenance plans and then distribute them around the organisation. I think he has now accepted...

Fan-blimmin-tastic thanks very very much. Saved me much time. Now all I gotta do is map away! HAGW Jules

That sounds marvellous but could you add it into the original script please? my sql knowledge is about 0.1% so didn't really understand!

Cheers, Jules

Wow that's great thanks very much. Don't support there's an extra bit that will give a count of all rows in each table? (Pushing it I know!).

Cheers,...

Thanks for your help but I'm afraid you've lost me - perhaps this is just a step too far at the moment. I can see the sql agent job...

1) I guess it's stored on sql server

2) run by sql agent

3) no idea - how can I find out?

ps all I've done is execute this package once - that's...