DynDeveloper.com

In an earlier article we showed how to turn a comma separated list into a table.

I've been using that code for some time, especially when I needed to turn a multi value parameter from SSRS report into something that I can use.

Having done that a few times, it occurred to me that it might be easier to change it into a table value function - now there is no editing, I just include the function in my code and and we're off to the races.

In other words, SSRS gives you something like "apple, banana, pear"

We call the function like this:

And all the work is done for us.

In the code above, 'apple, bannana, pear' come to as as the multi select parameter in SSRS. The function turns this into a table; that table is joined to the main report source and the report source is correctly filtered.

I log into many clients in a day, and I'm sometimes asked to troubleshoot financial data or financial reports. To do that, I often need to know the financial period setup.

I know, I can just go into Dynamics and get that. But that's not me, I'm a back end guy.

Too, I might need to delineate a report by it's period, or some task along that line.

Today I need to evaluate the financial data for one period, hence the script below. This script will return a list of the financial periods and the dates that they encompass.

The result looks something like this:

This code example shows how to export a Telerik WinForms grid to Excel. The example is complete. To use it:

• Drop a RadGridView onto a form (don't add any columns or do any formatting) and copy the code below into the code behind.
• Drop a button on the form to handle the export functionality
• Add a reference to TelerikData.dll to your project

Before I show you this piece of code, I have to tell a story.

I received a request to build a web application that allowed a user to enter an ID and then using that ID as the customer number, enter SOP invoices. eConnect, all that stuff.

I didn't like the fact that the ID would come over in lower case sometimes, becuause CUSTNMBRs in Dynamics are all upper case. So I found this neat piece of code to convert a text box to upper case...

And the customer didn't like it, they made me take it out.

Anyway, for the record, the code below will convert the text typed into a text box to upper case

We've not had a request for an RM Aged Trial balance for some time, it used to be a common thing in GP 9. This week we've had several. Go figure.

I took the opportunity to dust off and improve the script that we use; I included the historical tables.

All:

When coding a report in SSRS with multi select parameters, I need to display the parameter values on the report. If I create a text box and populate it through the Expressions tool, I get '=Parameters!myParameterName.Value(0)', and it only shows the first of the selected parameters.

Any idea how to get them all on there easily?

I see 2001 and 2002.

2001 happens when you create a "DUMMY" lot number for the overall BOM. on that assembly.  EX you post an assembly and when you post it you set a Lot Number for the overall BOM

2002 Refers to the components of BOM for an assembly line.

I would like to be able to check to see if a batch has errors in it without running an edit list.  We are using web services to bring in hundereds of SOP invoices per day into a batch.  I am looking for a VS tools dexterity function or procedure that one could run manually or automatically on the batch and pull out all invoices that are going to error when posting.  Can anyone point me in the right direction on this?

Thanks,

Darren