Hi Everyone: I was trying to build a report using CDT. However, there

lins over 9 years ago

Hi Everyone:

I was trying to build a report using CDT. However, there's a critical variable (time) which only stored in our SQL database. The time variable shows when the update on each project was entered.

How can I include the time variable stored in our SQL database?

Thanks for the help in advance!

Discussion posts and replies are publicly visible

Parents

0 nileshr over 9 years ago

You can create a view based on your main CDT and include the time column into the view, if you don't want to change the structure of existing main CDT.

After creating a view, create a CDT for the view containing the extra time field and a datastore entity of the same CDT type. Now, you can create a constant of the type datastore entity holding the value of datastore entity for your view.

You can use this constant to create your report through report builder.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 nileshr over 9 years ago

You can create a view based on your main CDT and include the time column into the view, if you don't want to change the structure of existing main CDT.

After creating a view, create a CDT for the view containing the extra time field and a datastore entity of the same CDT type. Now, you can create a constant of the type datastore entity holding the value of datastore entity for your view.

You can use this constant to create your report through report builder.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data